mysql 远程 配置_Mysql 远程登陆配置

1.修改localhost

更改 “mysql” 数据库里的 “user” 表里的 “host” 项，从”localhost”改成”%”  远程只允许root 登陆

mysql>use mysql;

mysql>update user set host = ‘%‘ where user = ‘root‘;

mysql>select host, user from user;

mysql>FLUSH PRIVILEGES;

2、指定授权

使用myuser/mypassword从任何主机连接到mysql服务器:

GRANT ALL PRIVILEGES ON *.* TO ‘myuser‘@‘%‘ IDENTIFIED BY ‘mypassword‘ WITH GRANT OPTION;

使用myuser/mypassword从ip为192.168.31.87的主机连接到mysql服务器:

GRANT ALL PRIVILEGES ON *.* TO ‘myuser‘@‘192.168.31.87‘ IDENTIFIED BY ‘mypassword‘ WITH GRANT OPTION;

3、泛授权

mysql -h localhost -u root

mysql>GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ WITH GRANT OPTION;                     //赋予任何主机上以root身份访问数据的权限

mysql>FLUSH PRIVILEGES;

本文出自 “为梦想奋斗” 博客，谢绝转载！

Mysql 远程登陆配置

标签：mysql 远程登陆配置

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：http://hanzheng.blog.51cto.com/3080616/1751298