Bug：解决java.sql.SQLException: null, message from server: “Host ‘XXX‘ is not allowed to connect异常

你的名字 2024-03-31 08:22 50阅读 0赞

## SQLException: null, message from server: "Host ‘XXX’ is not allowed to connect异常 ##

### 1 Bug重现 ###

今天部署项目到linux的时候，因为需要连接我本地的mysql，所以将本地mysql的连接地址，改成了我本机的ip。但是启动项目的时候报错：

null,  message from server: "Host 'windows10.microdone.cn' 
    is not allowed to connect to this MySQL server"

### 2 Bug分析 ###

![在这里插入图片描述][40fef136ffa64ef9b774d82dd74a69bc.png]  
因为在MySQL本地的用户表中，只允许localhost（127.0.0.1）访问，所以出现了上述问题。

> 此时我们只需要修改host权限就可以了

### 3 Bug解决 ###

1.  打开cmd窗口，登录msyql

mysql -uroot -p

输入自己的本机msyql密码后登录到mysql

1.  使用mysql数据库

use mysql;

1.  查看表中权限

select user, host from user;

1.  更新表中权限

update user set host = '%' where user='root';

1.  刷新权限

flush privileges;

1.  查看是否生效

select user, host from user;

![在这里插入图片描述][4ea830d6b44d4689b59aa59d2fd078db.png]

此时，再重新启动项目就发现可以了。

参考文章：https://blog.csdn.net/m0\_37460012/article/details/90290148

### 4 拓展:启动boot项目没有主清单属性、权限不够 ###

![在这里插入图片描述][b724aa2003b74e95836f7251b0ebbfd6.png]

> 需要再boot项目中的pom文件中，添加构建插件

<build>
         <plugins>
             <plugin>
                 <groupId>org.springframework.boot</groupId>
                 <artifactId>spring-boot-maven-plugin</artifactId>
             </plugin>
         </plugins>
     </build>

此时，重新启动网关服务，发现权限不够，无法启动netty  
![在这里插入图片描述][e343c31340ca4c8bae2ccb703588f78c.png]

> 只需要将linux账户切换成root用户即可

[40fef136ffa64ef9b774d82dd74a69bc.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/fd58c55db013484c823403a971c0bee6.png
[4ea830d6b44d4689b59aa59d2fd078db.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/48c111f1671b46eb9eaea57feeb5280c.png
[b724aa2003b74e95836f7251b0ebbfd6.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/2c8367195e614eccbe5c2c322a812230.png
[e343c31340ca4c8bae2ccb703588f78c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/8b1af3388d3c48ffa588976a9e8ccc92.png

Bug：解决java.sql.SQLException: null, message from server: “Host ‘XXX‘ is not allowed to connect异常

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 java.sql.SQLException: null, message from server: “Host ‘192.168.43.1‘ is not allowed to connect to

相关 Bug：解决java.sql.SQLException: null, message from server: “Host ‘XXX‘ is not allowed to connect异常

相关【MySQL异常】解决java.sql.SQLException: null, message from server: “Host xxx‘ is not allowed to connect to

相关 Host 'xxx' is not allowed to connect to this MariaDB server

相关 null, message from server: “Host ‘xxx‘ is not allowed to connect to this MySQL server“

相关 Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server

相关连接失败！null, message from server: “Host ‘xxxx‘ is not allowed to connect to this MySQL server“

相关 Java null, message from server: “Host ‘xxx‘ is not allowed to connect to this MySQL server“文件解决

相关 message from server: "Host is not allowed to connect to this MySQL server"解决办法

相关 message from server: "Host is not allowed to connect to this MySQL server"解决办法