Table of Contents
Issue
I’m installing the MySQL8.0.18. While applying the configuration, whenever I press the execute it stops on starting the server and does not configure it. In the log tab, it says;
Beginning configuration step: Starting the server
Attempting to start service MySQL80...
Failed to start service MySQL80.
Waiting until a connection to MySQL Server 8.0.18 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.
Waiting 5 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.
Waiting 5 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.
Waiting 5 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.
Waiting 5 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.
Waiting 5 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.
Waiting 5 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.
Waiting 5 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.
Waiting 5 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.
Waiting 5 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.
Failed to connect to MySQL Server 8.0.18 after 10 attempts.
Ended configuration step: Starting the server
I don’t know if its the location error or something because I saved my setup in E:\setups\mySQL\setup. It gives the error shown in the snapshot.
I tried to solve it according to the first answer here but it doesn’t seem to help.
I tried to reinstall it but it still gives the same error somehow. what should I do?
Solution
Well, Error 2 in MySQL simply arises due to missing file or wrong location. Probably the path of the service you are trying to run is wrong or missing.
Here are some reference of the same problem
- windows could not start the MySQL. service on local computer. Error 2 : The system cannot find the file specified
- MySql service Error 2: the system cannot find the file specified
- Could not start the MySQL service on Local Computer. Error 2 [FIXED]
- the MySQL service on local computer started and then stopped (Can also give this a look)
Possible Solution:
Check if the path to the service MySQL80 is proper and all the files exists with proper execution and network permissions. If nothing works, you can always use a different version to see if it is working there and if it does, report a bug in the new version.
Answered By – Aman Nirala
Answer Checked By – Gilberto Lyons (BugsFixing Admin)