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
  • 93,638
  • 21
  • 103
  • 149
eqrakhattak
  • 535
  • 2
  • 7
  • 21
  • 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? – eqrakhattak 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 – eqrakhattak 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. – eqrakhattak 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. – eqrakhattak 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

4 Answers4

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 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
  • 11
  • 1
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
0

Go to "C:\ProgramData\MySQL". You'll find a list of archived my.ini files. Use one to replace the current my.ini file located inside "C:\ProgramData\MySQL\MySQL Server xx.0"

gmd
  • 1
  • 1
  • Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Sep 24 '22 at 09:03