文档章节

mysql5.7 配置远程访问(unbuntu 16.04)

G
 GygesM
发布于 2017/05/05 15:44
字数 73
阅读 3
收藏 0
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "123456";
mysql> flush privileges;

1、赋予账户远程访问权限

2、通过修改

sudo vim /etc/mysql/mysql.conf.d 

注释 # # Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address           = 127.0.0.1
ok,设置完成。

© 著作权归作者所有

G

GygesM

粉丝 0
博文 17
码字总数 1027
作品 0
私信 提问