MySql 5.7.17 detailed installation and configuration tutorial for winx64,

MySql 5.7.17 detailed installation and configuration tutorial for winx64,

1. Download Software

1. Go to the MySQL official website, log on to your Oracle account (no account of your own registered a), download Mysql-5.7.17,: http://dev.mysql.com/downloads/mysql/

2. decompress the downloaded file to the specified directory, decompress it in E: \ mysql-5.7.17-winx64

Ii. Installation Process

1. First configure the environment variable path, configure E: \ mysql-5.7.17-winx64 \ bin to your own path

Environment Variable

MySql_HOME===================E:\mysql-5.7.17-winx64Path =========================%MySql_HOME%\bin;

2. Copy the my-default.ini in the extract path and change the name to my. ini, as shown in

3. open the file my. ini and add the following content:

######################################## ################ [Client] default-character-set = utf8 [mysqld] # decompress the directory basedir = % MySql_HOME % # decompress directory datadir = % MySql_HOME % \ data port = 3306 default-character-set = utf8 ###################### ###################################

4. Then put the my. ini file in the bin directory (I put it in the root directory at first, and it will not be initialized until the data folder is initialized later)

Iii. initialize database and configure related information

1. Run the windows command line as an administrator. (Note: For windows and later versions, the Administrator must be used. Otherwise, subsequent operations may fail)

2. Enter the mysql extract Directory D: \ mysql-5.7.15-winx64 \ bin (Note: here you need to enter the bin directory, otherwise the subsequent operation will have an error)

3. register the Mysql service. Run the command: mysqld -- install MySQL

If the message "Service successfully installed." is displayed, the mysql Service is successfully installed.

4. initialize the data directory

Enter the following command:mysqld --initialize-insecure (Generate a root user without a password)

At this time, a data folder is generated under the mysql folder, which contains some folders and files, which indicates that the initialization is successful.

5. Start mysql server after initialization.

Enter the command: net start mysql

If the MYSQL service is successfully started, it indicates OK.

6. Set the password

Mysqladmin-u root password

7. Start using mysql

Run mysql-u root-p.

Enter the password you just set.

4. Remove

1. if you want to remove a mysql instance that has been installed and is in use, go to the bin directory under the mysql decompression directory in cmd and enter net stop mysql in the command line to close the MySQL service, then run mysqld -- remove

The above is the installation and configuration tutorial for MySql 5.7.17 winx64. I hope it will help you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!