How to connect mysql which is on remote machine

[san monte]

Hi
i am vb.net programmer. There is a problem related to MySql server. MySql server is on remote machine and i want to connect it with MySql Administrator.
The error no is 1045 and the error is 'Acess denied for user 'san'@'IP Address' (Using Password 'Yes')
Can anybody tell me the procedure how to connect to MySql server giving IP address.
I am using winxp and MySql is on linux server.


Thanks
Sandeep Sharma

 

[jmcilhinney]

Moved to more appropriate forum.

 

[kulrom]

mySQL connection to a remote server

This is the conn string to a remote server (via IP address):

"DRIVER={MySQL ODBC 3.51 Driver};SERVER=124.124.xx.xx;PORT=[b]3306[/b];DATABASE=myDatabase; USER=myUsername;PASSWORD=myPassword;OPTION=3;" 
'notice that i've bolded port as i guess that's the part you've missed

However, there should be not difference (Linux/Windows) while IP and PORT No. are correct.

HTH
Regards

 

[kulrom]

Btw, i suppose you have done this but anyway. Notice that GRAND command must be executed from mySQL Server located on Linux machine in order to let your windows machine to access certain DB.

GRANT ALL ON dbName.* TO 'user'@'IP_windows_address' IDENTIFIED BY 'password'

Regards