Detailed tutorial for downloading, installing and configuring MySQL 5.7.27

Preface

You will encounter many problems when installing MySQL. There are many solutions to the problems on the blog. Here I attach some links. Friends who encounter problems can read them for reference. This article is mainly aimed at newbies who are new to the database to install the MySQL database. Currently, the official website has MySQL versions 5.5, 5.6, 5.7 and 8. When developing, we usually choose 1 to 2 versions lower than the latest version, so I chose 5.7 as the database to be installed.

1. Download steps

1. Visit the official website: https://www.mysql.com/
Select Community under Downloads

2. Download the corresponding version

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

Find the link for MySQL Community Server 5.7 and click on it:

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

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

After downloading, unzip the file to the disk and directory you want to save it to. I unzipped the file to the E:\Program Files\MySQL directory.

The above completes all the downloading work.

2. Configure environment variables

1. System -> Advanced System Settings -> Environment Variables -> System Variables

Click New , name the variable: MYSQL_HOME , 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 figure:

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

3.

3. Configure the my.ini file

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

[mysqld]
#Port number port = 3306
#mysql-5.7.27-winx64 path basedir=E:\Program Files\Mysql\mysql-5.7.27-winx64
#mysql-5.7.27-winx64 path + \data
datadir=E:\Program Files\Mysql\mysql-5.7.27-winx64\data 
#Maximum number of connections max_connections=200
#Encoding character-set-server=utf8

default-storage-engine=INNODB

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysql]
#Encoding default-character-set=utf8 

After the creation is complete, proceed 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 . Otherwise, during the installation process, the error "Install/Remove of the Service Denied!" will appear due to insufficient administrative privileges. This is very important!

1. 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 the cmd is not run with administrator privileges:

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

Enter the startup command again: net start mysql , and the following prompt will appear to prove that MySQL has started successfully:

5. Set MySQL password

1. Setting a password here 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, enter the command line net stop mysql :

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

4. Restart MySQL and enter the startup command: net start mysql . The following prompt appears, indicating that MySQL has been successfully started:

Enter the command mysql -u root -p without entering a password, just press Enter:

Entering MySQL successfully! Haha, it’s worth being happy after reaching this step!

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

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

7. Manually stop the MySQL service, enter service in the win10 search bar and find MySQL . 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 will appear to prove that the setting is successful!

Then enter the command line use mysql to verify it, and the result is an error:

Since the password has not been reset, just reset it by typing 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 and closer to victory!
Enter the command line use mysql again to verify, success!

Summarize

Including the time I spent writing the blog, it took me about 4 hours to install this database. The reason is that I encountered many problems during the installation. I will summarize them here and attach the solution links:
1. The my.ini file cannot be found
2.ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)
3.ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: YES)
4.Unknown column 'password' in 'field list'
5.You must reset your password using ALTER USER statement before executing this statement
There were many errors in the installation and configuration. I uninstalled it every time I made a mistake. I wanted to give up at one point. Thanks to my persistence, I finally conquered the installation and configuration of MySQL. I am about to start the journey of learning MySQL. I believe this is not an easy road, but I also believe that I can stick to it!

This is the end of this article about the detailed download, installation and configuration tutorial of MySQL 5.7.27. For more relevant MySQL 5.7.27 download, installation and configuration content, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future!