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

1. Download and decompress the official website.

Https://dev.mysql.com/downloads/mysql/

After downloading it, there is a zip zip file: mysql-5.7.26-winx64.zip, and then extract the file

After unzipping, I put the extracted files under D:\ mysql-5.7.26-winx64

2. Set environment variables

Configure MYSQL_HOME as the decompression path of MySQL: d:\ mysql-5.7.26-winx64, and set% MYSQL_HOME%\ bin in path. For win7 system, you need to enter:;% MYSQL_HOME%\ bin as shown below:

3. Under the MySQL decompression path, create a new my.ini configuration initialization parameter, and copy the following to the my.ini file:

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 3306 # set mysql installation directory basedir=D:\ mysql-8.0.17-winx64# set mysql database data storage directory datadir=D:\ mysql-8.0.17-winx64\ data# allow maximum number of connections the character set used by the max_connections=200# server defaults to 8-bit encoded latin1 characters Set default-storage-engine=INNODB, the default storage engine that character-set-server=utf8# will use when creating new tables

4. Initialize the database

Open the cmd command window as an administrator, and enter the mysqld-- initialize command to initialize the data data directory of mysql. After initialization, a data folder will be generated under the decompressed directory, under which there will be a file ending with .err, and a randomly generated password will be generated when opened. As shown in the following figure:

5. Install the service

Execute the following command under cmd

# Registration Service

Mysqld-install

# to delete mysql, execute the command mysqld-- remove mysql, as shown below:

# start the service net start mysql, as shown below:

# stop serving net stop mysql, as shown below:

Log in to the mysql data and use the command: mysql-u root-p. The initial password is the password corresponding to the screenshot above: o/wU! > G8lgzr, as shown below:

6. Change the password

ALTER USER USER () IDENTIFIED BY 'enter new password'

Summary

The above is the diagram of the installation method of mysql-8.0.17-winx64 under windows 10 introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave a message for me, and the editor will reply to you in time. Thank you very much for your support to the website!

If you think this article is helpful to you, you are welcome to reprint it, please indicate the source, thank you!

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.