Installation-free configuration tutorial for MySQL 5.7.18,

Installation-free configuration tutorial for MySQL 5.7.18,

MySQL is divided into the installation version and the installation-free version.

The suffix of the installation version is msi, and the suffix of the installation-free version is zip. The installation-free version can be decompressed and configured.

The installed version will be written to the system registry, and the configuration will be prompted during the installation process.
Manual configuration is required for installation-free installation without writing to the system registry.

Download URL: http://dev.mysql.com/downloads

The installation-free configuration steps are as follows:
1. The first step to Extract files, casually put in a folder, such as: D: \ shujuku \ MySql5.7 \ mysql-5.7.18-winx64

2. Find the my-default.ini, change it to my. ini, add in my. ini

basedir = D:\shujuku\MySql5.7\mysql-5.7.18-winx64datadir = D:\shujuku\MySql5.7\mysql-5.7.18-winx64\databind-address = 0.0.0.0port =3306 

If there is no my-default.ini, directly create the idea. ini file, which includes

[Client] port = 3306default-character-set = utf8 [mysqld] port = 3306character_set_server = utf8basedir = D: \ shujuku \ MySql5.7 \ mysql-5.7.18-winx64 # extract directory datadir = D: \ shujuku \ MySql5.7 \ mysql-5.7.18-winx64 \ databind-address = 0.0.0.0 # extract the data directory SQL _mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES

3. Configure the environment variable, append D: \ shujuku \ MySql5.7 \ mysql-5.7.18-winx64 \ bin after the system variable path

4. Then put the my. ini file in the bin directory (I started to put it in the root directory, and always reported an error when I created the data folder later)

5. Run cmd as administrator and enter D: \ shujuku \ MySql5.7 \ mysql-5.7.18-winx64 \ bin

6. Run the installation Service mysqld-install. If the installation is successful, you will see: Service successfully installed.

7. create the data DIRECTORY And enter the command: mysqld-initialize-insecure (generate the root user without a password). After execution, there is a data file in the mysql root directory, it's okay to have some folders and content in it.

Tip: (version 5.7 does not need to create data files. version 5.6 does not need to create a data folder. If this command fails to be executed, you can copy the data folder from version 5.6 to version 5.7)

8. start the MySQL service: net start mysql

9. Create a password for the root user: mysqladmin-u root password "root". This command is only useful when no password has been set.

10. if you are deleting mysql, go to D: \ shujuku \ MySql5.7 \ mysql-5.7.18-winx64 \ bin in cmd. if the service is turned on, first close MySQL service: netstop mysql and then run: mysqld-remove.

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