Please I need some help here, I don't think I understand the "rights"
architecture in MySQL.
I'm trying to connect like this:
Connection conn =
DriverManager.getConnection("jdbc:mysql://localhost:3306/homebrew?user=homebrew&password=maaler");
But I get the following error:
SQLException: Cannot load connection class 'java.sql.SQLException: Server
configuration denies access to data source'.
SQLState: 08001
VendorError: 0
I have created a database and executed the following grants:
GRANT SELECT, INSERT, UPDATE, DELETE, INDEX ON homebrew.* TO homebrew@localhost
identified by 'maaler' WITH GRANT OPTION;
But I'm not so sure I understand this grant stuff. If I make a "SELECT
* FROM USER" in the MYSQL database I get the following:
+-------------+----------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| 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 | 4d940be86f94e167 | Y | Y | Y
|| Y | Y | Y | Y | Y | Y
|| Y | Y | Y | Y | Y |
| neigaard1 | root | 4d940be86f94e167 | 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 |
| neigaard1 | | | N | N | N
|| N | N | N | N | N | N
|| N | N | N | N | N |
| 192.168.1.3 | root | 4d940be86f94e167 | Y | Y | Y
|| Y | Y | Y | Y | Y | Y
|| Y | N | Y | Y | Y |
| localhost | homebrew | 7cef02e455de0f96 | N | N | N
|| N | N | N | N | N | N
|| N | N | N | N | N |
+-------------+----------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
--
Med venlig hilsen/Best regards,
Søren Neigaard mailto:[EMAIL PROTECTED]
--
"Mind what you have learned. Save you it can."
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
