Ubuntu Configuration MySQL Remote connection

First install MySQL, mysqlclient

sudo Install mysql-server mysql-client
sudo apt-get install Libmysqlclient-dev

Install mysqlclient

Modifying bind-address in a configuration file

File path:

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

Modify bind-address = 127.0.0.1 to bind-address = 0.0.0.0

Restart and login to MySQL

1 sudo Service MySQL Restart 2 mysql-uroot-p

Modify Permissions:

1  ' Root '@'%'yourpassword' with GRANT OPTION; 2 3 FLUSH privileges;

Restart MySQL

sudo service mysql restart

Note: Sometimes MySQL does not start after restarting the server causing the remote to not connect just start MySQL

sudo service MySQL start

Summary: This is my Ubuntu configuration method, pro-test available, there may be other configuration methods, for reference only, thank you.

Ubuntu Configuration MySQL Remote connection