How to connect to mysql database remotely

[CoolBreeze007]

I have installed mysql on a windows XP workstation - lets name the workstation WinXP01. I created a database named say noiseDB. I created a table in noiseDB named tblNoise. I locally connect to the database and table without problems. Basically, I can do whatever I want if I initiate the commands from the local machine. BTW: I use the free version of Toad.

Now, I tried to connect to the database remotely but I get the following error: Access denied for user 'username'@'%' to database 'dbnoise'. username has access as follows:

GRANT USAGE ON *.* TO 'username' @'%' IDENTIFIED BY PASSWORD '*041152D5E9BDECA243435800EACDF7ACEC5B6529';

GRANT ALL PRIVILEGES ON `noisedb`.* TO 'username' @'%';

I also use the free version of Toad to access the remote database.

I would appreciate any help.

 

[ingresman]

have you tried just using the mysql command tool to access the remote server ?. It's usualy better to use the simplest tool to solve issues.
try to get to the root user by:
mysql -hservername -uroot -p**** at the command prompt
where **** is the password set when the server was installed.
I recall at some stage trying to use version 5 and it let me in without a password but not with, very odd and I didn't have time to follow it up.
What version of mysql are you running?
Try settign a user up with a simpler password, that looks a long one !