Hi all,
As the title says, when attempting a fresh install of 5.5.16 the installer fails at the configuration step with the following output:
mysql-server-5.5-winx64:6 - Looking for valid template
mysql-server-5.5-winx64:13 - Found valid template.
mysql-server-5.5-winx64:20 - Attempting to process template.
mysql-server-5.5-winx64:26 - Processed template.
mysql-server-5.5-winx64:33 - Attempting to configure service.
mysql-server-5.5-winx64:40 - Configured service.
mysql-server-5.5-winx64:46 - Attempting to start service.
mysql-server-5.5-winx64:53 - Started service.
mysql-server-5.5-winx64:73 - Attempting to update security settings.
mysql-server-5.5-winx64:100 - Unable to update security settings. Unable to connect to any of the specified MySQL hosts.
mysql-server-5.5-winx64:86 - Attempting to verify command-line client shortcut.
mysql-server-5.5-winx64:93 - Verified command-line client shortcut.
mysql-server-5.5-winx64:100 - Product configuration controller finished configuration.
Due to the security settings/connection issues, the installer can't continue. I've been looking for a solution for this problem for a few hours now and can't find anything, so any advice would help. Info:
Win Vista 64
Logged in as Admin
ZoneAlarm and Windows Firewall disabled
Internet connection disconnected
Enable TCP/IP networking unchecked
Developer version installed
UAC was told the installer was trusted
Although the log says the service was started, I can't connect to it using the workbench. There is no error log as described here:
http://dev.mysql.com/doc/refman/5.5/en/windows-start-service.html. Testing as described here:
http://dev.mysql.com/doc/refman/5.5/en/windows-testing.html produces:
C:\Program Files\MySQL\MySQL Server 5.5\bin>mysqlshow
mysqlshow: Can't connect to MySQL server on 'localhost' (10061)
C:\Program Files\MySQL\MySQL Server 5.5\bin>mysql test
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
C:\Program Files\MySQL\MySQL Server 5.5\bin>mysqladmin verison status proc
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'
If I run the standalone MySQL Instance Configuration Wizard it just hangs at the Apply Security Settings step.
At this point, given the cryptic nature of the error message, I don't know what else to check. Anyone have any ideas?
Thanks.
P.S. I haven't tried telneting to the server because it takes forever to install on Vista for some reason and I don't see any reason to believe that the service is running at this point. EDIT: it is running, see below.
Edited 1 time(s). Last edit at 10/12/2011 11:01PM by annoyed guy.