I am absolutely new to MySQL, so bear with me if this sounds foolish. I am trying to connect to a MySQL db. I have got MySQL 5 installed on a windows XP machine and MySQL 4 installed on Fedora 4 machine.
I have written a test program in java to connect to MySQL db. The db creation script is same on both the MySQLs. I have created the user using following command: grant all privileges on *.* to 'abcd'@'localhost';
Running the test program on windows, I am able to connect to db for root and abcd user. But, on the Fedora machine, I am not able to connect to db for any user other than root. It gives me error as
java.sql.SQLException: Access denied for user ''@'<mahine_name>'
The surprising part is, it is not printing the username in the exception string.
Can anyone please tell me, where does the problem lie.