How to download, install and configure MySQL 5.7.27

This article will introduce to you how to download, install and configure MySQL 5.7.27. It has certain reference value. Friends in need can refer to it. I hope it will be helpful to everyone.

MySQL 5.7.27 Detailed download, installation and configuration tutorial

Preface

You will encounter many problems when installing MySQL, on the blog There are many ways to solve the problem. Here I attach some links. Friends who encounter problems can read and refer to it. This article is mainly for beginners who are new to databases to install the MySQL database. Currently, the MySQL versions on the official website are 5.5, 5.6, 5.7 and 8. During development, we usually choose a version 1 to 2 lower than the latest version, so I chose 5.7 as the database to be installed

1. Download steps

Visit the official website: https://www.mysql.com/

Select Community

under Downloads Download the corresponding version

Click on MySQL Community Server in the picture above to enter the download interface:

Find the link MySQL Community Server 5.7 and click to enter:

Choose to download the corresponding ZIP file according to the version of your computer. My computer is 64-bit, so select this to download. Click Download to enter the following interface:

Click No thanks, just start my download, and then start downloading

After downloading, extract the file to your The disk and directory you want to save to. I unzipped the file to the E:\Program Files\Mysql directory.

The above completes all the downloading work.

2. Configure environment variables

System—>Advanced system settings—>Environment variables—>System variables

Click New, the variable name is: MYSQL_HOME, and add the location of your mysql-5.7.27-winx64 folder.

Mine is in E:\Program Files\Mysql\mysql-5.7.27-winx64, as shown in the picture:

Edit Path and copy;% MYSQL_HOME%\bin to the end of the original value, as shown in the figure:

3. Configure the my.ini file

in your mysql-5.7.27 -Create a new my.ini file in the winx64 directory. Mine is in the E:\Program Files\Mysql\mysql-5.7.27-winx64 directory. The content of the my.ini file is:

[mysqld]
#端口号
port = 3306
#mysql-5.7.27-winx64的路径
basedir=E:\Program Files\Mysql\mysql-5.7.27-winx64
#mysql-5.7.27-winx64的路径+\data
datadir=E:\Program Files\Mysql\mysql-5.7.27-winx64\data 
#最大连接数
max_connections=200
#编码
character-set-server=utf8

default-storage-engine=INNODB

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysql]
#编码
default-character-set=utf8

After the creation is completed, go to the next step.

4. Install MySQL

1. Enter cmd in the input box and run it as an administrator. Note that you must run it as an administrator here, otherwise during the installation process Install/Remove of the Service Denied! will appear due to insufficient administrative rights. This is very important!

Enter the E:\Program Files\Mysql\mysql-5.7.27-winx64\bin directory in cmd:

Enter the installation command: mysqld -install. If Service successfully installed appears, the installation is successful; if Install of the Service Denied appears, it means that cmd is not run with administrator rights:

Then continue to enter the command: mysqld --initialize, there will be no prompts at this time:

Then enter the startup command: net start mysql. The following prompt appears to prove that MySQL is started successfully:

5. Set the MySQL password

1. Here Setting the password is mainly to solve the problem of: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

2. First stop the MySQL service and enter the command line net stop mysql:

3. Find my.ini in the E:\Program Files\Mysql\mysql-5.7.27-winx64 directory, and enter any line under the [mysqld] field Add skip-grant-tables and save:

4. Restart MySQL and enter the startup command: net start mysql. The following prompt appears to prove that MySQL is started successfully:

Enter the command mysql -u root -p. No password is required, just press Enter:

Enter MySQL successfully! Haha, you should be happy now that you have reached this step!

5. Enter the command line use mysql and enter the database:

6. Enter the command line update user set authentication_string=password("xxxxxx") where user ="root";xxxxxx is the new password you set. If the following message appears after hitting Enter, it proves that the modification is successful!

#7. Manually stop the MySQL service, enter service in the win10 search bar, and find MySQL. Just right-click and click Stop.

Then delete the skip-grant-tables line in the my.ini file just now, save and close.

8. Start cmd again (as administrator), enter the startup command: net start mysql, then enter mysql -u root -p, and then enter the password you just set. The following information appears to prove that the setting is successful!

Then enter the command line use mysql to verify. The result is an error:

Since the password has not been reset, then Reset it

Type the command line alter user user() identified by "xxxxxx"; My password is 123456, so I type alter user user() identified by "123456"; Enter! Getting closer to victory!
Enter the command line use mysql again to verify, success!

Related recommendations: "mysql tutorial"

The above is the detailed content of How to download, install and configure MySQL 5.7.27. For more information, please follow other related articles on the PHP Chinese website!