MySQL 5.7.17 is free of installation configuration, and mysql5.7.17

MySQL 5.7.17 is free of installation configuration, and mysql5.7.17

MYSQL version: MySQL Community Server 5.7.17. The installation-free version is as follows:

:Https://dev.mysql.com/downloads/mysql/

Computer System: Laptop win10, 64-bit

1. Download and decompress

Download the package and decompress it to your local device.

The decompressed file is as follows:

2. Create the my. ini file.

Copy and paste the my-default.ini file and rename it my. ini

Then Replace the text content

[Mysql] # set the default character set of the mysql client default-character-set = utf8 [mysqld] # set port 3306 = 3306 # set the mysql installation directory basedir = E: \ dataBase \ mysql-5.7.17-winx64 # Set the mysql dataBase data storage directory datadir = E: \ dataBase \ mysql-5.7.17-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 # default storage engine default-storage-engine = INNODB

Note that E: \ dataBase \ mysql-5.7.17-winx64 above should be changed to the file location on your own computer.

3. Create data files

Run the command as an administrator and open cmd.

Switch the file directory to the E: \ dataBase \ mysql-5.7.17-winx64 \ bin directory, depending on where you installed it.

Enter mysqld -- initialize-insecure -- user = mysql. Wait for a while to open the Directory and you will find a new data folder.

4. Start mysql

Run the following command in bin>:

mysqld install MySQL --defaults-file="E:\dataBase\mysql-5.7.17-winx64\my.ini"

Note the replacement.

Here an error is reported: The service already exists!

Then enter mysqld-remove.

Then enter: mysqld install MySQL -- defaults-file = "E: \ dataBase \ mysql-5.7.17-winx64 \ my. ini"

Service successfully installed is displayed.

Then enter the startup command: net start mysql

5. Local Environment Configuration

In the system environment variable, "CREATE" a variable named "MYSQL_HOME. Variable value: "E: \ dataBase \ mysql-5.7.17-winx64"

Edit the existing environment variable "Path" and add "% MYSQL_HOME % \ bin" at the end ".

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