Installer for 8.0.11 MySQL fails to connect to server

by Philip   Last Updated October 20, 2019 02:01 AM - source

I've attempted to install 8.0.11 several times. As I run thru the installer, I see that the MySQL80 service is running, 2 mysqld processes are running, port 3306 is active and being listened to on address 0.0.0.0 by one of the mysqld processes. And a firewall rule has been added to allow port 3306. But the validation connection to the server fails. If I try to telnet to port 3306 that also fails.

Appreciate any suggestions on what I may be doing wrong.

I've included the log from the installer below:

[Beginning configuration step: Stopping Server 
Stopping MySQL Server instance... 
Ended configuration step: Stopping Server 

Beginning configuration step: Writing configuration file 
Ended configuration step: Writing configuration file 

Beginning configuration step: Updating Windows Firewall rules 
Attempting to delete a Windows Firewall rule with command: netsh.exe advfirewall firewall delete rule name="Port 3306" protocol=TCP localport=3306 

Deleted 1 rule(s). 
Ok. 


Adding a Windows Firewall rule for MySQL80 on port 3306. 
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3306" protocol=TCP localport=3306 dir=in action=allow 
Ok. 


Successfully added the Windows Firewall rule. 
Ended configuration step: Updating Windows Firewall rules 

Beginning configuration step: Adjusting Windows service 
Attempting to grant Network Service require filesystem permissions. 
Granted permissions. 
Adding new service 
New service added 
Ended configuration step: Adjusting Windows service 

Beginning configuration step: Starting Server 
Attempting to start service MySQL80... 
Successfully started service MySQL80. 
Waiting until a connection to MySQL Server 8.0.11 can be established (with a maximum of 10 attempts)... 
Retry 1: Attempting to connect to [email protected]:3306 with user root with no password... 
MySQL error 1042: Unable to connect to any of the specified MySQL hosts. 
MySQL error 1042: Unable to connect to any of the specified MySQL hosts. 
Waiting 3 seconds before the next connection attempt... 
Retry 2: Attempting to connect to [email protected]:3306 with user root with no password... 
MySQL error 1042: Unable to connect to any of the specified MySQL hosts. 
MySQL error 1042: Unable to connect to any of the specified MySQL hosts. 
Waiting 3 seconds before the next connection attempt... 
Retry 3: Attempting to connect to [email protected]:3306 with user root with no password... 
MySQL error 1042: Unable to connect to any of the specified MySQL hosts. 
MySQL error 1042: Unable to connect to any of the specified MySQL hosts. 
Waiting 3 seconds before the next connection attempt... 
Retry 4: Attempting to connect to [email protected]:3306 with user root with no password... 
MySQL error 1042: Unable to connect to any of the specified MySQL hosts. 
MySQL error 1042: Unable to connect to any of the specified MySQL hosts. 
Waiting 3 seconds before the next connection attempt... 
Retry 5: Attempting to connect to [email protected]:3306 with user root with no password... 
MySQL error 1042: Unable to connect to any of the specified MySQL hosts. 
MySQL error 1042: Unable to connect to any of the specified MySQL hosts. 
Waiting 3 seconds before the next connection attempt... 
Retry 6: Attempting to connect to [email protected]:3306 with user root with no password... 
MySQL error 1042: Unable to connect to any of the specified MySQL hosts. 
MySQL error 1042: Unable to connect to any of the specified MySQL hosts. 
Waiting 3 seconds before the next connection attempt... 
Retry 7: Attempting to connect to [email protected]:3306 with user root with no password... 
MySQL error 1042: Unable to connect to any of the specified MySQL hosts. 
MySQL error 1042: Unable to connect to any of the specified MySQL hosts. 
Waiting 3 seconds before the next connection attempt... 
Retry 8: Attempting to connect to [email protected]:3306 with user root with no password... 
MySQL error 1042: Unable to connect to any of the specified MySQL hosts. 
MySQL error 1042: Unable to connect to any of the specified MySQL hosts. 
Waiting 3 seconds before the next connection attempt... 
Retry 9: Attempting to connect to [email protected]:3306 with user root with no password... 
MySQL error 1042: Unable to connect to any of the specified MySQL hosts. 
MySQL error 1042: Unable to connect to any of the specified MySQL hosts. 
Waiting 3 seconds before the next connection attempt... 
Retry 10: Attempting to connect to [email protected]:3306 with user root with no password... 
MySQL error 1042: Unable to connect to any of the specified MySQL hosts. 
MySQL error 1042: Unable to connect to any of the specified MySQL hosts. 
Failed to connect to MySQL Server 8.0.11 after 10 attempts. 
Ended configuration step: Starting Server][1]
Tags : mysql sql


Related Questions


AWS EC2 Instance MySQL Database Server

Updated June 07, 2015 11:00 AM

MySQL Workbench installation

Updated May 17, 2019 15:01 PM



Should I select shared memory or name pipe for Mysql?

Updated November 29, 2016 08:00 AM