MySql remote connection error 2003
Posted on 2008-10-02
i have a client system installed with
MS Windows xp and the ip address of it (i made static also ) as 192.168.1.29
and my server has
MS Windwos 2000 and its ip address is 192.168.1.10
I have installed MySql5.0 latest version on the server and was trying to connect from the client and i was getting this error
" cant connect to mysql server on 192.168.1.10 "
so i have referred to lots of material and many of the similar questions in this forums and in one the solutions ,it was advised to use the below
TO root@'%' identified by 'password';
and i have tried this and no use.
so i went ahead and also created a user with
user - root
Hostname - 192.168.1.29
password - password
and when i try to connect from the remote client,still the same issue.
please suggest how to go about as this is very important