Mysql 5.7.17 installation and configuration method graphic tutorial (windows), mysql5.7.17

Mysql 5.7.17 installation and configuration method graphic tutorial (windows), mysql5.7.17

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
Path =====================================% 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]
Basedir = E:/mysql-5.7.17
Datadir = E:/mysql-5.7.17/data
Port = 3306
Character-set-server = 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 mysql extract Directory D:/mysql-5.7.15-winx64/bin (Note: here you need to enter the bin directory, otherwise the subsequent operation will be wrong)

3. register the Mysql service and 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 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

Highlights: mysql installation tutorials for different versions mysql5.7 installation tutorials for various versions mysql5.6 installation tutorials

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.