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

Editor to share with you how to install the mysql8.0.17 decompressed version, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

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

The above is all the contents of the article "how to install the extracted version of mysql8.0.17". 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.