连接错误:Host xxx is not allowed to connect to this MariaDb server
有两种解决方法:
1.授权法
GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; // %:表示从任何主机连接到mysql服务器 FLUSH PRIVILEGES;
或者
GRANT ALL PRIVILEGES ON *.* TO 'user'@'192.168.1.5' IDENTIFIED BY 'password' WITH GRANT OPTION;//表示从指定ip从任何主机连接到mysql服务器 FLUSH PRIVILEGES;
错误:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
在[mysqld]下添加skip-grant-tables,保存即可。