Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about how to install mysql 8.0.19 in the Windows10 system, many people may not know much about it. In order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

Step 1: download the installation package:

Step 2: configure my.ini:

Create a new text file in the root directory, copy the following, and change the suffix to .ini

[mysqld] # set port 3306 port=3306# set mysql installation directory basedir=C:\ Program Files\ mysql-8.0.18-winx64# set the data storage directory of mysql database datadir=C:\ Program Files\ mysql-8.0.18-winx64\ data# allow the maximum number of connections max_connections=200# allows the number of connections to fail. This is to prevent anyone from attempting to attack the character set used by the max_connect_errors=10# server of the database system from this host. By default, the default storage engine default-storage-engine=INNODB# that UTF8character-set-server=utf8# will use when creating a new table uses the "mysql_native_password" plug-in authentication default_authentication_plugin=mysql_native_ password [MySQL] # to set the mysql client default character set default-character-set=utf8 [client] # setting. Set the port port=3306default-character-set=utf8 used by default when the mysql client connects to the server

Step 3: configure environment variables:

1. Create a new system variable: (the value of the variable is the path and modify it according to your own situation)

two。 Then add the last line of the following figure to the path of the system variable (notice the semicolon at the end)

The third step initializes and starts:

1. As an administrator (you must open it as an administrator), open cmd,cd to the bin directory of the mysql folder

Initialization, will print the database password, remember the password, which will be used later

Mysqld-initialize-console

Jo)? / kia (K4 > B is the password, it is recommended to copy and save it. There is an error here does not hinder the installation, do not worry about it for the time being (in the end, I found that the reason is the problem with the my.ini file, what I gave above is no problem)

If there is a pop-up prompt: "MySQL: code execution cannot continue because VCRUNTIME140_1.dll cannot be found. Reinstalling the program may resolve this problem."

Solution: download "Microsoft common runtime collection", download directly decompress, you can solve (Baidu search and download).

two。 Install the MySQL service: mysqld-- install

3. The command to start the server is net start mysql, and the command to stop the service is net stop mysql. Uninstall MySQL service command: sc delete MySQL/mysqld-remove

4. Log in to the database and you will be asked to enter your password

Mysql-u root-p

After entering the password, you will enter the MySQL command mode normally.

Change the password after entering:

For example, change the password to: 123456

Set password for root@localhost='123456'

5. Show database

Show databases

After reading the above, do you have any further understanding of how to install mysql 8.0.19 in the Windows10 system? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

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.