mysql8.0 forgotten password modification and net command service name invalid problem

Enter net start mysql in cmd and the prompt is: The service name is invalid

Please go to the bin directory of MySQL and open a command line window in the bin directory, or set the system environment variables and enter mysqld --install in the command line window. Press Enter and the message " Service successfully installed will be displayed.

It indicates that the MySQL service has been installed successfully. Enter net start mysql in the command line window and it can start normally.

mysql8.0 forgotten password modification:

The following code is feasible

You were asked to set a password when installing MySQL earlier, but that password doesn’t seem to be used. What you should enter here is the random initial password it automatically generates, and this initial random password is placed in a .err file in the MySQL installation directory. There seems to be only one .err file in the entire folder. Just search it in the folder.

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

Summarize

The above is what I introduced to you about mysql8.0 forgotten password modification and invalid net command service name. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please reprint it and please indicate the source. Thank you.