Re: error configuring mysql?
"John Salerno" <johnjsal@NOSPAMgmail.com> wrote in message
news:4426ef80$0$29874$c3e8da3@news.astraweb.com...
> Hi everyone. I hope someone can me with this problem. I have
> installed MySQL CE 5.0, but during the configuration wizard I get an
> error.
>
> It has frozen up during the final step (MySQL Server Instance
> Configuration). I'm installing it on Windows XP, and I used all the
> default settings, except that I changed "Detailed Configuration" to
> "Standard Configuration". At the "Start Service" item in the checklist, I
> got a 1045 error message saying to allow TCP port 3306. I tried creating a
> rule for this in Norton, but it didn't seem to work.
>
> So then I turned off Norton completely, restarted, tried the wizard, and
> now it puts a red 'x' in the "Start service" checklist and says "The
> service could not be stopped. Error: 0".
Is there something else using port 3306?
C:> netstat -ao
Look for "hostname:3306" in the local address. The rightmost column should
be the process ID.
C:> tasklist /fi "PID eq NNN"
Where NNN is the process ID number you got from netstat.
Another place to look for clues: "C:\Program Files\MySQL\MySQL Server
5.0\data\<hostname>.err" Look for error messages that may explain why the
service won't start.
Also try starting and stopping the service from the command-line:
C:> net start mysql
C:> net stop mysql
See if there are any more clues from error messages.
Regards,
Bill K.
|