I am running 3.22.32 server on Sol 2.7. After successfully installing
the server on (server dbserver), I created my database 'foo' and granted
all privileges to '[EMAIL PROTECTED]':
mysql> use mysql;
...
mysql> grant all on *.* to [EMAIL PROTECTED];
...OK...
mysql> update user set password=PASSWORD('silksmitha') where
Host='bajji.myorg.com';
...OK...
When I connect to the server from bajji.myorg.com, the call
DriverManager.getConnection(
"jdbc:mysql://dbserver.myorg.com/MyDb?user=root&password=silksmitha"
);
yields the exception:
java.sql.SQLException: Invalid authorization specification: Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:652)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1511)
at com.mysql.jdbc.Connection.<init>(Connection.java:485)
at com.mysql.jdbc.Driver.connect(Driver.java:341)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
I am puzzled that I should get this exception after I have
granted all the privileges and explicitly updated the
password in mysql.user.
Pl help.
/Rk
---------------------------------------------------------------------
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
