Ubuntu 15.04 open MySQL remote connection

First see if the port is open Netstat-an|grep 3306

This figure is on port 3306, which was previously shown as ... 127.0.0.1:3306 ...

Open MySQL configuration file vi/etc/mysql/mysql.conf.d/mysqld.cnf

Log Off bind-address = 127.0.0.1?

Re-start Ubuntu

See if the port is open again Netstat-an|grep 3306

Port 3306 is now open

Then you can authorize access to MySQL using sudo

Command: sudo mysql-u root-p

Enter your password for the first time, and the second is the MySQL password

The root user is authorized to connect: Grant all privileges on * * to ' root ' @ '% ' identified by ' xxxxxx ';

Last one for MySQL password?

Get permission to take effect immediately: flush privileges;?

So the operation is complete and the MySQL database server can be connected to any host.

Ubuntu 15.04 open MySQL remote connection