I follow these instructions to install mysql in Ubuntu 14.04 and it works great. But I make a clean installation of Ubuntu 16.04 and make the same steps to install MySQL and I have problems.

The my.cnf file is clean. I replace the content for my.cnf file from theubuntu 14.04 installation, restart the service and it doesn't work.

At this point I can't allow access to MySQL on a public IP by modifying the bind-address parameter in /etc/my.cnf.


3 Answers 3


The configuration file name and directory change in Ubuntu 16.04 The new file and location here:


You can edit this using:

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf


sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf

I find this solution here:



The configuration file name and directory changed in Ubuntu 16.04 when compared to Ubuntu 14.04. The new file is located here:


You can edit it using:

sudo nano /etc/mysql/mysql.conf.d/mysql.cnf

When we try to edit /etc/mysql/my.cnf file we will see something like this: enter image description here

As the file is protected so we can edit

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf file.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .