MySQL Skip authorization Form enter service

1.mysql services are provided through the MYSQLD process

We can simply double-click Mysqld.exe or enter mysqld in cmd mode. Both operations create mysqld processes in the background

After we have created the mysqld.exe process, we can log in to MySQL.

2. In cmd mode, we can also enter: Mysqld--install mysql5.7.14. The role of this approach is to start the MYSQLD service and register the service with the system service list, named mysql5.7.14. Then, when we start the MySQL service, we don't need to find the Mysqld.exe file by path. The MySQL service will determine if it needs to be started as the system starts.

Startup types are: Automatic, manual, disabled.

3. We have multiple

Mysqld--install A

Mysqld--intall b

Mysqld--install C

This simply registers the MySQL service with multiple names, and what really works is the mysqld.exe process. This process is unique, meaning that when a service is started, the Mysqld.exe process is created, and then the B,c service cannot be started.

4. Skip the authorization form to log in to MySQL

Before starting the MySQL service with the above command, ensure that the MySQL service is turned off and that there is no Mysqld.exe process in Task Manager

After entering the above command, do not close the window, keep the MySQL service running, close the end of the service.

Re-open the new window, in the window by the path to find the location of Mysql.exe, enter the MySQL command to successfully log in

Because MySQL's list of authorizations does not load into memory, MySQL login does not require a username and password.

Use the UPDATE statement to modify the authentication_string value of the Mysql.user table after logging in

Remember that flush privileges lets the memory reload the authorization table so that the root user's password is reset.

5. Modify the root password in addition to the above--skip-grant-tables, you can also directly modify the MySQL configuration file

It is possible to remove the semicolon from the front of the skip-grant-table, but this is a permanent method. Once the configuration table is modified, then each login will not need the user and password, so after the change, it is better to change back

In 6.mac

Mysqld_safe--skip-grant-tables Skip Authorization form start MySQL service

MySQL Skip authorization Form enter service