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
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.
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