Shulou(Shulou.com)06/01 Report--

Download the installation package (64-bit)

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

Click download

Drop down the page and find the link below

Click the link above and find the link below

Select the version as shown in the picture and click download.

Second, install the MySQL database

Extract the installation package. Here I will extract the installation package under the MySQL folder under disk D.

Configure environment variables

(1) right-click my computer-- > Properties-- > Advanced system Settings-- > Environment variables. (2) Select New as the system variable.

(3) enter the following figure (the variable value changes according to the decompression path of your own installation package).

(4) find Path in the system variable and select Edit.

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

3. Configure the initialization my.ini file

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

(2) the following configuration is written in the my.ini file.

[mysqld] # set the installation directory for port 3306 port=3306# custom settings mysql, that is, the directory to extract the mysql package basedir=D:\ MySQL\ mysql-8.0.19-winx64# Custom Settings mysql database data storage directory datadir=D:\ MySQL\ mysql-8.0.19-winx64\ data# maximum number of connections allowed max_connections=200# number of connections allowed to fail This is to prevent anyone from attempting to attack the database system max_connect_errors=10# server from this host. The character set used by the server defaults to UTF8character-set-server=utf8.

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

4.

(1) run the command prompt as an administrator

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

Mysqld-initialize-console

The second box is the default initial password, which needs to be remembered and 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 after the box above, which is the initial password recorded in step (2) above. Enter the following command to change to your own password:

Alter user 'root'@'localhost' identified by' jb51jb51'

The second arrow points to your own password. Just change the csdncsdn in the above command to your own password according to the actual situation.

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

(7) log out and end the MySQL service.

Summary

This is the end of this article on the tutorial illustration of Xiaobai installing and logging in mysql-8.0.19-winx64 (a must-see for beginners). For more information about mysql-8.0.19-winx64 installation and login, please search for previous articles or continue to browse the relevant articles below. I hope you will support it in the future!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.