Ubuntu 15.04 opens mysql remote port 3306

Ubuntu 15.04 opens MySQL remote port 3306. All the following operations are performed in the terminal.

First check if the port is open netstat -an | grep 3306

This is a screenshot of opening port 3306. Previously it was displayed as . . . 127.0.0.1:3306 . . .

Open the mysql configuration file vi /etc/mysql/mysql.conf.d/mysqld.cnf
Unregister bind-address = 127.0.0.1

The bottom line of the screenshot is logout

Restart Ubuntu

Check again whether the port is open netstat -an | grep 3306

At this point port 3306 is open and you can authorize access to mysql using sudo
Command: sudo mysql -u root -p

Enter the local password the first time and the mysql password the second time

Authorize the root user to all connections: grant all privileges on *.* to 'root'@'%' identified by 'xxxxxx';

The last one is the mysql password

Let the permissions take effect immediately: flush privileges;

Now all operations are completed and you can connect to this MySQL database server from any host.

Solution to MySQL remote connection failure: https://www.jb51.net/article/103770.htm

Centos7.1 firewall open port: https://www.jb51.net/article/103777.htm

CentOS 7 open ports: https://www.jb51.net/article/103773.htm

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.