Enable MySQL remote access permission to allow remote connection

Environmental Science

• Ubuntu 18.04
• MySQL5.7

Log in MySQL database

mysql -uroot -p

Add remote connection permission

use mysql;
grant all privileges  on *.* to [email protected]'%' identified by "password";
flush privileges;

Modify MySQL configuration file

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

Annotatebind-addressThis line

Restart MySQL service

service mysql restart