IDEA远程连接mysql操作数据库java.sql.SQLException: Access denied for user ‘root‘@‘111.79.225.30‘ (using passwo

最新推荐文章于 2023-07-09 09:26:08 发布

qq_44982182

最新推荐文章于 2023-07-09 09:26:08 发布

阅读量396

点赞数

文章标签： mysql

本文链接：https://blog.csdn.net/qq_44982182/article/details/109643670

版权

IDEA远程连接mysql操作数据库

java.sql.SQLException: Access denied for user 'root'@'111.79.225.30' (using passwo

通过一下连接出现以上问题

 Class.forName("com.mysql.cj.jdbc.Driver");
        String dburl = "jdbc:mysql://121.37.xx2.1xx/DB?&useSSL=false&serverTimezone=UTC";
        Connection conn = DriverManager.getConnection(dburl,"连接用户","密码");

问题分析：
1.首先我们确定IDEA引入了mysql-connector的jdbc依赖

网址找到要加入的依赖写入pom.xml]
https://mvnrepository.com/artifact/mysql/mysql-connector-java

`加入依赖
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.15</version>
</dependency>

2.确认密码和连接代码正确之后
出现以上问题是因为数据库没有赋予连接用户的远程连接权限
解决如下：
mysql -uroot -p登录mysql赋予权限就好
grant all privileges on DB.* to 'root'@'%' identified by '密码';
grant all privileges on DB.* to 'root'@'localhost' identified by '密码';
grant all privileges on DB.* to 'root'@'121.xx.1xx.1xx' identified by '密码';
flush privileges;  刷新权限