How can i connect to a remote mysql database


#1

Hi,

Now I’ve got a MySQL database server running in a linux platform… When i try to connect to the database server… using the command mysql -h<00.00.00.00> -umysqluser -p it’s giving an errror saying
“Lost connecteion while query”
what might be the problem… i have added the user and remote host to the database…

plz help me and its urgent
tittoo_alex


#2

Did you make sure that the remote user was granted access appropriately.

By this I mean how is the REMOTE HOST identified in the database. As a quick check you can set it to % which will grant it to ALL hosts.

If that then allows you the access, you might have an issue in how MYSQL is seeing the host name.


#3

Hello friend,

Thanx a lot for your help…

I used "GRANT SELECT,UPDATE,INSERT,DELETE PRIVILEGES ON . TO mysqluser@<***.***.***.***> IDENTIFIED BY "

is it ok or should i try something else

waiting to hear from you
TAT