java.sql.SQLException：访问被拒绝，用户'root'@172.17.0.1'（使用密码：YES）(java.sql.SQLException: Access denied for user 'root'@'172.17.0.1' (using password: YES))

 我想从Java写入一个MySQL数据库，但我得到这个错误： 
 
java.sql.SQLException: Access denied for user 'root'@'172.17.0.1' (using password: YES)
 
 我连接到本地的mysql实例，说实话我不知道172.17.0.1 ip是什么。 
 
 我写的小码： 
 
public static void writeToDB(String value, String unit) throws ClassNotFoundException, SQLException, SQLException
{

    // create a mysql database connection
    String myDriver = "com.mysql.cj.jdbc.Driver";
    String myUrl = "jdbc:mysql://localhost:3306/MyDB";
    Class.forName(myDriver);

    Connection conn = null;

    conn = DriverManager.getConnection(myUrl, "root", "MyPass");


    // the mysql insert statement
    String query = " insert into data (unit, value)"
            + " values (?, ?)";

    // create the mysql insert preparedstatement
    PreparedStatement preparedStmt = null;
    preparedStmt = conn.prepareStatement(query);
    preparedStmt.setString (1, unit);
    preparedStmt.setString (2, value);

    // execute the preparedstatement
    preparedStmt.execute();
    conn.close();

}
 
 我跑了 
 
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'MyPass' WITH GRANT OPTION;
 
 但没有任何改变。 
 
 我的my.cnf全部注释掉了。 我的本地IP地址是192.168.1.46。 我试图在myUrl变量上使用这个ip和127.0.0.1来代替localhost，但没有任何改变。 
 
 我重启了mysql服务器，eclipse和pc都没有成功。 
 
 编辑：其他信息我停止了服务器并运行代码。 我得到完全相同的例外。 我猜想我根本无法到达服务器。 
 
 我可以在我的Python脚本中使用“localhost”。 它在与java代码相同的表上写入。 

I am trying to write into a mysql database from Java but I get this error:
 
java.sql.SQLException: Access denied for user 'root'@'172.17.0.1' (using password: YES)
 
I am connecting to a local mysql instance and to be honest I don't know what's 172.17.0.1 ip.
 
The small code I wrote:
 
public static void writeToDB(String value, String unit) throws ClassNotFoundException, SQLException, SQLException
{

    // create a mysql database connection
    String myDriver = "com.mysql.cj.jdbc.Driver";
    String myUrl = "jdbc:mysql://localhost:3306/MyDB";
    Class.forName(myDriver);

    Connection conn = null;

    conn = DriverManager.getConnection(myUrl, "root", "MyPass");


    // the mysql insert statement
    String query = " insert into data (unit, value)"
            + " values (?, ?)";

    // create the mysql insert preparedstatement
    PreparedStatement preparedStmt = null;
    preparedStmt = conn.prepareStatement(query);
    preparedStmt.setString (1, unit);
    preparedStmt.setString (2, value);

    // execute the preparedstatement
    preparedStmt.execute();
    conn.close();

}
 
I ran
 
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'MyPass' WITH GRANT OPTION;
 
but nothing changed. 
 
My my.cnf is all commented out. My local ip is 192.168.1.46. I tried to use this ip and 127.0.0.1 instead of localhost on the myUrl variable but nothing changed.
 
I restarted the mysql server, eclipse and pc without success. 
 
Edit: additional info I stopped the server and ran the code. I get the exact same exception. I guess somehow I can't reach the server at all.
 
I am able to use "localhost" in my Python script. It writes on the same table as the java code. 

原文：https://stackoverflow.com/questions/43673461