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

This article is mainly about how to install mysql-5.7.19-winx64 in win10 system. If you are interested, let's take a look at this article. I believe it is of some reference value to everyone after reading how to install mysql-5.7.19-winx64 in win10 system.

1. Download the mysql-5.7.19-winx64 package. If you don't have it, go to mysql website https://dev.mysql.com/downloads/mysql/.

Upload and download, here I choose 64bit or 32bit as shown below:

2. Extract it to the directory you specified. The E:\ mysql-5.7.19 I specify here. If there is no my.ini file by default, you need to create one manually.

3. Manually create the my.ini file and add the following information

[client] port=3306default-character-set=utf8 [mysqld] # set to your own MYSQL installation directory basedir=E:\ mysql-5.7.19# set to MYSQL data directory datadir=G:\ mysql_dataport=3306character_set_server=utf8sql_mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER # enable query cache explicit_defaults_for_timestamp=trueskip-grant-tables

4. Set environment variables

Computer-> Properties-> Advanced system Properties-> Environment variables

5. Load the configuration and install

The error report in the middle is because the file was generated in the data folder for the first time, so the error will be reported.

(be sure to run cmd as an administrator or you will get an error.)

6. Complete the installation after executing the following two commands

Mysqld install

Net start mysql

Check the error log after installation. Red is the default password.

2017-08-02T05:19:34.830669Z 0 [Warning] InnoDB: New logfiles created, LSN=45790

2017-08-02T05:19:35.827224Z 0 [Warning] InnoDB: Creatingforeign key constraint system tables.

2017-08-02T05:19:36.155385Z 0 [Warning] No existing UUIDhas been found, so we assume that this is the first time that this server hasbeen started. Generating a new UUID: 2cd21090-7742-11e7-953c-507b9de19f84.

2017-08-02T05:19:36.202484Z 0 [Warning] Gtid table is notready to be used. Table 'mysql.gtid_executed' cannot be opened.

2017-08-02T05:19:36.202484Z 1 [Note] A temporary passwordis generated for root@localhost: kQrFq?Fti2,m

7. Use the following command to change the default password mysqladmin-u root-p password

You can also enter mysql to change the password.

Set password for root@localhost = password ('123456')

8. Log in to mysql to check whether the installation is successful.

Does the above details about how to install mysql-5.7.19-winx64 in win10 system help you? If you want to know more about it, you can continue to follow our industry information section.

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.