message from server: "Host 'DESKTOP-U79FCE6' is not allowed to connect to this MySQL server"

最新推荐文章于 2024-07-30 16:09:07 发布
最新推荐文章于 2024-07-30 16:09:07 发布
阅读量3k 收藏
点赞数 1
CC 4.0 BY-SA版权
分类专栏： Mysql 文章标签： mysql连接不上
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/hqbootstrap1/article/details/82987684

连完公司的数据库,想偷懒直接改成自己本机网关后的一位，

报这个错误是因为我连接数据库用的是自己本机的ip 192.168.xx.xx，

打开mysql控制台发现 没有这个用户

所以改成 127.0.0.1 或者localhost就好了

【MSSQL】如何清理SQL SERVER内存解决内存占用高的问题
德仔
07-10 298
摘要：本文介绍了三种释放SQL Server占用内存的方法：1)重启SQL Server服务；2)动态调整最大内存设置，先减小再恢复；3)通过定时任务自动释放内存。重点分析了SQL Server内存占用高的原因（缓存机制），并提供了详细的存储过程脚本和作业配置，通过DBCC命令清除缓存并重置内存限制来实现内存释放。建议在生产环境采用第三种方案，设置每周定时任务自动执行释放操作，避免手动干预
linux ubuntu18.04 update-initramfs -u提示The initramfs will attempt to resume from /dev/nvme0n1p3
Hello Word!
12-31 4201
update-initramfs: deferring update (trigger activated) Processing triggers for initramfs-tools (0.130ubuntu3.11) ... update-initramfs: Generating /boot/initrd.img-5.4.0-48-generic I: The initramfs will attempt to resume from /dev/nvme0n1p3 I: (UUID=297bb92
Host 'DESKTOP-BNFMG64' is not allowed to connect to this MySQL server解决方案
江南烟雨却痴缠丶
10-20 4126
使用Navicat连接MySQL数据库，如果在本机上通过ip地址输入localhost是可以连接上的。但是我们想要通过以太网IPv4地址远程连接的方式，就会提示Host 'DESKTOP-BNFMG64' is not allowed to connect to this MySQL server即MySQL不允许远程登录，所以远程登录失败了。 解决办法： 方案一，直接修改root权限：...
mysql 提示Host ‘DESKTOP-FJ1G3EV‘ is not allowed to connect to this MysQL server 5.7
hfhjdggy的博客
07-20 650
点击mysql client show databases 显示所有数据库 切换到mysql; use mysql 修改配置 update user set host = ‘%’ where user =‘root’； host修改完成后执行以下命令使配置立即生效。 flush privileges; 然后在查看配置 select host from user where user=‘root’; 看到多了一行%就行了 ...
message from server: "Host 'DESKTOP-QIR7OV5' is not allowed to connect to this MySQL server"问题
喃宫的博客
12-13 4059
情景：最近自己设计一些表，想利用自动生成工具来快速生成文件。由于数据库是本地的，生成工具的项目也是本地的，按照配置好数据源之后 启动项目，结果报错了，无法访问到数据库。 解决办法是： 我这里用的是Navicat Premium12版本，打开并且连接上； 看到里面有个mysql数据库，库里有张user表； 修改user表中的字段“Host”为“%”； 刷新数据库的权限，或者使用命令语句“flus...
message from server: “Host ‘DESKTOP-FAJUM7V‘ is not allowed to connect to this MySQL server“
huixiyang的博客
10-12 1116
后台报错提示 message from server: "Host 'DESKTOP-FAJUM7V' is not allowed to connect to this MySQL server"
解决java.sql.SQLException: null, message from server: “Host ‘XXX‘ is not allowed to connect异常
weixin_45131680的博客
09-08 559
我是迁移项目后，项目访问数据库时报的这个异常。这个异常是数据库只允许localhost或127.0.0.1访问，不允许远程访问。我用的本机IP都不行。flush privileges是为了将权限更新操作刷新到内存中，而不用下次启动时生效。解决办法：修改访问权限即可。打开cmd，进入mysql。
我把日志级别改成了debug，首先权限，命令都是无问题，权限给的最高，命令我手动ssh登录控制台都可正常显示，也不会报错，但是这个程序命令执行在交换机后台日志看只正确了执行quit这条命令，其余都未执行，程序日志如下：2025-07-15 14:21:27,593 - DEBUG - read_channel: 2025-07-15 14:21:29,594 - DEBUG - read_channel: 2025-07-15 14:21:29,594 - DEBUG - write_channel: b&#39;quit\n&#39; 2025-07-15 14:21:29,594 - DEBUG - EOF in transport thread 2025-07-15 14:21:29,595 - INFO - 172.17.201.28 不是已知汇聚交换机，作为最终设备 2025-07-15 14:21:29,608 - DEBUG - starting thread (client mode): 0x7a64f2f0 2025-07-15 14:21:29,608 - DEBUG - Local version/idstring: SSH-2.0-paramiko_3.5.1 2025-07-15 14:21:29,609 - DEBUG - Remote version/idstring: SSH-1.99-Comware-5.20 2025-07-15 14:21:29,609 - INFO - Connected (version 1.99, client Comware-5.20) 2025-07-15 14:21:29,631 - DEBUG - === Key exchange possibilities === 2025-07-15 14:21:29,631 - DEBUG - kex algos: diffie-hellman-group-exchange-sha1, diffie-hellman-group14-sha1, diffie-hellman-group1-sha1 2025-07-15 14:21:29,631 - DEBUG - server key: ssh-rsa 2025-07-15 14:21:29,631 - DEBUG - client encrypt: aes128-cbc, 3des-cbc, des-cbc 2025-07-15 14:21:29,631 - DEBUG - server encrypt: aes128-cbc, 3des-cbc, des-cbc 2025-07-15 14:21:29,631 - DEBUG - client mac: hmac-sha1, hmac-sha1-96, hmac-md5, hmac-md5-96 2025-07-15 14:21:29,631 - DEBUG - server mac: hmac-sha1, hmac-sha1-96, hmac-md5, hmac-md5-96 2025-07-15 14:21:29,631 - DEBUG - client compress: none 2025-07-15 14:21:29,631 - DEBUG - server compress: none 2025-07-15 14:21:29,631 - DEBUG - client lang: <none> 2025-07-15 14:21:29,631 - DEBUG - server lang: <none> 2025-07-15 14:21:29,631 - DEBUG - kex follows: False 2025-07-15 14:21:29,631 - DEBUG - === Key exchange agreements === 2025-07-15 14:21:29,631 - DEBUG - Kex: diffie-hellman-group-exchange-sha1 2025-07-15 14:21:29,631 - DEBUG - HostKey: ssh-rsa 2025-07-15 14:21:29,631 - DEBUG - Cipher: aes128-cbc 2025-07-15 14:21:29,631 - DEBUG - MAC: hmac-sha1 2025-07-15 14:21:29,632 - DEBUG - Compression: none 2025-07-15 14:21:29,632 - DEBUG - === End of kex handshake === 2025-07-15 14:21:29,655 - DEBUG - Got server p (2048 bits) 2025-07-15 14:21:30,462 - DEBUG - kex engine KexGex specified hash_algo <built-in function openssl_sha1> 2025-07-15 14:21:30,462 - DEBUG - Switch to new keys ... 2025-07-15 14:21:30,463 - DEBUG - Adding ssh-rsa host key for 172.17.201.28: b&#39;5e3ca5910d7cce29466ca9634fce6a23&#39; 2025-07-15 14:21:30,486 - DEBUG - userauth is OK 2025-07-15 14:21:30,506 - INFO - Authentication (password) successful! 2025-07-15 14:21:30,507 - DEBUG - [chan 0] Max packet in: 32768 bytes 2025-07-15 14:21:30,528 - DEBUG - [chan 0] Max packet out: 32496 bytes 2025-07-15 14:21:30,528 - DEBUG - Secsh channel 0 opened. 2025-07-15 14:21:30,532 - DEBUG - [chan 0] Sesch channel 0 request ok 2025-07-15 14:21:30,536 - DEBUG - [chan 0] Sesch channel 0 request ok 2025-07-15 14:21:30,536 - DEBUG - write_channel: b&#39;\n&#39; 2025-07-15 14:21:30,638 - DEBUG - read_channel: ****************************************************************************** * Copyright (c) 2004-2013 Hangzhou H3C Tech. Co., Ltd. All rights reserved. * * Without the owner&#39;s prior written consent, * * no decompiling or reverse-engineering shall be allowed. * ****************************************************************************** <CDSL_SW201.28_LBG> 2025-07-15 14:21:30,638 - DEBUG - Pattern found: (to continue|[>\]]) ****************************************************************************** * Copyright (c) 2004-2013 Hangzhou H3C Tech. Co., Ltd. All rights reserved. * * Without the owner&#39;s prior written consent, * * no decompiling or reverse-engineering shall be allowed. * ****************************************************************************** <CDSL_SW201.28_LBG> 2025-07-15 14:21:30,939 - DEBUG - read_channel: <CDSL_SW201.28_LBG> 2025-07-15 14:21:30,939 - DEBUG - Clear buffer detects data in the channel 2025-07-15 14:21:31,540 - DEBUG - read_channel: 2025-07-15 14:21:31,540 - DEBUG - write_channel: b&#39;\n&#39; 2025-07-15 14:21:31,540 - DEBUG - read_channel: 2025-07-15 14:21:31,551 - DEBUG - read_channel: <CDSL_SW201.28_LBG> 2025-07-15 14:21:31,551 - DEBUG - Parenthesis found in pattern. pattern: (>|\]) This can be problemtic when used in read_until_pattern(). You should ensure that you use either non-capture groups i.e. &#39;(?:&#39; or that the parenthesis completely wrap the pattern &#39;(pattern)&#39; 2025-07-15 14:21:31,551 - DEBUG - Pattern found: (>|\]) <CDSL_SW201.28_LBG> 2025-07-15 14:21:31,852 - DEBUG - read_channel: 2025-07-15 14:21:31,852 - DEBUG - [find_prompt()]: prompt is <CDSL_SW201.28_LBG> 2025-07-15 14:21:31,852 - DEBUG - In disable_paging 2025-07-15 14:21:31,852 - DEBUG - Command: screen-length disable 2025-07-15 14:21:31,852 - DEBUG - write_channel: b&#39;screen-length disable\n&#39; 2025-07-15 14:21:31,852 - DEBUG - read_channel: 2025-07-15 14:21:31,863 - DEBUG - read_channel: s 2025-07-15 14:21:31,874 - DEBUG - read_channel: 2025-07-15 14:21:31,885 - DEBUG - read_channel: creen-length disable 2025-07-15 14:21:31,896 - DEBUG - read_channel: 2025-07-15 14:21:31,907 - DEBUG - read_channel: ^ % Unrecognized command found at &#39;^&#39; position. <CDSL_SW201.28_LBG> 2025-07-15 14:21:31,907 - DEBUG - Pattern found: (CDSL_SW201\.28_LBG) screen-length disable ^ % Unrecognized command found at &#39;^&#39; position. <CDSL_SW201.28_LBG 2025-07-15 14:21:31,907 - DEBUG - screen-length disable ^ % Unrecognized command found at &#39;^&#39; position. <CDSL_SW201.28_LBG 2025-07-15 14:21:31,907 - DEBUG - Exiting disable_paging 2025-07-15 14:21:31,907 - INFO - 成功连接 172.17.201.28 2025-07-15 14:21:31,907 - DEBUG - write_channel: b&#39;screen-length disable\n&#39; 2025-07-15 14:21:32,008 - DEBUG - read_channel: screen-length disable ^ % Unrecognized command found at &#39;^&#39; position. <CDSL_SW201.28_LBG> 2025-07-15 14:21:32,108 - DEBUG - read_channel: 2025-07-15 14:21:34,109 - DEBUG - read_channel: 2025-07-15 14:21:34,610 - DEBUG - write_channel: b&#39;system-view\n&#39; 2025-07-15 14:21:34,711 - DEBUG - read_channel: system-view ^ % Unrecognized command found at &#39;^&#39; position. <CDSL_SW201.28_LBG> 2025-07-15 14:21:34,812 - DEBUG - read_channel: 2025-07-15 14:21:36,813 - DEBUG - read_channel: 2025-07-15 14:21:37,814 - INFO - 172.17.201.28 是 H3C V5 交换机，使用特殊绑定流程 2025-07-15 14:21:37,814 - DEBUG - write_channel: b&#39;display mac-address 6c0b-5e47-7f89\n&#39; 2025-07-15 14:21:37,915 - DEBUG - read_channel: display mac-address 6c0b-5e47-7f89 ^ % Unrecognized command found at &#39;^&#39; position. <CDSL_SW201.28_LBG> 2025-07-15 14:21:38,016 - DEBUG - read_channel: 2025-07-15 14:21:40,018 - DEBUG - read_channel: 2025-07-15 14:21:40,018 - INFO - MAC地址查询结果: ^ % Unrecognized command found at &#39;^&#39; position. 2025-07-15 14:21:40,018 - ERROR - 在 172.17.201.28 上未找到 MAC 6c0b-5e47-7f89 对应的端口 2025-07-15 14:21:40,019 - DEBUG - write_channel: b&#39;\n&#39; 2025-07-15 14:21:40,120 - DEBUG - read_channel: <CDSL_SW201.28_LBG> 2025-07-15 14:21:40,221 - DEBUG - read_channel: 2025-07-15 14:21:42,222 - DEBUG - read_channel: 2025-07-15 14:21:42,222 - DEBUG - write_channel: b&#39;quit\n&#39; 2025-07-15 14:21:42,222 - DEBUG - EOF in transport thread
最新发布
07-16
程序在登录后，首先尝试发送了两次`screen-length disable`命令（第一次在connect_with_retry中，第二次在configure_device中），均失败。 然后尝试进入系统视图`system-view`也失败。 可能的原因： 1. 设备...
GitLab基础：新版本下使用gitlab-rake进行备份和恢复
知行合一 止于至善
08-13 1万+
从GitLab12.1开始，可以直接使用rake进行备份，如果之前的项目中使用的gitlab-rake进行备份和恢复的方式是否可用这个观点进行了如下实验，通过本文进行简单记录。
(BS ISO 11898-1:2015）CAN_FD 总线协议详解7-监督器 FCE 的描述
zhangziranzm的博客
07-30 470
故障隔离的目标是在存在故障节点的情况下保持数据传输网络的高度可用性。
第二次踩坑访问mysql数据库权限问题：null, message from server: “Host ‘*******‘ is not allowed to connect to
yuanhou110的博客
09-20 274
退出mysql，然后再关闭MySQL，再启动mysql，才能避免“Public Key Retrieval is not allowed”问题。之前遇到到数据库连接权限问题，当时解决完就没记录，现在换电脑了，又出现问题了，直接上方案。
mysql连接报错: "xxx" is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
hecr_mingong的博客
04-08 626
1.问题描述 message from server: "Host ‘XXXX’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’ 2.错误原因 同一个ip在短时间内产生太多（超过mysql数据库max_connection_errors的最大值）中断的数据库连接而导致的阻塞 3...
Mysql报错is not allowed to connect解决办法
热门推荐
不甘于平凡的溃败的博客
07-23 4万+
今天使用本地连接远程Mysql，一直报java.sql.SQLException:null,message from server:"Host '' is not allowed to connect. 这个错误 原因是：远程服务器不允许你的java程序访问它的数据库。所以，我们要对远程服务器进行设置，使它允许你进行连接。 步骤：一、打开mysql控制台，输入：use mysql; ...
jdbc连接mysql时报message from server: "Host '**' is not allowed to connect to this MySQL server"错误解决
xuxiaoyuer_1_1的专栏
01-13 1318
使用JDBC连接mysql时报message from server: "Host 'WHJZ-PC' is not allowed to connect to this MySQL server"错误，如图所示： 出现这种情况的原因是这个数据库的用户不允许从远程登录，只能使用localhost访问。解决办法是在安装mysql的服务器上更改“mysql”数据库里的“user”表中的“HO
java.sql.SQLException: null, message from server: “Host ‘xxx’ is not allowed to connect异常解决
java_gchsh的博客
06-08 8194
mysql connect
message from server: "Host is not allowed to connect to this MySQL server"解决办法
hi_kevin的专栏
01-06 3万+
报错:1130-host ... is not allowed to connect to this MySql server 解决方法： 1. 改表法。 可能是你的帐号不允许从远程登陆，只能在localhost。这个时候只要在localhost的那台电脑，登入mysql后，更改 "mysql" 数据库里的 "user" 表里的 "host" 项，从"localhost"改称"%
Host is not allowed to connect to this MySQL server解决方法
淘气の小狼人的博客
02-08 2239
Host is not allowed to connect to this MySQL server解决方法
message from server: ＂Host 'xxx' is not allowed to connect to th
bagu3895的博客
07-25 5793
解决方法： 1. 改表法。 可能是你的帐号不允许从远程登陆，只能在localhost。这个时候只要在localhost的那台电脑，登入mysql后，更改 "mysql"数据库里的 "user" 表里的 "host" 项，从"localhost"改称"%" mysql-u root -pvmwaremysql>use mysql; www.2...
null, message from server: "Host 'DESKTOP-GT3N5PV' is not allowed to connect to this MySQL server"
Xiao_Bai_Ke的博客
10-26 2533
使用Hibernate连接Mysql数据库时遇到下面的错误： Exception in thread "main" org.hibernate.exception.GenericJDBCException: Cannot open connection     at org.hibernate.exception.SQLStateConverter.handledNonSpecificExcep...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值