MySQL 8.0.15 installation and configuration graphic tutorial

This article records the installation and configuration methods of MySQL 8.0.15 for your reference. The specific contents are as follows

Installation package download

Link: MySQL official website download address

Click the first Download. The difference between the first and second installation packages is that the first file is a zip file, which does not require installation steps, while the second one is an msi file for installation. The zip installation method is selected here.

The downloaded icons are as follows:

Unzip the installation file

Unzip to E:\MySQL\mysql-8.0.15-winx64

And add the bin directory under this file to the environment variables

Add my.ini file

The file content is written as:

[client]
port = 3308
default-character-set = UTF8MB4 
 
[mysqld]
port = 3308
character-set-server = UTF8MB4 
 
basedir=E:\MySQL\mysql-8.0.15-winx64
datadir=E:\MySQL\mysql-8.0.15-winx64\data
 
group_concat_max_len=20000
 
 
[WinMySQLAdmin]
E:\MySQL\mysql-8.0.15-winx64\bin\mysqld.exe

Open cmd as administrator

Execute the command in the bin directory of the MySQL installation directory:

mysqld --initialize --console

After the execution is complete, the initial default password of the root user will be printed. Remember the default password as it will be used later.
A temporary password is generated for root@localhost: ************
Execute the command:

mysqld --install MySQL

Start the service:

net start MySQL

change password

Execute the command in the bin directory of the MySQL installation directory:

mysql -u root -p

You will be prompted to enter a password, then enter the default initial password

Enter mysql>
Execute the command and change the password to 123456

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

Installation and deployment completed

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.