Training, Open Source computer languages
PerlPHPPythonMySQLApache / TomcatTclRubyJavaC and C++LinuxCSS 
Search for:
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
Python, Lua and Tcl - public course schedule [here]
Private courses on your site - see [here]
Please ask about maintenance training for Perl, PHP, Java, C, C++, Ruby, MySQL and Linux / Tomcat systems
2003 Error cannot connect to MySQL on Win XP Home

Posted by Chris_Isaac (Chris Isaac), 15 January 2006

I've installed MySQL in my Win XP Home ed machine, If I use the MySQL Command line client I can access Mysql ok, but I keep getting the above error if I try to connect from the command line window that I've opened.  Have tried altering my security setting but no joy.

This is the command I've tried:

mysql -h localhost -u root -p

It then asks me for a password, then comes up with the error.

Myqsl is refinately running, can anyone point me in the right direction?


Posted by admin (Graham Ellis), 15 January 2006
Is there a second line to the error message - "wrong authentication protocol" or something like that?

Posted by Chris_Isaac (Chris Isaac), 15 January 2006
Ok... Don't you just hate it when you ask a question, then have a brain wave.....

I've cured the problem.... My fault, when I originally run the MySQL Server Config Wizard I had not selected the Include Bin directory option.

Now working.

Posted by Chris_Isaac (Chris Isaac), 15 January 2006
Sorry Graham, you're too fast at responding   was just replying when you answered.

Thanks anyway.

Posted by admin (Graham Ellis), 15 January 2006
Hey, Chris ... glad it's sorted and I expect people to carry on "worrying" the problem what they've posted it.  

What has got me really p***ed off in the past is when someone (NOT you) has posted a problem, then fixed it within a few minutes but left the question hanging around for several days and reacts with surprise when someone answers

This page is a thread posted to the opentalk forum at and archived here for reference. To jump to the archive index please follow this link.

You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2018: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01225 708225 • FAX: 01225 793803 • EMAIL: • WEB: • SKYPE: wellho