Mysql:is not allowed to connect to this MySQL server
2023-09-14 08:57:15 时间
p 如果你想连接你的mysql的时候发生这个错误: br br /p
pre >如果你想连接你的mysql的时候发生这个错误:
一、在上一篇文章中,使用ECS和mysql搭建mysql服务器搭建好了mysql服务器,现在需要远程连接 2003 - Can t connect to MySQL server on 39.
ERROR 1130: Host 192.168.1.3 is not allowed to connect to this MySQL server
解决方法:
1。 改表法。可能是你的帐号不允许从远程登陆,只能在localhost。这个时候只要在localhost的那台电脑,登入mysql后,更改 "mysql" 数据库里的 "user" 表里的 "host" 项,从"localhost"改称"%"
mysql -u root -pvmwaremysql use mysql;mysql update user set host = % where user = root;mysql select host, user from user;
2. 授权法。例如,你想myuser使用mypassword从任何主机连接到mysql服务器的话。
GRANT ALL PRIVILEGES ON *.* TO myuser@% IDENTIFIED BY mypassword WITH GRANT OPTION;
如果你想允许用户myuser从ip为192.168.1.3的主机连接到mysql服务器,并使用mypassword作为密码
GRANT ALL PRIVILEGES ON *.* TO root@192.168.1.3 IDENTIFIED BY mypassword WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO root@10.10.40.54 IDENTIFIED BY 123456 WITH GRANT OPTION;
一、在上一篇文章中,使用ECS和mysql搭建mysql服务器搭建好了mysql服务器,现在需要远程连接 2003 - Can t connect to MySQL server on 39.
相关文章
- Error connecting to database [Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)]
- 【Mysql 学习】mysql 字符集
- 磁盘爆满导致MySQL无法启动:Disk is full writing './mysql-bin.~rec~' (Errcode: 28). Waiting for someone to free space...
- 【MySql】mysql 表的常规管理
- 【异常】com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
- 【异常】ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
- Nginx配置WebService、MySQL、SQL Server、ORACLE等代理
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (
- SQL Server replication requires the actual server name to make a connection to the server.错误解决
- 大叔经验分享(72)mysql时区
- MySQL内核月报 2014.08-MySQL· 捉虫动态·Count(Distinct) ERROR
- 连接Mysql提示Can’t connect to local MySQL server through socket的解决方法
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
- Starting MySQL ERROR! Couldn‘t find MySQL server (/usr/local/mysql/bin/mysqld_safe)
- C# 连接SQL Server数据库的几种方式--server+data source等方式
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket
- Mycat启动正常但无法连接ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql