问题描述
在云服务器上安装了MySQL数据库,想用本机连接.
连接不上
报错 1130 Host xxx is not allowed to connect to this MySQLserver
解决方法
授权法
任何主机都能连接到mysql服务器
root为用户名,%表示任意主机ip
FLUSH告诉服务器重新加载授权表
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
指定ip从任何主机连接到mysql服务器
GRANT ALL PRIVILEGES ON *.* TO 'root'@'101.26.139.185' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
注:若后悔了想收回授权
语法:
REVOKE privilege ON databasename.tablename FROM 'username'@'host';
示例:
REVOKE privilege ON '*' FROM 'username'@'host';