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
Annotate
bind-address
This line
Restart MySQL service
service mysql restart