Host is not allowed to connect to this MySQL server 解决方法
来源:互联网 发布:上海预算软件 编辑:程序博客网 时间:2024/06/06 05:41
数据库拒绝远程访问解决方法
1 dos登录mysql所在bin文件夹执行 : mysql -uroot -p; 并输入密码
2 创建远程登陆用户并授权 :grant all PRIVILEGES on *.* to root@'192.168.2.21' identified by '123456 ';
3 执行立即生效:flush privileges;
简单并详细的说下授权指令
红1:*.* 表示上面的权限是针对于哪个数据库的哪个表的,第一个*可以指定数据库,第二 * 可以指定数据表:对于全部数据库的全部表授权为“*.*”,
对于某一数据库的全部表授权为“数据库名.*”,对于某一数据库的某一表授权为“数据库名.表名”。
红2:root 表示你要给哪个用户授权,这个用户可以是存在的用户,也可以是不存在的用户。
192.168.2.21 表示允许远程连接的 IP 地址,如果想不限制链接的 IP 则设置为“%”即可。
红3:123456 为用户的密码。
0 0
- host is not allowed to connect to this MySQL server
- Host is not allowed to connect to this MySQL server
- host ... is not allowed to connect to this MySql server
- Host * is not allowed to connect to this MySQL server
- host is not allowed to connect to this MySql server
- Host is not allowed to connect to this MySQL server
- host ... is not allowed to connect to this MySql server
- Host '***' is not allowed to connect to this MySQL server"
- host ... is not allowed to connect to this MySql server
- Host is not allowed to connect to this mysql server,
- Host '***' is not allowed to connect to this MySQL server
- mysql host is not allowed to connect to this mysql server 解决方法
- mysql 远程访问不行解决方法 Host is not allowed to connect to this MySQL server
- Host 'XXX' is not allowed to connect to this MySQL server 解决方法/开启MySQL远程账号
- mysql 远程访问不行解决方法,Host '' is not allowed to connect to this MySQL server
- mysql远程连接报错: Host * is not allowed to connect to this MySQL server,解决方法
- mysql 远程访问不行解决方法 Host is not allowed to connect to this MySQL server
- mysql 远程访问不行解决方法 Host is not allowed to connect to this MySQL server
- 静默安装、正常安装与打开等PackageManager运用
- CentOS+nginx+uwsgi+Python 多站点环境搭建
- Mysql
- ios 跳转safari
- RxJava2+Retrofit+RxBinding
- Host is not allowed to connect to this MySQL server 解决方法
- apache tomcat 集群整合测试 3
- Opencv学习笔记2--像素的访问
- 爬坑之iis6服务器伪静态组件安装及其使用
- ajaxform实现文件和表单信息一起提交
- 动态规划学习之路(1)
- c语言之链表的实现
- ACM-放苹果
- ADO读写DateTime方式