Basic installation process of mysql5.7.19 in winx64 (detailed), winx64mysql5.7.19

Basic installation process of mysql5.7.19 in winx64 (detailed), winx64mysql5.7.19

1. Download

Https://dev.mysql.com/downloads/mysql/

Http://www.bkjia.com/softs/451120.html

2. Install the service

1) The Administrator runs cmd

2) D:

3) cd D: \ mysql-5.7.19-winx64 \ bin

4) then run the registration service command

Switch the directory to the bin directory where the mysql package is located. Enter mysqld.exe-install

After the command is executed, the system prompts "Service successfully installed." indicates that the installation is successful.

Start Service: net start service name

Stop Service: net stop service name

Delete service: SC delete service name

3. Configure Environment Variables

New system environment variables:

Key: MYSQL_HOME

Value: D: \ mysql-5.7.19-winx64

Add % MYSQL_HOME % \ bin in Path.

4. Create my. ini

[client]port=3306default-character-set=utf8[mysqld]port=3306character_set_server=utf8basedir=%MYSQL_HOME%datadir=%MYSQL_HOME%\data[WinMySQLAdmin]%MYSQL_HOME%\bin\mysqld.exe

After creating the my. ini file, copy and paste it to D: \ mysql-5.7.19-winx64 \ bin, and put it under the bin directory where mysql is located.

Initialize mysql Data and create a root user with an empty password. Open cmd and execute the following command:

mysqld --initialize-insecure --user=mysql

5. In cmd, also known as a command prompt, enter the following command to start the mysql service.

net start mysql

After the command is executed, the following message is displayed:

MySQL service is starting ..

The MySQL service has been started successfully.

Note: to log on to mysql, the service must be started first. The same will happen in the future

6. After the service is started, because the newly created root user has a blank password, you must first set the password. Run the following command:

Mysqladmin-u root-p password enter the new password here

Enter password: Enter the old password.

Summary

The above section describes the basic installation process of mysql5.7.19 in winx64. I hope it will help you. If you have any questions, please leave a message and I will reply to you in time. Thank you very much for your support for the help House website!