MySQL add service, set password, change password

After MySQL is installed, you often need to do some more setup!

1. To add a MySQL service:

Enter command cmd

Enter the command CD D:\software\MySQL\mysqllocation\MySQLServer 5.7\bin (this directory is the MySQL installation directory)

input Command D: go to MySQL 's bin directory

Enter the command net start mysql57 to see if there is a MySQL service (mysql57 is the version of my database )

If there is a MySQL service, you can start the service directly

If the MySQL service does not exist, you can add the MySQL service by using the following command:

Start the MySQL Service installation command automatically running:

Mysqld.exe–install MySQL57

Boot not self-booting installation command:

Mysqld.exe–install-manual

2. To Open and delete a service command:

Open command:net start MySQL57

Delete command:net stop MySQL57

3. set or modify a password

After the MySQL Service command is turned on:

If the MySQL password has not been set before, then the default mysql password is empty!

Input:mysqladmin–uroot–p password will let you enter the password, directly enter!

Now let's enter a new password, then you can set a password you want to set, and then let you re-enter the new password again.

The password has been set successfully!

If you have previously set a password and need to change the password, enter:

Now the password has become empty!

4. go to MySQL database:

Input command:mysql–u–root–p

No password, the direct return, a password to enter the password!

Exit Database: Enter command:quit;

Word Document Download