为什么第二句异常 Server configuration denies access to data source ?
...全文
8124打赏收藏
求救linux下mysql的jdbc问题
Class.forName("org.gjt.mm.mysql.Driver"); con=java.sql.DriverManager.getConnection("jdbc:mysql://localhost/test","root","123456"); 为什么第二句异常 Server configuration denies access to data source ?
mysql> select * from user where 1 limit 0,30;
+-----------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
+-----------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| localhost | root | 565491d704013245 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| localhost | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
+-----------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
2 rows in set (0.00 sec)
| Host | Db | User | Select_priv | Insert_priv | Update_priv | Delete_
priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alt
er_priv |
+-----------+---------+------+-------------+-------------+-------------+--------
-----+-------------+-----------+------------+-----------------+------------+----
--------+
| % | test | | Y | Y | Y | Y
| Y | Y | N | Y | Y | Y
|
| % | test\_% | | Y | Y | Y | Y
| Y | Y | N | Y | Y | Y
|
| localhost | test | root | Y | Y | Y | Y
| Y | Y | N | Y | Y | Y
|
+-----------+---------+------+-------------+-------------+-------------+--------
-----+-------------+-----------+------------+-----------------+------------+----
--------+
3 rows in set (0.01 sec)
里面存储了哪些可以访问,哪些不可以
編輯 刪除 172.16.58.178 haweather root Y Y Y Y Y Y N Y Y Y
編輯 刪除 172.16.58.113 haweather root Y Y Y Y Y Y N Y Y Y
編輯 刪除 172.16.58.151 haweather root Y Y Y Y Y Y N Y Y Y
編輯 刪除 172.16.58.160 ktfjoyme root Y Y Y Y Y Y N Y Y Y
編輯 刪除 172.16.58.71 haweather root Y Y Y Y Y Y N Y Y Y
編輯 刪除 172.16.58.17 haweather root Y Y Y Y Y Y N Y Y Y
編輯 刪除 172.16.58.14 haweather root Y Y Y Y Y Y N Y Y Y
編輯 刪除 172.16.58.100 ktfjoyme root Y Y Y Y Y Y N