Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
Highlighted
s_novell Absent Member.
Absent Member.
457 views

>Access denied for user 'root'


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.MySQLSyntaxErrorException"
> 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

Labels (1)
0 Likes
3 Replies
Anonymous_User Absent Member.
Absent Member.

Re: >Access denied for user 'root'

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Your driver config is telling the shim to connect to 'indirect', for
which you have no rights other than usage (which means nothing to the
database itself I believe. You have rights to 'testdb_mysql' but that's
not 'indirect' so it doesn't matter.

Good luck.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.18 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQIcBAEBAgAGBQJPKxB7AAoJEF+XTK08PnB5RIIP/i1fgTmyoYPkazGJcJ8+mxIL
06FOS19eceoLgX3K7gU2vl79026agq6zJdQ5sptPMLrn9gBCZsjyYNpe5g8KppZh
r0/PSrUI74WEjfe2Z/UFDscrDn3jFI9mobY5ilFa6i0W7M6anZsTnZnLHKjtnvDI
G+0vZS+XhGcCk+SI8gQOVR5Gdxx/OQnnweBqDR6D5l5ZiNgHhN10/j41A4J2Jw5e
CocxW+wD8g4kcCYvNHvnZnJsmripSkeZ7gVUSPE3KgxigIfMLhfeNHilXN+HEfNE
g2dww15mG/z7r6zQFLxtcD7pgDaSvADKkkoAQtiXFJVaMIP/n/LhNcOUkROpTsAj
NfHLoolMHkEaYCZ3cRvdqQ82p6/A6KlNNIRnxD+unTYlEtgjvvmr+1Z3NFFMTlu7
tj3Zl66TJtNBhDriqZeKUZjs518sh8Yg4c91zQ7QAlpDuOvxPJZOIjmWfyCLGS4K
DFo7B+qEN4DhmgZSHQT/dzfTJjKlEwkX6MWNrqm/sHCsvJVIYiVjpftxQ1XoVTdV
v2IRaPRSZrlTXLOmBRN5A8mLTVfmrahLLI9Elez8HRoOSeAUOCKbT0gY1wSkkthK
sE0wkMNpBb5LXRRHm1iYcS0X3CPoeJ9LhHlS1XcX/0v5n88q0tf9x+I2vR/1QK3R
m5l6EAjJ/HY30AdX27u/
=XuCi
-----END PGP SIGNATURE-----
0 Likes
s_novell Absent Member.
Absent Member.

Re: >Access denied for user 'root'


Thanks AB. I updated the driver config with right db name and everything
is working fine.


--
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

0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: >Access denied for user 'root'

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Sweet! Thank-you for posting back a confirmation.

Good luck.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.18 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQIcBAEBAgAGBQJPLCAQAAoJEF+XTK08PnB5NDwP/ia1OKtKb8jZ/ELj4ziupnAx
/Kmn7Tw7hLLDUSutYWO6bBKuCUU39UeYBLR2pT2xk6K5dlPQ/Z3T5w7hdjEbETJ3
CF82DBM4S5zz55hLQnpRfPH3HWYVTZO2EmS/hnI6/tt5XwVfxDEyPypcCVfQgTlq
bAzEdIKOsxWNxlk1f+MaGALpi0LysA79PWNOhZUogzCeZi/6ab92q3Kpa4Wkfzt/
356yu+uVVaTJf+M1hjmslrv+mKESwSSLrxDLnOFihd1o88MZDLJF/Hvs9J/eWG8W
yFoLUYVTBQ/tZ+kNl4H8RieCNPrZPDnHilYQPQFPRv8XNEtGB68buCvMChLbwRmO
2uqCV6Pj2Z+ApTtQkmqgkKPqkXZwV8L1o+d0ciYvQY9A7BgFL3HLfoqTPikmxGDV
SZiZjbxTPz1ztvgAL3RrKKuM6L2jLhukX6DrVWxOi1jHkccR4MT+Bc0SCuGd7Ays
yYWdepAvxjHXHFQr0ICpLox3RpXuxU9plblZ2dtJ8lakNBipnJxBearjRiuXHdTy
eJEl1Jr0+t+/bvAmjWA1towLjt7jtRliUJcGfMU6wRwxK/b08vk4oD/VedimcB9u
YlfoJTZFWNQGdDGjDA26AJoD93nJv00KgDhlGuhqtV195P++g9b2qntwCc6+4Mjz
2wc93tHiaP9Qk63i+Uo7
=75pH
-----END PGP SIGNATURE-----
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.