mysql设置远程登录后连接不上
mysql设置远程登录后连接不上
参考:http://www.jb51.net/article/33813.htm
http://www.jb51.net/article/58096.htm
默认情况下,MySQL只允许本地登录,如果要开启远程连接,则需要修改/etc/my.cnf文件
sudo vim /etc/mysql/my.cnf
注释这一行:bind-address=127.0.0.1
保存退出。
mysql -u root -p
为需要远程登录的用户赋予权限:
代码如下:
mysql>use mysql;
mysql>delete from user where user='';(删除匿名用户)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY "123" with grant option;(123为密码)
mysql> flush privileges;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY "123" with grant option;(123为密码)
mysql> flush privileges;
退出mysql(exit)
然后重启mysql服务(sudo service mysql restart)
远程登录命令:
mysql -h 125.216.231.188 -u root -p(-h后跟的是要登录主机的ip地址)