Host ''xxx.xx.xxx.xxx'' is not allowed to connect to this MySQL_MySQL_第七城市
Host ''xxx.xx.xxx.xxx'' is not allowed to connect to this MySQL
在远程访问其他的MySQL数据库时,尤其权限问题会导致以下的问题出现:Host ''xxx.xx.xxx.xxx'' is not allowed to connect to this MySQL server,因此我们需要使用root用户登录设置相应的权限(由于我是本机访问虚拟机上的MariaDB数据库, 本机的ip为192.168.137.1, 所以是直接设置roo用户的所有t权限允许本机访问): 1. 打开虚拟机中的命令行窗口,使用root用户登录 [root@localhost /]# mysql -uroot -p Enter password: Welcome to the MariaDB monitor. C or /g. Your MariaDB connection id is 13 Server version: 5.5.47-MariaDB MariaDB Server Copyright (c) , Oracle, MariaDB Corporation Ab and others. Type '' or '/h' for help. Type '/c' to clear the current input statement.
2. 授予所有权限给通过root用户和密码登录的ip为192.168.137.1 MariaDB [(none)]> grant all on *.* to root@'192.168.137.1' identified by ''; Query OK, 0 rows affected (0.00 sec) 3. 更新权限设置 MariaDB [(none)]> Query OK, 0 rows affected (0.00 sec)
Swift开发中你可能遇到的小
最新教程周点击榜
8Swift开发中你可能遇到的小功能实现&持续添加
微信扫一扫}