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