1130 host is not allowed to connect to this MySql Server
来源:互联网 发布:我想找个网络兼职 编辑:程序博客网 时间:2024/09/21 06:37
注意:因为编辑器的原因下面的引号会自动变成中文引号,复制粘贴使用的话需要重新改为英文的引号。
1、从任何主机连接到mysql服务器
用户名:myuser
密码:mypassword
权限:从任何主机连接到mysql服务器。
操作:
GRANT ALL PRIVILEGES ON . TO ‘myuser’@’%’ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;
FLUSH PRIVILEGES;
2、从固定ip地址连接到mysql服务器
用户名:myuser
ip地址:192.168.1.6
密码:mypassword
权限:由192.168.1.6的主机连接到当前数据库
操作:
GRANT ALL PRIVILEGES ON . TO ‘myuser’@’192.168.1.6’ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;
FLUSH PRIVILEGES;
2、从固定ip地址连接到mysql服务器的固定数据库
用户名:myuser
ip地址:192.168.1.6
密码:mypassword
数据库:dk
权限:由192.168.1.6的主机连接到dt数据库
操作:
GRANT ALL PRIVILEGES ON dk.* TO ‘myuser’@’192.168.1.6’ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;
FLUSH PRIVILEGES;
阅读全文
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]MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- Mysql 远程连接错误:1130-host IP is not allowed to connect to this MySql server
- MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- mysql:ERROR 1130: Host '192.168.0.102' is not allowed to connect to this MySQL server
- 【MySql】报错:1130-host ... is not allowed to connect to this MySql server
- MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- 基于YARN集群构建运行PySpark Application
- 线性代数笔记3——向量1(向量简介)
- 4、GitHub上README.md教程(插上图片等)
- Mac OS下,终端下使用pip install *进行到导包后,Eclipse中仍然出现Unresolved错误
- SQLite数据库中的SQL语句
- 1130 host is not allowed to connect to this MySql Server
- 使用crontab启动脚本守护tomcat进程
- git 命令上传、下载到分支
- R还是Python:不同条件下该如何选择?
- 报名 | 数据时代,企业如何依法履行个人信息保护义务?
- xls上传,导入!!!!!利用struts的FormFile,并导入插入数据库
- SpringMvc框架知识简介
- Windows Server 2012 远程连接
- 将服务加入chkconfig开机自启动(通用)