Docker 中 mysql root远程登录

2019独角兽企业重金招聘Python工程师标准>>>

mysql 版本5.7

1.修改/etc//mysql/mysql.conf.d/mysqld.cnf 下的bind-address，将127.0.0.1或者localhost改成0.0.0.0

bind-address            = 0.0.0.0

0.0.0.0允许其他主机访问

2.mysql默认只允许root本地访问，可以建一个单独用户用来远程访问，如果非要用root，修改mysql.user

表：

mysql> select host,user from mysql.user;//默认样子
+-----------+------------------+
| host      | user             |
+-----------+------------------+
|localhost  | root             |
| localhost | debian-sys-maint |
| localhost | mysql.session    |
| localhost | mysql.sys        |

update mysql.user set host='%' where user='root';

mysql> select host,user from mysql.user;//修改后样子
+-----------+------------------+
| host      | user             |
+-----------+------------------+
|%  | root             |
| localhost | debian-sys-maint |
| localhost | mysql.session    |
| localhost | mysql.sys        |

3.关闭mysql服务，然后重启

service mysql stop

mysqld_safe

远程访问 mysql -h 192.168.X.X -uroot -p，需要mysql-client

转载于:https://my.oschina.net/flzxsqc/blog/1584853