下面是所报的错。。迷茫中
大家看一下。。谢咯
Exception in thread "main" java.sql.SQLException: Access denied for user 'root'@
'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)
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:185)
at ConnectionProvider.getConnection(ConnectionProvider.java:22)
at ResultSetDemo.<init>(ResultSetDemo.java:36)
at ResultSetDemo.main(ResultSetDemo.java:141)
大家看一下。。谢咯
Exception in thread "main" java.sql.SQLException: Access denied for user 'root'@
'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)
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:185)
at ConnectionProvider.getConnection(ConnectionProvider.java:22)
at ResultSetDemo.<init>(ResultSetDemo.java:36)
at ResultSetDemo.main(ResultSetDemo.java:141)
2.分配表中没有ROOT的当前权限MYSQL对每个用户采取localhost或者远处访问分别配置的方法,通过MYSQL的GRANT命令来分配
完整的GRANT命令GRANT priv_type[(column_list)] [,priv_type[(column_list)]] ...
ON [object_type] {tbl_name| * | *.* |db_name.*}
TOuser[IDENTIFIED BY [PASSWORD] 'password']
[,user[IDENTIFIED BY [PASSWORD] 'password']] ...
[REQUIRE
NONE |
[{SSL| X509}]
[CIPHER 'cipher' [AND]]
[ISSUER 'issuer' [AND]]
[SUBJECT 'subject']]
[WITHwith_option[with_option] ...]object_type=
TABLE
| FUNCTION
| PROCEDUREwith_option=
GRANT OPTION
| MAX_QUERIES_PER_HOURcount| MAX_UPDATES_PER_HOURcount| MAX_CONNECTIONS_PER_HOURcount| MAX_USER_CONNECTIONScount简单的说就是
grant 允许的操作类型(select,insert.....或者all) on 数据库名.数据库表(支持通配符*.*) to 用户@"本地/远处" IDENTIFIED by '密码'示例
grant all on *.* to user@"localhost" identified by '123'
表示将所有数据库的所有操作权限,授权给本地登陆的user用户将localhost改成%
grant all on *.* to user@"%" identified by '123'
表示将所有数据库的所有操作权限,授权给远程登陆的user用户