MySQL 8.0.17 decompression version installation and configuration method graphic tutorial

I'll record the problems I encountered during the installation process, and I hope it will be useful to everyone.

1. Download (the official recommendation is to download and install the version, but the decompressed version is more convenient), download address:

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

(1) Create a file named my.ini. Addendum: I created a data folder before, but the subsequent installation resulted in an error. Take this as a warning.

3. Modify the my.ini file:

[mysql]

# Set the default character set of the mysql client to default-character-set=utf8
[mysqld]
# Set port 3306 port = 3306
# Set the installation directory of mysql basedir = D:\\Program Files\\mysql\\
# Set the storage directory of mysql database data datadir = D:\\Program Files\\mysql\\data
# Maximum number of connections allowed max_connections=20
# The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB
# Create mode sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

Pay special attention to:

(1) The directory D:\\Program Files\\mysql\\data must be “\\”. Do not use “\” or an error will be reported. Alternatively, you can use “/”.
(2) The MySQL installation directory and data storage directory must be changed to the directory you set, unless the directory you set is the same as above.

4. Configure mysql environment variables:

Click Path and add:

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

(1) Switch to the bin directory of mysql;
(2) Execute the mysqld --initialize command. A new directory data will be generated. Check the .err file to see the random password generated by the root user.

(3) Execute the mysqld --install command to install the mysqld service;

(4) Execute the net start mysql command to start the MySQL service;

(5) Execute the mysql -u root -p command to connect to the MySQL database and enter the randomly generated password above;

(6) Execute 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 a root user without a password;
• mysqld –initialize automatically generates a root user with a random password;
• mysqld -remove removes its own mysqld service;
• net stop mysql command to stop the mysql service
• If an error occurs, clear the data folder. It is better to delete the data file and re-execute the remove--initialize--install--start (these are not commands) process;

Wonderful topic sharing:

MySQL different versions installation tutorial

MySQL 5.7 installation tutorials for various versions

MySQL 5.6 installation tutorials for various versions

mysql8.0 installation tutorials for various versions

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.