I'm experimenting with mysql but when I do the part to create the service it fails

on the final step it failes to start the service sometimes and other times it says unable to connect to port 3306

its windows server 2003 32bit
mysql-5.5.8
I have the windows firewall disabled to remove that as a factor

is there a command to get verbose info to find what the issue is?

you can check the eventviewer for any possible problems with installation

other times it says unable to connect to port 3306

Most likely mysql is not removed completely when trying to reinstall.
After un-install, check registry for mysql record and remove manually.

I'm experimenting with mysql but when I do the part to create the service it fails

on the final step it failes to start the service sometimes and other times it says unable to connect to port 3306

its windows server 2003 32bit
mysql-5.5.8
I have the windows firewall disabled to remove that as a factor

is there a command to get verbose info to find what the issue is?

Remove MySQL and delete its folder and do a reinstall.

I tried deleting the c:\datafiles\ folder and the \programfiles\mysql folder also searching the registry for any mysql ref that wasn't part of php

then a winsock reset and tried installing again and got the same error

just to try on another computer I installed it on my work computer and it fails on the 4th step (error 2003) can't connect

I did a netstat -a and see that its listening on 3306 and added an exeption to the firewall but it still fails

I think I found the solution but its not good news

on trying to install on a win xp computer I got the failed to connect and tryed a few thengs ending with uninstalling ipv6 and that worked

sadily I use ipv6 on my home server so this brings up issues that maybe someone can help me with

so I'm assuming that if I uninstall ipv6 on my 2003 server at home that the install will work but then if I reinstall IPv6 will it keep working

post update on this that should help us study, IPv6 causing issue on MySQL connectivity? global IPv4 pool exhausted http://ipv6.he.net/statistics/

on returning home to install on my server I also found the the innodb was failing to register correctly andwas another issue

but on terrling it to use the other engine only and having ipv6 temparerly uninstalled imysql installed successfully

on the work computer until I uninstalled ipv6 I was getting unable to connect to localhost:3306 when it tried to apply the security policy (just on a wild hunch I uninstalled ipv6 w/o rebooting and then hit retry and it worked right away

sadily after all that the info for installing cacti seemed to be out of dat for the current php and mysql and thus got to a point where I couldn't keep following it and for now installed PRTG to do the snmp monitoring I had wanted to do

All you need to do is to remove the old installation first ( completely) and then reinstall the mysql. The best choice to install would be xampp.

yes I had done that
remove the instance
uninstall mysql
delete all mysql entries in the registry
run netsh winsock reset
reboot

install mysql
configure service
fail to start service

on removing ipv6 and telling it to not use inndb it then installed but the info for cacti was out dated from the current mysql/php and I don't feel like going through that trouble with a differant ver of mysql

Maybe try reloading OS then install mysql?

its not deticated to mysql so reloading the OS just for that would be quite exessive

I've had a problem like this before on a re-install and going off memory there was also a mysql data folder that needed to be deleted. It was outside of the 'Program Files' folder and DB data folder.

Check these locations:

Win 2003: C:\Documents and Settings\All Users\Application Data
Win 2008: C:\ProgramData\

On 2008 you need to enable the option to 'show hidden files and directories' in order to see \ProgramData in the Explorer.

See if you have a 'mysql' folder in either of those locations.

Good luck -

Wayne