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

你的名字 2024-03-31 08:22 13阅读 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

相关 Host 'XXX' is not allowed to connect to this MySQL server 解决方案

相关 MyBatis3 连接MySQL8 提示：message from server: “Host ‘xxx‘ is not allowed to connect to this MySQL server

相关 null, message from server: “Host ‘xxx‘ 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"解决办法