报错: 1130 Host xxx is not allowed to connect to this MySQLserver

问题描述

在云服务器上安装了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';