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

This article mainly shows you how to install Win10 compressed MySQL8 package version, the content is easy to understand, I hope you can learn, after learning there will be a harvest, the following let the editor to take a look at it.

1 download MySQL8 installation on the official website

This download is a compressed package, which can be unzipped to the specified directory after download.

2 configure environment variables

Add D:\ Development\ MySQL\ mysql-8.0.19-winx64\ bin to the environment variable Path. Of course, you can write a MYSQL_HOME first, and then add a% MYSQL_HOME%\ bin to the Path.

3 create a profile

Create a file my.ini in the installation directory, and then create a folder data.

Add configuration in my.ini

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 330 setting mysql installation directory basedir=D:\ Development\ MySQL\ mysql-8.0.19-winx64# set mysql database data storage directory datadir=D:\ Development\ MySQL\ mysql-8.0.19-winx64\ data# 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=20# server of the database system from this host. The default storage engine default-storage-engine=INNODB will be used when creating a new table with the default 8-bit latin1 character set character-set-server=utf8#.

Note that the basedir and datadir are written according to their own MySQL installation path.

4 initialization

Win10 searches for cmd, then right-click and select run as administrator.

Use the command mysqld-- initialize-- console, which initializes the mysql and generates a default password. Be sure to write it down and use it later.

2020-04-15T06:46:00.848471Z 0 [System] [MY-013169] [Server] D:\ Development\ MySQL\ mysql-8.0.19-winx64\ bin\ mysqld.exe (mysqld 8.0.19) initializing of server in progress as process 10988

2020-04-15T06:46:00.849603Z 0 [Warning] [MY-013242] [Server]-- character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.

2020-04-15T06:46:14.755339Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: Bqk0%=Jda2kJ

You can see Bqk0%=Jda2kJ, which generates a temporary password.

4.1 error unable to continue code execution due to vcrruntime140-1.dll not found

If an error occurs when running the command because the vcrruntime140-1.dll cannot be found, the reason is that the file vcrruntime140-1.dll is missing in the C:\ WINDOWS\ system32 directory, just download one online and put it in the C:\ WINDOWS\ system32 directory.

Vcrruntime140-1.dll download address

5 install mysql

Run the command mysqld-- install mysql8

Mysql8 is the service name I chose for msyql, which can be named according to my own needs.

When the command executes successfully, it prompts Service successfully installed. Exe.

6 start

Run the command net start mysql8, where mysql8 is the name given to the msyql service in step 5.

If you start successfully, you will be prompted:

The mysql8 service is starting..

The mysql8 service has started successfully.

7 enter mysql

Now connect to the database through Navicat (you can also log in on the command line, which can be done by Baidu) and log in using the temporary password obtained in step 4. Then change the password to root, the temporary password is too difficult to remember. I manually typed in the initial password through cmd and made a mistake many times. If you want to use the command line, mysql-u root-p, then enter and enter the password.

The above is about how Win10 installs the compressed version of MySQL8. If you have learned knowledge or skills, you can share it for more people to see.

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.