Mysql 5.7.17 installation-free configuration method graphic tutorial (windows10), 5.7.17windows10

Mysql 5.7.17 installation-free configuration method graphic tutorial (windows10), 5.7.17windows10

I. Overview

I found a lot on the Internet. I found that many of them are not linux systems, but they are different from the current new version. I have done some practical work on small projects for your reference.

MySQL version: mysql-5.7.17

Download Method:

1. MySQL official website https://www.mysql.com/downloads/
2. Download Method:

A. Select the corresponding module:

 

B. Select the corresponding version (here I select windows ):

C. Select the 32-bit or 64-bit version for download:

 

D. Click Download. It will allow logon or registration. You can skip this step:

Ii. MySQL installation and configuration

1. decompress the downloaded. ZIP file and place it to the location to be installed., Random location.

Open the folder, create the my. ini file, and enter:

[Mysql] # set the default character set of the mysql client default-character-set = utf8 [mysqld] # set port 3306 to port 3306 # set the mysql installation directory basedir = D: \ mysql \ mysql-5.7.17-winx64 // your own path # Set the mysql database data storage directory datadir = D: \ mysql \ mysql-5.7.17-winx64 \ data // your path # maximum number of connections allowed max_connections = 200 # the character set used by the server defaults to the 8-bit latin1 character set character-set-server = utf8 # Created default storage engine default-storage-engine = INNODB

And save it as ANSI format.

2. Open WindowsEnvironment variable settingsIn the Path variable of the environment variable, put the full Path of the bin directory of mysql in it, and then add an English semicolon (;) after the Path to save.
Such as D:/mysql/mysql-5.7.11-winx64/bin;

3. Install the MySQL service:Mysqld-install

Start: net start MySQL
Stop: net stop MySQL
Uninstall: SC delete MySQL, mysqld-remove
The command line window must be opened in administrator mode.
A. install the service: mysqld-install.
B. start the Service net start MySQL
(The MySQL service is starting. The MSQL service cannot be started. The Service did not report any errors. Type net helpmsg 3534 for more help.
Delete the data folder and use mysqld-initialize to initialize the data directory.

4. When the service is enabled successfully, use
Mysql-u root-p press ENTER
Enter the password (in the data folder with the suffix. err)
Enter and press Enter.
Note: The old version does not have a password at the beginning. You can log on to the old version by pressing enter. The new version generates a random password to enhance security.

5. Change the password

There are three methods:

① Run the set password command: log on to MySQL first.
Format: mysql> set password for username @ localhost = password ('new password ');
Example: mysql> set password for root @ localhost = password ('20140901 ');
(Mysql> set password = password ('20140901 ');)

② Use mysqladmin (used without logging on to MySQL)
Format: mysqladmin-u username-p old password New password
Example: mysqladmin-uroot-p123456 password 123

③ Use UPDATE to directly edit the user table
First, log on to MySQL.

mysql> use mysql; mysql> update user set password=password(‘123') where user='root' and host='localhost'; mysql> flush privileges;

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