darien_software
asked on
MySql remote connection error 2003
Hi
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
GRANT ALL
ON *.*
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
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
GRANT ALL
ON *.*
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
OK
Just be sure where you set the GRANT and FLUSH PRIVILEGES, either to your localhost(1.10) computer or to your server(1.29)
Great is our GOD.
:)
Just be sure where you set the GRANT and FLUSH PRIVILEGES, either to your localhost(1.10) computer or to your server(1.29)
Great is our GOD.
:)
ASKER
hi rion
well the server is (1,10) and local host is (1,29)
well i have given Grant and Flush privileges on the Server(1,10) and i am trying to access this MySql database from a client which is the local host(1,29)..
so even after entering these details,i am having the same problem
please guide
well the server is (1,10) and local host is (1,29)
well i have given Grant and Flush privileges on the Server(1,10) and i am trying to access this MySql database from a client which is the local host(1,29)..
so even after entering these details,i am having the same problem
please guide
ASKER
hi rion
well the server is (1,10) and local host is (1,29)
well i have given Grant and Flush privileges on the Server(1,10) and i am trying to access this MySql database from a client which is the local host(1,29)..
so even after entering these details,i am having the same problem
please guide
ASKER
should i also do the same thing on the client machine also?
ASKER
well i have run the instructions on the client machine also.But whatever i did with the resources.still getting the same error.
connecting from client to server and also tried from server to client
no respite.
connecting from client to server and also tried from server to client
no respite.
>>should i also do the same thing on the client machine also?
No
Just want to ask this:
Are you trying to develop a database program?
Or just connecting via MySql query browser?
No
Just want to ask this:
Are you trying to develop a database program?
Or just connecting via MySql query browser?
ASKER
hi rion
thanks for ur feedback
well i have used the grant command which was ending "with grant option " and it worked
well i have also diabled all my firewalls(default and installed) and it worked
well now i configured my firewall so i am able to connect on 2 way basis
and also
i guess i need MySql on the client machine to be installed for it to conenct to the server ..
well my suggestions to ones have this problem
1.As the above replies says
use grant command with root@% or ip address to grant privileges
2.check your firewalls,thats important.What we dont guess will stop,will be blocking the connectivity.
3.Have MySQL also installed on client machine even though we are accessing the database on the server
with these options i guess this error will be solved
thanks rion for your help
thanks for ur feedback
well i have used the grant command which was ending "with grant option " and it worked
well i have also diabled all my firewalls(default and installed) and it worked
well now i configured my firewall so i am able to connect on 2 way basis
and also
i guess i need MySql on the client machine to be installed for it to conenct to the server ..
well my suggestions to ones have this problem
1.As the above replies says
use grant command with root@% or ip address to grant privileges
2.check your firewalls,thats important.What we dont guess will stop,will be blocking the connectivity.
3.Have MySQL also installed on client machine even though we are accessing the database on the server
with these options i guess this error will be solved
thanks rion for your help
ASKER
will be helpful for everyone
Hmp!
I though windows firewall excluded mysql already and I though you already did.
Anyway thanks.
Great is our GOD.
:)
I though windows firewall excluded mysql already and I though you already did.
Anyway thanks.
Great is our GOD.
:)
ASKER
thanks for the reply
i have done what u have told but still no respite..
anyother way around??