mysql 远程连接

/etc/mysql/mysql.conf.d,编辑mysqld.cnf,在里面找到
bind-address = 127.0.0.1
将其改为 bind-address = 0.0.0.0，即可实现允许任意IP的访问。

mysql> use mysql

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '796Wang.p' WITH GRANT OPTION;

mysql> flush privileges;

或者
update user set user.Host="%" where user.User="root";

mysql> flush privileges;

客户端远程：
mysql -uroot -p -h10.154.0.43 -P3306