MySQL Command Line Crashes

[April McBroom]

Hello Users,

I have encountered this problem today upon attempting to run the MySQL cmd line. There is a question here that also mentions the command line crashing that was never answered. The software is the latest version 8.0.0.1/2 and there has also been seperate issues with the Client_Authentication protocol that was REMOVED from this version!

This has caused issues with communication between the Client and the Mysql database and forced Root password reset was needed, along with installing the MYSQL PATH variable that is NOT included in the default configuration set up of the file.

The solution for the run-time crashing is as followed:

Go to Search, and type in run.

Then in the run field, type in services.msc in the run-time field. Then, locate the MYSQL version installed on your machine. It will be named "MySQL".

After locating you may already see it as automatic. Right-click and go to properties. Make sure to stop the service first. Select "Delay after start" and hit apply.

Switch to the MySQL command line and type in the associated password with your MySQL.

Once loaded, you should see that you are inside of the MYSQL User Interface.

Reboot the machine and re-run the mysql command line to make sure it is running.

To check that it is running in the background, go to CTRL+ALT+Delete and check with Task Manager. Look for the MYSQL running services in the background.

If you don't see the MySQL running services in the Task Manager, switch back to the services command used earlier in this tutorial.

Then, re-select the MySQL and properties. Change from delay to "automatic". Run MySQL and reboot machine afterwards.