<< Kyle Cordes: Scripting Your Java App | Home | Sun Frees Its JDK >>

Help: MySQL on Windows XP Hates Newbies

It must be the blogs I read.

For some reason, I decided to give MySQL a try. You may laugh at me, but I have never installed MySQL on Windows before, not because I don't like MySQL, but because I never had the need for it, having figured out how to make the PostgreSQL from Cygwin to work.

So I went to their website, downloaded the thing, unzipped it and ran the setup.exe. Everything seems to be cool, except that after the installation, the MySQL command line tool won't run. When I select the menu item, a command window pops up, asking me for the password. I enter the password, the one I supplied a moment ago when I did the installation, and the machine beeps and the command window goes away.

I have verified that the MySQL service has started. I have also opened up port 3306 on my Windows firewall.

What did I do wrong.

Help!

And thanks.

Tags :


Re: Help: MySQL on Windows XP Hates Newbies

Did you try, on command line, either "mysql" or "mysql -uadmin -p"? Also sometimes Windows shows a service as "started" doesn't necessarily mean it actually started successfully. I would try starting mysql manually from command line.

Re: Help: MySQL on Windows XP Hates Newbies

Weiqi, open a DOS shell and try something like this: C:\MySQL Server 4.1\bin>mysql -u root -p jason

Re: Help: MySQL on Windows XP Hates Newbies

Thanks everybody for the kind suggestions, especially Dean Wette who emailed me alerting me that my spam filter is rejecting legitimate comments.

I'm using Pebble's spam filter listeners, including the "delete rejected" listener. So I didn't even know that someone has commented and that the comment has been rejected. I turned that off today and saved the two comments from the rejected pile.

As for my original problem, it's all MySQL's fault. It turns out that my original installation was never successfully completed. In the last step of the configuration wizard, it saved the settings into my.ini, it started the server, but failed to save the security setting. The reason? Access is denied for 'root'@'localhost'.

I copied the error message and pasted it into Google. Several MySQL hosted pages were found. So I'm not alone in having this problem. However all the suggestions posted by others (as well as the two comments here, and Dean's email suggestion, and another reader's email suggestion) did not work for me.

Someone even filed a bug report in MySQL's public bug database, which engenderd a response from MySQL that states essentially "this is a bug database, not a support forum."

So I'm stumped. And I'll give up MySQL for a while.

Thanks for your persistence in your attempts to circumwent a spam filtering system gone awry.


Add a comment Send a TrackBack