Sunday, November 6, 2016

How to - Enable MySQL Server Remote Connection in Ubuntu 16.04

By default MySQL Server on Ubuntu run on the local interface, This means remote access to the MySQL Server is not Allowed. To enable remote connections to the MySQL Server we need to change value of the bind-address in the MySQL Configuration File.

Open the /etc/mysql/mysql.conf.d/mysqld.cnf file, then change bind-address = 127.0.0.1 into bind-address = 0.0.0.0, then saved you changes.

Now restart mysql services via systemctl restart mysql.service command. MySQL Server now running on the socket 0 0.0.0.0:3306 instead of 127.0.0.1:3306 on all network interface, which allow remote connection.

Plus, now you can add remote user by following how to create new user and grant remote access on mysql tutorial post. Bye!

No comments:

Post a Comment