MySQL 8.0.18 installation and configuration method graphic tutorial

This article records the installation and configuration graphic tutorial of MySQL 8.0.18 for your reference. The specific contents are as follows

Step 1: Download MySQL

Download address: MySQL

Step 2: Install MySQL

Open the downloaded file and unzip it to the specified directory.
(My unzip directory is G:\MySQL\mysql-8.0.18-winx64)

Open the unzipped MySql file and create my.ini (mysql configuration file) in the root directory

The contents of the my.ini file are as follows:

[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 to basedir=G:\MySQL\mysql-8.0.18-winx64 
# Set the storage directory of mysql database data datadir=G:\MySQL\mysql-8.0.18-winx64
# Maximum number of connections allowed max_connections=200 
# 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

Here you need to change the basedir and datadir paths to the mysql decompression path

Find the CMD command prompt, right click and run it as administrator

Enter the mysql subdirectory bin and enter

mysqld --install (Installation)
mysqld --initialize (Initialization)
net start mysql (run)

Step 3: Set the MySql login password

After mysql is installed, open the data folder in the mysql installation directory. There is a .err file in it. Open it with Notepad++ and you can see the line

A temporary password is generated for root@localhost: xxxxxxxx

localhost: The following is the default password, copy this password to log in

After a successful login, you must reset your password, otherwise the following error will be displayed.

You must reset your password using ALTER USER statement before executing this statement.

After starting mysql, enter the following command, NEW PASSWORD is the password you set for yourself

mysql> ALTER USER USER() IDENTIFIED BY 'NEW PASSWORD';

The installation is complete.

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.