Training, Open Source
computer languages


PerlPHPPythonMySQLApache / TomcatTclRubyJavaC and C++LinuxCSS 

Search our site for:
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
2003 Error cannot connect to MySQL on Win XP Home

Posted by Chris_Isaac (Chris Isaac), 15 January 2006
Hi

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:

Code:
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?

Thanks

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 www.opentalk.org.uk and archived here for reference. To jump to the archive index please follow this link.


WELL HOUSE CONSULTANTS LTD.: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 707126 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho