Install MySQL on Ubuntu

Install MySQL (5.6) on Ubuntu (14.04)

Install MySQL

During the installation system will ask for root user password.

Check the service after installing mysql

sudo netstat -tap | grep mysql


If database installed cloud/network or not localhost then you need to change bind address to connect from your pc, to change bind address

nano /etc/mysql/my.cnf

To get effect need restart service

Now use ssh or MySQL Workbench as client of mysql database.


Yet, connection error from MySQL Workbench

Failed to Connect to MySQL at with user root

Host ‘’ is not allowed to connect to this MySQL server


To resolve this we need to create user and grant privilege to user

Leave a Reply

Your email address will not be published. Required fields are marked *