Shulou(Shulou.com)06/01 Report--

This article records the mysql 5.7.23 installation tutorial for your reference.

1, First enter the official website to download mysql installation package,

official website address

You can choose the version you want, the default is 8.0, I use 5.7 here.

There are two kinds of installation packages, one is the msi installation package, one is the zip compression package, I use here is zip, direct decompression can be.

2. After decompression, configure environment variables:

Creating private variables

Name: MYSQL_HOME Value: D:\mysql-5.7.23-winx64 (mysql decompression address)

Add %MYSQL_HOME%\bin after path

3. Create a my.ini file under the mysql folder and add the following content

[mysql]#Set mysql client default character set default-character-set=utf8 [mysqld]#Set port 3306 port = 3306#Set mysql installation directory basedir=D:\mysql-5.7.23-winx64#Set mysql database data storage directory datadir=D:\mysql-5.7.23-winx64\data#Maximum connections allowed max_connections=20#Character set used by server defaults to 8-bit encoded latin1 character set character-set-server=utf8#Default storage engine used when creating new tables default-storage-engine=INNODB

4. Now you can initialize the database. Open cmd window as administrator, switch to bin directory of mysql installation folder, and execute the following command.

mysqld --initialize --console

When the execution is complete, the temporary password for root appears.

The copy code is as follows:2018-09-06T15:10:05.464644Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: APWCY5ws&hjQ

That is APWCY5ws&hjQ, this will be used later in the login and password modification. If you do not modify the password, you cannot use this temporary password to log in to database software such as navicat.

5. Then you can install mysql service by executing the following command

mysqld install

6. If the service is successfully installed, you can start it. Execute the following command

net start mysql

7. After successful startup, you can log in

mysql -uroot -p

Then enter the temporary password recorded before logging in successfully

8. Change password

The previous password modification commands are no longer applicable. You can modify them by using the following commands

set password = password ('password ')

Example: set password = password ('123456 ')

In this way, the password is successfully modified, and mysql can be logged in through software such as Navicat.

Reference article:

1862(phpmyadmin)/1820(mysql) error in mySQL

MySQL installation tutorial

Excellent topic sharing:

mysql different versions installation tutorial

mysql5.7 installation tutorial

mysql5.6 installation tutorial

mysql8.0 installation tutorial

The above is all the content of this article, I hope to help everyone's study, but also hope that everyone a lot of support.

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.