1

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 Mysql@localhost: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 Mysql@localhost: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 Mysql@localhost: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 Mysql@localhost: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 Mysql@localhost: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 Mysql@localhost: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 Mysql@localhost: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 Mysql@localhost: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 Mysql@localhost: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 Mysql@localhost: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.

cannot find the file

I tried to reinstall it but it still gives the same error somehow. what should I do?

RiggsFolly
  • 89,708
  • 20
  • 100
  • 143
icyNerd
  • 473
  • 1
  • 7
  • 18
  • I would start by looking in the Windows Event Viewer for error messages from MYSQL – RiggsFolly Nov 24 '19 at 08:55
  • Also that `Path to Executable" looks odd. I would Uninstall MySQL and start the install again making sure you run it using an Administrator Account – RiggsFolly Nov 24 '19 at 08:58
  • @RiggsFolly how would windows even viewer help? – icyNerd Nov 24 '19 at 09:00
  • _how would windows event viewer help_ MYSQL log errors into the Event Log Before it opens its own text logs. So if you look at the Event Viewer **You may see what the probelm is because you may see an error message** – RiggsFolly Nov 24 '19 at 09:03
  • @nbk i tried to start it manually form services but it's no help – icyNerd Nov 24 '19 at 09:06
  • repeat it, the service takes to long to respond on Windows 10 1903. Like i said a stupid bug. Once it is running no problem even with computer restart – nbk Nov 24 '19 at 09:09
  • @nbk it gives the sem error msg in 8.0.17 which i installed previously. But i installed it before that and it was working fine. I uninstalled it because wampserver was not working fine with it. Now i can't install this as well. – icyNerd Nov 24 '19 at 09:09
  • i tried it several times until it started. that was the first time i thought about using docker instead. – nbk Nov 24 '19 at 09:12
  • @nbk i only want to use MySQL for creating small databases n for learning purposes so docker can't relate. – icyNerd Nov 24 '19 at 09:18
  • a mysql docker with the data directory outside of the container, work like an installein server, because even after restart the datadirectory is still sthere and doesn't geht resettet. – nbk Nov 24 '19 at 09:32

3 Answers3

1

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

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.

Aman Nirala
  • 96
  • 8
0

I ran into the same problem.Here's how I resolved it.

  1. Win+R
  2. input"services.msc", then click "Enter"
  3. find the MySQL service, right click, choose the "attribute" option
  4. choose the "log in" option, then choose "Local System Account" END I hope that solves your problem.
is_your_Kylie_Guo
  • 1
-1

I don't know,if we have the same Mysql program design,i'am using the latest version 8.0.26.Try this: Open your sql editor->go to navigator part left of the screen ->Inside -Instance- select Startup/Shutdown .

Then click on -Start server -button.

If didn't work ,or the program was crashed, go to windows search tool and type -Services- then search about Mysql service ,then click -start- it should be closed....

Hope this work..

Ilymar120
  • 1
  • 1