<commit_before>title: How to Install and Use MySQL on Ubuntu 16.04
slug: install-mysql-ubuntu-1604 
meta: A quick tutorial to install and use MySQL on Ubuntu 16.04 Xenial Xerus.
category: post
date: 2016-05-28
modified: 2017-04-28
headerimage: /img/160528-mysql-ubuntu-1604/header.jpg
headeralt: MySQL and Ubuntu logos. Copyright their respective owners.


[MySQL](/mysql.html) is a common open source 
[relational database](/databases.html) for creating, reading, updating 
and deleting data in [Python web applications](/web-frameworks.html).
Let's learn how to install MySQL on [Ubuntu 16.04](/ubuntu.html) and then 
run a few SQL queries within the command line client.

We will not go over connecting via Python applications using
[object-relational mappers (ORMs)](/object-relational-mappers-orms.html) 
but these steps can be used as a prerequisite to working with an ORM such 
as SQLAlchemy or Peewee.


## Tools We Need
In this tutorial we'll use the following components:

* [Ubuntu 16.04.2](http://releases.ubuntu.com/16.04/) (this tutorial 
  should also work on other Ubuntu versions)<commit_msg>update date on mysql post<commit_after>title: How to Install and Use MySQL on Ubuntu 16.04
slug: install-mysql-ubuntu-1604 
meta: A quick tutorial to install and use MySQL on Ubuntu 16.04 Xenial Xerus.
category: post
date: 2016-05-28
modified: 2017-12-22
headerimage: /img/160528-mysql-ubuntu-1604/header.jpg
headeralt: MySQL and Ubuntu logos. Copyright their respective owners.


[MySQL](/mysql.html) is a common open source 
[relational database](/databases.html) for creating, reading, updating 
and deleting data in [Python web applications](/web-frameworks.html).
Let's learn how to install MySQL on [Ubuntu 16.04](/ubuntu.html) and then 
run a few SQL queries within the command line client.

We will not go over connecting via Python applications using
[object-relational mappers (ORMs)](/object-relational-mappers-orms.html) 
but these steps can be used as a prerequisite to working with an ORM such 
as SQLAlchemy or Peewee.


## Tools We Need
In this tutorial we'll use the following components:

* [Ubuntu 16.04.2](http://releases.ubuntu.com/16.04/) (this tutorial 
  should also work on other Ubuntu versions)
{'fraction_non_alphanumeric': 0.08520179372197309, 'fraction_numerical': 0.045739910313901344, 'mean_word_length': 4.508641975308642, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6812286', 'n_tokens_mistral': 801, 'n_tokens_neox': 647, 'n_words': 277}