Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to install and configure mysql 5.7.16 ZIP package. It is very detailed and has certain reference value. If you are interested, you must finish it.

Log on to the official website to download the free community version

1. Download the URL

2. Click download

3. After downloading, create a new folder named MySQL (I choose to extract it to D:\ Program Files\ MySQL)

4. The administrator opens cmd and changes to the bin directory; (or configure the MySQL environment variable) enter: mysqld-- initialize and enter. (initialize MySQL)

5. After the execution, we will see that there is an extra one in the D:\ Program Files\ MySQL directory

6. Continue typing: mysqld install in the cmd window and return to Service successfully installed. Indicates that the service was installed successfully.

7. Open the running window and enter: services.msc finds MySQL and sets startup.

8. Cmd window continue to enter: mysql-u root-p enter twice; return ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) user root denies access.

9, open the data directory, use notepad to open the .err file, search password will find the temporarily generated password, copy.

10. Enter mysql-u root-p in cmd (or press the up arrow), and right-click to paste the password you just copied.

11. Landing successfully.

12. When we enter the query statement, it appears: ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. You must reset your password.

13. Enter: ALTER USER 'root'@'localhost' IDENTIFIED BY' mima'; returns: Query OK, 0 rows affected password reset successfully, password: mima

Enter: exit, and then log in again. Enter sql statement: show databases; displays the database table, configuration is complete.

These are all the contents of the article "how to install and configure the mysql 5.7.16 ZIP package". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.