Mysql 5.7.21 winx64 installation-free configuration method graphic tutorial, 5.7.21winx64

Mysql 5.7.21 winx64 installation-free configuration method graphic tutorial, 5.7.21winx64

For your reference, the configuration method of mysql 5.7.21 winx64 without installation is as follows:

1. Download

Click

2. decompress the package to the directory

3. Configuration

Create a txt file, save it as my. ini, and put it in the MySQL directory

[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: \ Program Files \ mysql-5.7.21-winx64 # Set the mysql database data storage directory datadir = D: \ Program Files \ mysql-5.7.21-winx64 \ data # 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 # Will be used when creating a new table default storage engine default-storage-engine = INNODB

Note:Basedir and datadir are stored in mysql.

4. Add the bin directory to the path environment variable.

5. Install the MySQL Service

Execute mysqld install

If "xxx. dll is missing, install the Microsoft Runtime Library

Http://www.bkjia.com/softs/69599.html

6. generate the data directory (MySQL 5.7.16 will not provide the data directory by default)

First, go to the bin directory.

Run mysqld -- initialize-insecure -- user = mysql

No prompt is displayed after running.

Check whether the data directory content is correct

7. Run the MySQL Service

Net start mysql

The command to disable the MySQL service is net stop mysql.

8. log on to MySQL

mysql -u root –p

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