数据库连接错误

问题描述：

连接数据库时出现拒绝连接

1130-host "192.168.100.xxx" is not allowed to connect to this mysql server

问题分析

该用户没被授权连接数据库

问题解决

授权用户使用密码cloud从任何主机连接到mysql服务器的话。

# mysql -u root -pEnter password:MariaDB [(none)]>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED \BY 'cloud' WITH GRANT OPTION;

授权用户从ip为localhost的主机连接到mysql服务器，并使用密码cloud

MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'locahost' \IDENTIFIED BY 'cloud' WITH GRANT OPTION;MariaDB [(none)]> exit;

重启数据库

service mysql restart