MySQL-8.0.26 Configuration Graphics Tutorial

Preface: Recently, the company project changed the database version. Here I would like to record and share the process of installing and configuring MySQL version 8.0.
1. First, go to the MySQL official website and select the required version to download (download address: https://dev.mysql.com/downloads/mysql/)
PS: MySQL 8.0 does not need to be installed using an installer like MySQL 5.7. You only need to download the compressed package from the official website, unzip it, and configure it before using it.
After decompression, the picture is as follows:

2. Configure the value of the system variable PATH in the environment variable and put the bin folder path of your installation directory on it.

3. Create a new MySQL configuration file.
There is no my.ini file in the new version, so we need to create it manually.

What needs to be noted here is that the MySQL installation directory and the data storage directory should be modified according to personal circumstances.

[mysqld]port=3306basedir=D:\JAVA Tools\mysql-8.0.26-winx64datadir=D:\JAVA Tools\mysql-8.0.26-winx64\Datamax_connections=200max_connect_errors=10character-set-server=utf8mb4default-storage-engine=INNODBdefault_authentication_plugin=mysql_native_password[mysql]default-character-set=utf8mb4[client]port=3306default-character-set=utf8mb4

4. Initialize MySQL.
Run cmd as an administrator (remember: run as an administrator), enter the MySQL bin path, and enter the command: mysqld --initialize --console

After execution, find the sentence A temporary password is generated for root@localhost:. The initial password is after localhost.

5. Start the service.
Enter the command: net start mysql to start the MySQL service.
Enter the command: mysql -u root -p to log in. (The password is your initialization password at this time)
Enter the command: ALTER USER root@localhost IDENTIFIED BY 'password'; now set the password to your own password.

6. Verify whether it is successful.
Log in using the modified password and enter the password: show databases; to view the database.

The following figure appears, indicating successful installation.

This is the end of this article about the MySQL-8.0.26 configuration tutorial. For more relevant MySQL-8.0.26 configuration content, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future!