Host '***' is not allowed to connect to this MySQL server

最新推荐文章于 2024-05-07 14:14:37 发布

夜半无声

最新推荐文章于 2024-05-07 14:14:37 发布

阅读量546

点赞数

分类专栏：基础类文章标签： mysql server

本文链接：https://blog.csdn.net/u013772876/article/details/78784158

版权

基础类专栏收录该内容

9 篇文章 0 订阅

订阅专栏

Host '' is not allowed to connect to this MySQL server

今天运行项目报错“Host '***' is not allowed to connect to this MySQL server”；将mysql的数据库链接改成了一个远程服务器上的；

Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: null,  message from server: "Host 'Static' is not allowed to connect to this MySQL server"
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
	at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:280)
	... 51 more
Caused by: java.sql.SQLException: null,  message from server: "Host 'Static' is not allowed to connect to this MySQL server"
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:997)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
	at java.sql.DriverManager.getConnection(DriverManager.java:582)
	at java.sql.DriverManager.getConnection(DriverManager.java:154)
	at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConnectionBuilder.java:39)
	at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)
	at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:211)
	at org.logicalcobwebs.proxool.ProxoolDataSourceEx.getConnection(ProxoolDataSourceEx.java:89)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
	... 52 more

修改这个错误如下：

1：在这台远程服务器上用“Navicat Premium”工具登录上数据库；

2：点击“用户”-修改主机这一项； 将“locahost”改成“%”