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

This article mainly shows you the "MySQL5.7.20 unzipped version of the installation and modification of the root password case analysis", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn the "MySQL5.7.20 unzipped version of the installation and modification of root password case analysis" this article.

1. Download MySQL Archive (decompressed version)

Web site: https://downloads.mysql.com/archives/community/

two。 Extract the files to the custom installation directory:

No "data" folder and "my.ini" configuration file after decompression

3. Configure environment variables after decompression

System variable: new "MYSQL_HOME" value: xxx\ mysql-5.7.20-winx64 (root path of the custom installation directory)

Append Path:;%MYSQL_HOME%\ bin

4. Create a "my.ini" configuration file under the root of the custom installation path

Configuration Information:

[client] port = 3306 [mysqld] port = 3306 basedirdom% MYSQLBERT Hom% datadiringing% MYSQLBERT Hom%\ datamax_connections=200character-set-server=utf8default-storage-engine=INNODBsql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES# skip the password skip-grant-tables

5. Initialize and install MySQL:

Under the cmd terminal (administrator permission is recommended to run)

> mysqld-- initialize > mysqld-install / / you can view the MySQL service in services.msc > net start/stop mysql / / enable and disable mysql

6. Set the root user password

> mysql-u root-penter password: enter mysql > update mysql.user set authentication_string=password ('123') where user='root' and host='localhost';mysql > flush privileges

Exit mysql

Comment out skip-grant-tables to my.ini

Prompt after logging in to MySQL:

Mysql error You must reset your password using ALTER USER statement before executing this statement.mysql > SET PASSWORD=PASSWORD ('123'); mysql > ALTER USER' root'@'localhost' PASSWORD EXPIRE NEVER;mysql > flush privileges

Just log in again.

The above is all the contents of this article entitled "example Analysis of installing and modifying root passwords in MySQL5.7.20 decompressed version". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more 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.