Connecting to mysql
 

Hi: I have installed mysql3.23.55 on linux RH7.1. Now mysql is running successfully on my system. When I try connecting thru
java(mysql-connector-java-3.0.1) I am getting an Access Denied error. It says mysql@machinename access denied.
Now i tried from command line: mysql -u mysql -p -h localhost. This works, but when i give:mysql -u mysql -p -h machinename it doesnt work.
Why is that? The user mysql has all priviliges granted. Thanks for any help on this.

You should check your permission grants ... like users can be allowed only to connect from localhost or from anywhere (in that case a username@"%" would be in the grant line).

If you need more help read up on GRANT

Thanks a lot. I got it now.