mysql 192.168.0.%_java连接本机mysql

java连接本机mysql，本机ipv4是 192.168.0.154，Access denied for user 'root'@'192.168.0.154' ，求助grant all privileges on *.* to root@'%' identified by

java连接本机mysql，本机ipv4是 192.168.0.154，Access denied for user 'root'@'192.168.0.154' ，求助grant all privileges on *.* to root@'%' identified by 'root';运行这句后重启服务也不行

、、、、、、、、、、、、、、、、

public Connection getConnection() { // 连接数据库方法

try {

Class.forName("org.gjt.mm.mysql.Driver");

// con = DriverManager.getConnection(

// "jdbc:mysql://127.0.0.1:3306/test", "root", "0000"); /这样正确

con = DriverManager.getConnection(

"jdbc:mysql://192.168.0.154:3306/test", "root", "YES");这样错误，Access denied for user......

} catch (Exception e) {

e.printStackTrace();

}

return con; // 返回Connection对象

}

java.sql.SQLException: Access denied for user 'root'@'192.168.0.154' (using password: YES)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:927)

at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1709)

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1252)

展开

全部