原因:mysql默认不允许远程连接,需进行权限的开放
步骤:
1.登录mysql数据库
mysql -uroot -p
2.切换到mysql数据库
use mysql
3.授予权限
grant all privileges on . to ‘用户名’@‘IP地址’ identified by ‘密码’;(给特定ip授权)
或
grant all privileges on . to root@"%" identified by ‘密码’ with grant option; (任意ip都能远程连接)
4.刷新权限
flush privileges;
5.重启mysql
(sudo) service mysql restrat
成功!