1130 host is not allowed to connect to
to not is connect Host Allowed
2023-09-11 14:14:05 时间
mysql 远程访问不行解决方法 Host is not allowed to connect to this MySQL server
如果你想连接你的mysql的时候发生这个错误:
ERROR 1130: Host ‘192.168.1.3’ is not allowed to connect to this MySQL server
解决方法:
1。 改表法。可能是你的帐号不允许从远程登陆,只能在localhost。这个时候只要在localhost的那台电脑,登入mysql后,更改 “mysql” 数据库里的 “user” 表里的 “host” 项,从”localhost”改称”%”
1、mysql -u root -pvmware
2、mysql>use mysql;
3、mysql>update user set host = ‘%’ where user = ‘root';
4、mysql>select host, user from user;
2. 授权法。(推荐使用此法)
例如,你想myuser使用mypassword从任何主机连接到mysql服务器的话。(在服务器上授权)
GRANT ALL PRIVILEGES ON *.* TO ‘myuser’@’%’ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;
FLUSH PRIVILEGES;
如果你想允许用户myuser从ip为192.168.1.3的主机连接到mysql服务器,并使用mypassword作为密码,如下:
GRANT ALL PRIVILEGES ON *.* TO ‘root’@’192.168.1.3′ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;
FLUSH PRIVILEGES;
或者
GRANT ALL PRIVILEGES ON *.* TO ‘root’@’10.10.40.54′ IDENTIFIED BY ‘123456’ WITH GRANT OPTION; FLUSH PRIVILEGES;
相关文章
- 记录一次在生成数据库服务器上出现The timeout period elapsed prior to completion of the operation or the server is not responding.和Exception has been thrown by the target of an invocation的解决办法
- mybatis报错Type interface xxx.Dao is not known to the MapperRegistry
- bug--Unable to add window –token is not valid; is your activity running?
- [Kotlin] When to add () and when not to
- ERROR 1130 Host is not allowed to connect to this MySQL server 问题解决
- bug--Unable to add window –token is not valid; is your activity running?
- [服务器时区问题]PHP Warning: strftime(): It is not safe to rely on the system's timezone set
- 【17】报错Failed to allocate graph: MYRIAD device is not opened.
- cannot bind to cxOutlet since it is not a known property of ng template
- How to resolve error message Distribution channel is not allowed for sales
- when is IBASE status changed from inital to created - not answered
- 报错: Access restriction: The type JPEGImageEncoder is not accessible due to restriction on required library
- java.io.IOException: Cleartext HTTP traffic to 192.168.xx.xxx not permitted
- 成功解决YOLOv3测试——could not create cudnn handle: CUDNN_STATUS_NOT_INITIALIZE作记录
- 成功解决ERROR: Could not build wheels for bottleneck, which is required to install pyproject.toml-based
- 成功解决Not possible to connect to the Web3 provider. Make sure the provider is running and a connection
- 成功解决TypeError: Value passed to parameter 'paddings' has DataType float32 not in list of allowed valu
- 成功解决WARNING: You do not appear to have an NVIDIA GPU supported by the 430.34 NVIDIA Linux graph
- 【异常】Maven构建出错,Could not transfer artifact xxx from/to central (https://repo.maven.apache.org/maven2)
- 已解决ERROR: Could not build wheels for opencv-python-headless, which is required to install
- 已解决Resource stopwords not found. Please use the NLTK Downloader to obtain the resource:
- Mysql连接报错:1130-host ... is not allowed to connect to this MySql server如何处理
- Android12之error:is not visible to this module(一百五十一)
- redis.clients.jedis.exceptions.JedisException: Can connect to sentinel, but seems to be not monitored.
- ES failed to notify ClusterStateListener java.lang.IllegalStateException: environment is not locked
- Redis "MISCONF Redis is configured to save RDB snapshots, but is currently not able to persist on disk"问题的解决
- QQ邮箱`Could not connect to SMTP host: smtp.qq.com, port: 25`
- 为什么连接HBase报错:Will not attempt to authenticate using SASL (unknown error)?
- 【Python问题解决】---- ERROR: Could not install packages due to an OSError: [WinError 2] 系统找不到指定的文件。
- K8S 证书过期,报错:Unable to connect to the server: x509: certificate has expired or is not yet valid 解决方法