MySQL free installation version (zip) installation and configuration detailed tutorial

This article shares the installation and configuration tutorial of MySQL free installation version (zip) for your reference. The specific contents are as follows

1. Download from MySQL official website

2. Download Unzip to D:\mysql-5.7.22-winx64

3. Create a new my.ini in the D:\mysql-5.7.22-winx64 directory and write the following code: (Note that you should change your own in D:\mysql-5.7.22-winx64)

[mysqld]
# Set the installation directory of mysql to basedir=D:\mysql-5.7.22-winx64
# Set the storage directory for mysql database data, which must be data
datadir=D:\mysql-5.7.22-winx64\data
#mysql port port=3306
# Character set character_set_server=utf8
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

4. Open the DOS command line (win+R, enter cmd), enter D:\mysql-5.7.22-winx64\bin, and execute the command mysqld -install mysql

5. Initialization, mysqld --initialize-insecure , after initialization, data will appear in the D:\mysql-5.7.22-winx64 directory

6. Start the service, net start mysql

7. Log in to MySQL, the default password is empty, just press Enter

8. Change password

Finish! ! !

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.