MySQL数据库——远程登录

vim etc/mysql/mysql.conf.d/mysqld.cnf
#把bind-address = 127.0.0.1 注释掉

mysql -uroot -p

use mysql;

select * from user \G;

update user set host = '%' where user = 'root';
#或者使用
grant all privileges on *.* to '用户名'@'%' identified by '登录密码' with grant option；
flush privileges;

sudo service mysqld restart