A tutorial for beginners to install and log in to mysql-8.0.19-winx64 (must-read for beginners)

1. Download the installation package (64-bit)

MySQL official website download link: https://www.mysql.com/cn/

Click to download

Scroll down and find the link below

Click on the above link and find the link below

Select the version shown in the picture and click Download.

2. Install MySQL database

Unzip the installation package. Here I unzip the installation package to the MySQL folder on drive D.

Configuring environment variables

(1) Right-click My Computer -> Properties -> Advanced System Settings -> Environment Variables. (2) Select New in System Variables.

(3) Enter the content in the figure below (the variable value changes according to the decompression path of your installation package).

(4) Find Path in the system variables and select Edit.

(5) Click New and enter %MYSQL_HOME%\bin.

3. Configure and initialize the my.ini file

(1) Create a new text document in the folder after unzipping the installation package and rename it to my.ini.

(2) Write the following configuration into the my.ini file.

[mysqld]
# Set port 3306 port=3306

# Customize the installation directory of MySQL, that is, the directory where you unzip the MySQL compressed package basedir=D:\MySQL\mysql-8.0.19-winx64

# Customize the data storage directory of the MySQL database datadir=D:\MySQL\mysql-8.0.19-winx64\data

# Maximum number of connections allowed max_connections=200

# The number of connection failures allowed is to prevent someone from trying to attack the database system from this host max_connect_errors=10

# The default character set used by the server is UTF8
character-set-server=utf8

(The basedir and datadir paths are written according to their actual paths.)

4.

(1) Run the command prompt as an administrator

(2) Execute the following command in the bin directory of the MySQL installation directory:

mysqld --initialize --console 

The second box contains the default initial password, which you need to remember as it will be used later.

(3) Enter the following command:

mysqld --install

(4) Enter the following command to start MySQL.

net start mysql

(5) Change the initial password. Enter the following command:

mysql -uroot -p

Enter the password in the box above. The password is the initial password noted in step (2) above. Enter the following command to change the password to your own:

alter user 'root'@'localhost' identified by 'jb51jb51';

The second arrow points to your password. You can modify csdncsdn in the above command to your own password according to your actual situation.

(6) Enter exit to exit MySQL and re-enter your password to verify whether the login is successful.

(7) Log out and terminate the MySQL service.

Summarize

This is the end of this article about the illustrated tutorial for beginners to install and log in to mysql-8.0.19-winx64 (a must-read for novices). For more relevant mysql-8.0.19-winx64 installation and login content, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope everyone will support 123WORDPRESS.COM in the future!