MySQL 8.0.25 decompression version installation and configuration method graphic tutorial

MySQL 8.0.25 decompression version installation tutorial, for your reference, the specific content is as follows

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-default.ini (some versions are called my.ini):

[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

3. Configure mysql environment variables:

C:\Program Files\mysql-8.0.25-winx64

4. Run cmd as an administrator and do the following:
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:

alter user 'root'@'localhost' identified with mysql_native_password by '123456';

For more tutorials about MySQL, please click on the topic: "MySQL different versions installation tutorial"

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.