mysql允许远程连接 - jackssybin 的个人博客

mysql允许远程连接

2019-11-13/2019-11-13

专题MySQL 与数据架构

导读本文归入「MySQL 与数据架构」专题，主要记录：1.本地登陆赋权 GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;  FLUSH PRIVILEGES; 2. 修改本地绑定端口 /etc/mysql/mysql.cnf 查找bind 127.0.0....

1.本地登陆赋权

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
 FLUSH PRIVILEGES;

2. 修改本地绑定端口

/etc/mysql/**mysql.cnf
查找bind 127.0.0.1 注释掉即可