Shulou(Shulou.com)06/01 Report--

Enter net start mysql prompt in cmd: invalid service name

Enter the bin directory of MySQL and open a command line window in the bin directory, or set the system environment variable, enter: mysqld-- install in the command line window, enter, and prompt: Service successfully installed.

Indicates that the MySQL service is installed successfully. Enter net start mysql in the command line window to start normally.

Mysql8.0 forgot to change the password:

It is feasible to test the following code for yourself

Obviously, when you installed MySQL, you were asked to set a password, but in fact, that password does not seem to be needed. What you should enter in this place is the random initial password that it automatically generated, and this initial password is placed in a .err file under the MySQL installation directory with the secret code. There seems to be only one .err type file in the whole folder. Just search in the folder.

ALTER USER "root" @ "localhost" IDENTIFIED BY "your new password"

Summary

The above is the editor introduced to you the mysql8.0 forgot password modification and net command service name is invalid, I hope to help you, if you have any questions, please leave me a message, the editor will reply to you in time. Thank you very much for your support to the website!

If you think this article is helpful to you, you are welcome to reprint it. Please indicate the source, thank you.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.