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

This article is to share with you mysql 8.0.17 installation steps, I believe that most people do not know how to install, in order to let you learn, to give you a summary of the following, do not say much, let's read on.

1. Download (it is officially recommended to download the installation version, but the unzipped version is more convenient), download address:

2. To decompress, we need to add one more step:

(1) create a file named my.ini:

3. Modify the my.ini file:

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 330mm set mysql installation directory basedir = D:\\ Program Files\\ mysql\\ # set mysql database data storage directory datadir = D:\\ Program Files\\ mysql\\ data# the character set used by the max_connections=20# server defaults to 8-bit encoded latin1 Default storage engine default-storage-engine=INNODB# creation mode sql_mode = NO_ENGINE_SUBSTITUTION that the character set character-set-server=utf8# will use when creating a new table STRICT_TRANS_TABLES

Special attention should be paid to:

(1) D:\\ Program Files\\ mysql\\ data this directory must be "\", do not make it "\", or you will report an error, or you can use "/".

(2) Mysq installation directory and data storage directory must be modified for your own directory, unless you set the same directory as above.

4. Configure the environment variables of mysql:

MYSQL_HOMED:\ Program Files\ mysql

Click Path to add:

% MYSQL_HOME%\ bin

5. Run cmd as an administrator and do the following:

(1) change to the bin directory of mysql

(2) execute the mysqld-- initialize command, and a new directory data will be generated. If you look at the .err file, you can see the random password generated by the root user.

Mysqld-initialize

(3) execute the mysqld-- install command to install the mysqld service

Mysqld-install

(4) execute net start mysql command to start mysql service

Net start mysql

(5) execute the command mysql-u root-p, connect to the mysql database, and enter the password randomly generated above

Mysql-u root-p

(6) perform the following sql to reset the root password:

Mysql > alter user 'root'@'localhost' identified with mysql_native_password by' New password'

Tips:

Mysqld-initialize-insecure automatically generates root users without passwords

Mysqld-initialize automatically generates root users with random passwords

Mysqld-remove removes its own mysqld service

Net stop mysql command to stop the mysql service

If you report an error, empty the data folder, it is best to delete the data file and re-execute the remove--initialize--install--start (these are not commands) process

After reading the above, have you mastered the installation steps of mysql 8.0.17? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

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.