Rizwan Mansuri's Blog
Python, Django & Linux

Installing MySQL Server on Ubuntu

Here is short version of installation step I used for installation of MySQL server and client application.

Requirement

Ubuntu server

Step 1 - Installing MySQL

sudo apt-get update

sudo apt-get install mysql-server

mysql_secure_installation

Step 2- Testing MySQL Instance

systemctl status mysql.service

If MySQL is not running then you can start with sudo systemctl start mysql

Also, you can connect mysql database using mysqladmin command as following

$ mysqladmin -u root -p

MySQL client for Django application

Following step required to install mysql client in your django application

sudo apt-get install libmysqlclient-dev

pip install mysqlclient to virtualenv

sudo apt-get install python-pip python-dev build-essential