how to connect to mysql remotely 1

[dezwald]

i've been having trouble trying to connect to my mysql database on my web server from desktop computer (my working computer) via my IDE editor. i receive a message saying ERROR 2003: cannot connect to mysql server 'xxx' (10061)

my web server and desktop computer are within the same network

i can connect to my mysql database via web through PHPMyAdmin but not remotely through a desktop application on my working pc.

i know this can be done... but i don't know what i need to do to configure my mysql server to allow me to connect to it

 

[IPGuru]

What OS is being used for your server & also the remote PC
what application are you trying to connect to your Mysql database?

 

[dezwald]

my web server is ubuntu 7.10(linux) and my desktop is windows XP

i am using PHPed (which is an php IDE editor) to connect to the mysql database.


I know it's not the editor or OS because i have used the editor to connect remotely to another mysql server (on a linux machine) before.

 

[Kozusnik]

phpMyAdmin actually connects through localhost on the server. You'll need to add a new user with rights from % (not localhost). Or change a current user from username@localhost to username@your_client_ip, or username@% for any remote client.

If you're not comfortable with mysql shell commands, you can use the Privileges link in phpMyAdmin. Otherwise it's...

GRANT * PRIVILEGES on db_name.* to username@% IDENTIFIED by PASSWORD('password');

FLUSH PRIVILEGES;

You don't have to grant all privileges. It could just be SELECT.

Clear as mud?

Mark

 

[Kozusnik]

Check the format of the grand command. I'm taking it from memory. I think you may need to have 'username'@'%'.


Mark

 

[dezwald]

haha yes, clear as mud!

thank you very much! i will try your instructions out.

this sounds like it will solve my problem now.