Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

unable to connect

Status
Not open for further replies.
I have just installed mysql 5.0.2 on a windows xp machine sp2, I have also installed the mysql administrator 1.0.19. I am unable to connect via the administrator. If I go to the command prompt type in mysql -u root -p I can get in. The installation of mysql is standard, does any one know what I am missing? The following error appears when I try to connect with the administrator.
Could not connect to the specified instance.
MYSQL Error Number 2003
Can't connect to MySql server on 'cool'(10061)
If you want to check the network connection, please click the ping button.
From the ping I get the following
Reply from 10.0.0.63 Time=0ms TTL=128

I have not changed any useraccount info, I am trying to connect with the root account. Should create another account? I have diabled the firewall on my pc.

My main objective it to connect with dreamweaver

Thanks very much in advance
 
What does your mysql 'user' table look like? Do you have root access via 'localhost' and 'remote ip' set-up?

 
I had a similar problem, the solution using MySQL Administrator was:
under 'Startup Variables':
-Select the 'Security' tab
-Check the option 'use old passwords'
-Apply the changes
-Restart the server.

under 'User Administration':
-Select your user (ex: 'root')
-Retype your password in the login area
-'Apply changes'
-Restart the server.

I found this at:

Hope this helps!

X
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top