改表法
原因:可能是你的帐号不允许从远程登陆,只能在localhost
方案:更改 "mysql" 数据库里的 "user" 表里的 "host" 项,从"localhost"改称"%"
mysql>use mysql;
mysql>update user set host = '%' where user = 'root';
mysql>select host, user from user;
授权法
- 刷新权限
mysql>FLUSH PRIVILEGES
- 授权
a、允许任何账户登录
GRANT ALL PRIVILEGES ON *.* TO '*'@'%' IDENTIFIED BY '*'
b、允许root账户用任何密码登录
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '*'
c、允许账号:myuser密码:mypassword的用户登录
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%'IDENTIFIED BY 'mypassword' ;
允许ip:192.168.1.6使用账号:myuser密码:mypassword的用户登录
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3'IDENTIFIED BY 'mypassword';
- 刷新权限
mysql>FLUSH PRIVILEGES
- 重启服务
service mysql restart
- 验证