MySQL 5.7.18 version free installation configuration tutorial

MySQL is divided into installation version and free installation version

The suffix of the installation version is msi, and the suffix of the free installation version is zip. You can directly unzip the free installation version and configure it for use.

The installed version will be written to the system registry and will prompt for configuration during the installation process.
Installation-free ones need to be configured manually and are not written to the system registry.

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

The steps for installing the free version are as follows:
1. The first step is to unzip the file and put it in a folder, such as: D:\shujuku\MySql5.7\mysql-5.7.18-winx64

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

basedir = D:\shujuku\MySql5.7\mysql-5.7.18-winx64
datadir = D:\shujuku\MySql5.7\mysql-5.7.18-winx64\data
bind-address = 0.0.0.0
port =3306

If there is no my-default.ini, create the mmy.ini file directly and add

[client]
port=3306
default-character-set=utf8
[mysqld]
port=3306
character_set_server=utf8
basedir=D:\shujuku\MySql5.7\mysql-5.7.18-winx64
#Unzip directory datadir=D:\shujuku\MySql5.7\mysql-5.7.18-winx64\data
bind-address = 0.0.0.0
#Unzip the data directory in the directory sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

3. Configure environment variables and add 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 put it in the root directory at first, but it kept giving an error when I created the data folder later)

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

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

7. Create a data directory and enter the command: mysqld –initialize-insecure (generate a root user without a password). After execution, there is a data file in the mysql root directory, which contains some folders and contents.

Tips: (In version 5.7, there is no data file that needs to be created. In version 5.6, there is a data folder, so it does not need to be created. If this command fails, 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 This command is only useful when no password has been set.

10. If you want to delete MySQL, enter D:\shujuku\MySql5.7\mysql-5.7.18-winx64\bin in cmd. If the service is turned on, first shut down the MySQL service: netstop mysql, and then run: mysqld –remove .

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.