Hello All,
I'm testing the jdbc driver for mysql db. Whenever I try to start the
driver I get the following error...

>
> Message: Code(-9005) The driver returned a "fatal" status indicating
> that the driver should be shut down. Detail from driver:
> <description>Unable to connect. Authenticati
> on failed.</description>
> <jdbc:exception
> jdbc:class="com.mysql.jdbc.exceptions.jdbc4.MySQLS yntaxErrorException"
> jdbc:error-code="1044" jdbc:sql-state="42000"
> xmlns:jdbc="urn:dirxml:jdbc">
> <jdbc:message>Access denied for user 'root'@'11.11.11.11' to
> database 'indirect'</jdbc:message>
>
>


I know that password for root is right as I can connect mysql with the
pwd.

>
> sles11-02:~ # mysql -h localhost -u root -pmysql99
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 29
> Server version: 5.0.67-Max SUSE MySQL RPM
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql>
>


And I have given the rights to root to connect from the server...

>
> mysql> SHOW GRANTS FOR 'root'@11.11.11.11;
>
> +------------------------------------------------------------------------------------------------------------------+
> | Grants for root@192.168.10.128
> |
> +------------------------------------------------------------------------------------------------------------------+
> | GRANT USAGE ON *.* TO 'root'@'11.11.11.11' IDENTIFIED BY PASSWORD
> '*B4F77D38FD091371A5CA9BD394344E0DF94CA273' |
> | GRANT ALL PRIVILEGES ON `testdb_mysql`.* TO 'root'@'11.11.11.11' WITH
> GRANT OPTION |
> | GRANT SELECT ON `testdb_mysql`.`test_hr` TO 'root'@'11.11.11.11'
> |
> +------------------------------------------------------------------------------------------------------------------+
> 3 rows in set (0.00 sec)
>
>


I'm not sure if I miss anything else. Could someone shed some light on
this.

Regards


--
s_novell
------------------------------------------------------------------------
s_novell's Profile: http://forums.novell.com/member.php?userid=17863
View this thread: http://forums.novell.com/showthread.php?t=451731