?
Solved

MySql remote connection error 2003

Posted on 2008-10-02
11
Medium Priority
?
564 Views
Last Modified: 2013-12-05
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
0
Comment
Question by:darien_software
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 4
11 Comments
 
LVL 12

Accepted Solution

by:
rionroc earned 2000 total points
ID: 22625044
Hello

Grant again with no password for testing.

GRANT ALL ON *.* TO root@'%'


OR

simply apply:
FLUSH PRIVILEGES;
after granting to any user.


Great is our GOD.
:)
0
 

Author Comment

by:darien_software
ID: 22631257
hi rion
thanks for the reply
i have done what u have told but still no respite..

anyother way around??
0
 
LVL 12

Expert Comment

by:rionroc
ID: 22631730
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.
:)
0
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 

Author Comment

by:darien_software
ID: 22632293
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

0
 

Author Comment

by:darien_software
ID: 22632313

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
0
 

Author Comment

by:darien_software
ID: 22632580
should i also do the same thing on the client machine also?
0
 

Author Comment

by:darien_software
ID: 22632676
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.
0
 
LVL 12

Expert Comment

by:rionroc
ID: 22633370
>>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?




0
 

Author Comment

by:darien_software
ID: 22634301
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
0
 

Author Comment

by:darien_software
ID: 22634357
will be helpful for everyone
0
 
LVL 12

Expert Comment

by:rionroc
ID: 22635824
Hmp!

I though windows firewall excluded mysql already and I though you already did.

Anyway thanks.


Great is our GOD.
:)
0

Featured Post

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question