[配置]连接mariaDB报错:is not allowed to connect to this MariaDB server
is not allowed to connect to this MariaDB server
·
1.报错信息:Host ‘192.168.0.10’ is not allowed to connect to this MariaDB server
2.报错原因:因为没有远程连接数据库的权限
3.解决方案:在数据库执行如下语句即可:
# mysql -u root -p
# use mysql;
# update user set host = '%' where user ='root';
# flush privileges;
# quit;
更多推荐
所有评论(0)