MySQL join service, set password, change password

FIX: When you join the MySQL service, you can not bring the version. It says all the following MySQL57 can be written directly mysql! I hope you will pay attention.

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

1. To join the MySQL service:

Enter command cmd

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

input Command D: go to the MySQL bin folder

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

Assuming that the MySQL service exists, you can start the service directly

Assuming that there is no MySQL service, you can join the MySQL service by, for example, the following command:

Boot your own active MySQL Service installation command:

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 change password

After the MySQL Service command is turned on:

It is assumed that MySQLpassword has not been set before. Then the MySQL default password is empty!

Input:mysqladmin–uroot–p password will let you enter the password. Just enter!

Now let's enter a new password, then you will be able to set up a password you want to set, and then let you repeatedly enter a new password.

Password has been set up successfully!

Assume that the password was originally set. If you need to change password, enter:

Now the password has become empty!

4. go to MySQL database:

Input command:mysql–u–root–p

No password, direct carriage return, there is password input password!

Exit Database: Enter command:quit;

Word Document Download

Passing the great God more generous enlighten!

MySQL join service, set password, change password