error configuring mysql?

Hi everyone. I hope someone can help 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".

So I don't know if this is really a Norton/firewall issue or not. I
can't seem to get around this final step.

I hope someone can help me here.

Thanks!

Re: error configuring mysql?

"John Salerno" wrote in message
news:4426ef80$0$29874$c3e8da3@news.astraweb.com...
> Hi everyone. I hope someone can help 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\.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.

Re: error configuring mysql?

Bill Karwin wrote:

First off, thanks very much for responding.


> 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.

Yes, it is listed with a PID of 716.

>
> C:> tasklist /fi "PID eq NNN"
>
> Where NNN is the process ID number you got from netstat.

This says: 'tasklist' is not recognizable as an internal or external
command, operable program or batch file.

> Another place to look for clues: "C:\Program Files\MySQL\MySQL Server
> 5.0\data\.err" Look for error messages that may explain why the
> service won't start.

I searched for '3306' in this file, and it appears in several places,
but they all look something like this:

060325 16:44:17 InnoDB: Started; log sequence number 0 43655
060325 16:44:20 [Note] C:\Program Files\MySQL\MySQL Server
5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.19-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
060325 16:46:39 [Note] C:\Program Files\MySQL\MySQL Server
5.0\bin\mysqld-nt: Normal shutdown


> Also try starting and stopping the service from the command-line:
>
> C:> net start mysql

I get: The requested service has already been started.

> C:> net stop mysql

And: The MySQL service is stopping..
The MySQL service was stopped successfully.


So it seems like it is already running, but I don't know what that
means, since the configuration wizard never completed.

Re: error configuring mysql?

"John Salerno" wrote in message
news:4427395c$0$11187$c3e8da3@news.astraweb.com...
> So it seems like it is already running, but I don't know what that means,
> since the configuration wizard never completed.

Well, I'm wondering if you already had an instance of MySQL running on the
machine. Perhaps a prior version like 4.0 or 4.1. When you tried to
install and configure MySQL 5.0, it may have conflicted with an existing
service.

Look around under "C:\Program Files\MySQL\" or similar locations (the
default install location has changed a couple of times). Do you have any
other directories that may indicate another version of MySQL was installed?

Regards,
Bill K.

Re: error configuring mysql?

Bill Karwin wrote:
> "John Salerno" wrote in message
> news:4427395c$0$11187$c3e8da3@news.astraweb.com...
>> So it seems like it is already running, but I don't know what that means,
>> since the configuration wizard never completed.
>
> Well, I'm wondering if you already had an instance of MySQL running on the
> machine. Perhaps a prior version like 4.0 or 4.1. When you tried to
> install and configure MySQL 5.0, it may have conflicted with an existing
> service.
>
> Look around under "C:\Program Files\MySQL\" or similar locations (the
> default install location has changed a couple of times). Do you have any
> other directories that may indicate another version of MySQL was installed?
>
> Regards,
> Bill K.
>
>

No, I'm pretty sure this isn't possible. I've never used MySQL before,
and even if it somehow came preinstalled, I've since reformatted my HD a
few times, so it wouldn't still be there. When I get a chance, I'll take
a look though, but I don't know how I would have another version because
this is literally the first time I've gone anywhere near MySQL.

The only thing I can think of that is even related to databases is that
after installing a couple of Visual Studio Express Editions, I think SQL
Server 2005 was installed, but I don't know if that would cause a conflict.

Re: error configuring mysql?

"John Salerno" wrote in message
news:4427f455$0$9408$c3e8da3@news.astraweb.com...
> . . . At the "Start Service" item in the checklist, I got a 1045 error
> message saying to allow TCP port 3306.

This is an Access Denied error. Have you read the page in the docs about
this? There are many potential causes for this error.
http://dev.mysql.com/doc/refman/5.0/en/access-denied.html

Also check the Windows Event Log.
Start Menu -> Administrative Tools -> Event Viewer
Look in the 'Application' group, sort by the 'Source' column, and look for
MySQL.
Do you find any error reports of a crashing MySQL service?
This suggestion is based on the following bug log:
http://bugs.mysql.com/bug.php?id=12234
"Signal 11 Service Startup Abort for New Installation"

Which release of MySQL 5.0 are you using? The current release is 5.0.19. I
remember having trouble getting the service started with one of the earlier
releases, when it was still in an Alpha state. At that time, I gave up and
used 4.1. A later release of 5.0 worked better, but I couldn't tell you if
something was fixed in MySQL or if my machine configuration changed.

> The only thing I can think of that is even related to databases is that
> after installing a couple of Visual Studio Express Editions, I think SQL
> Server 2005 was installed, but I don't know if that would cause a
> conflict.

Me neither. I haven't heard of any instance of SQL Server causing a port
conflict.

Regards,
Bill K.

Re: error configuring mysql?

Bill Karwin wrote:

> This is an Access Denied error. Have you read the page in the docs about
> this? There are many potential causes for this error.
> http://dev.mysql.com/doc/refman/5.0/en/access-denied.html

I'm afraid that stuff is way over my head.

> Also check the Windows Event Log.
> Start Menu -> Administrative Tools -> Event Viewer
> Look in the 'Application' group, sort by the 'Source' column, and look for
> MySQL.
> Do you find any error reports of a crashing MySQL service?
> This suggestion is based on the following bug log:
> http://bugs.mysql.com/bug.php?id=12234
> "Signal 11 Service Startup Abort for New Installation"

No errors there. All the MySQL entries say "Information" in that column.

> Which release of MySQL 5.0 are you using? The current release is 5.0.19.

Yes, that's the one I just downloaded. I guess I'm kind of stuck now. I
don't think I know enough to manually fix this problem. I don't know how
to find out more about the port being used (if that's the case).