Ubuntu Open MySQL remote 3306 port of the detailed

Recently in the play Ubuntu, loaded php+mysql environment, with Navicat connection MySQL found how also not connected, even if the root set to% after still invalid, so found that the MySQL 3306 port is not open to the outside world, find the reason to solve it!

1, first see if the port is open Netstat-an|grep 3306

The 3306 ports shown in the above illustration are: 127.0.0.1 represents a local

2, open the MySQL configuration file sudo vim/etc/mysql/mysql.conf.d/mysqld.cnf

Unregister bind-address = 127.0.0.1

Screenshot of the winning Red Line place

3, restart the Ubuntu system

Execute Netstat-an|grep 3306 again

is not found has changed, in the use of navicat try it!