MySQL 5.7.18 installation tutorial under Windows

This article explains how to install MySQL from a compressed package.

1. Download the MySQL compressed package, [Windows (x86, 64-bit), ZIP Archive];

2. Unzip the Zip package to the required directory, for example, D:\mysql-5.7.18-winx64;

3. Create the my.ini file with the following content:

[mysqld] 
port=3306 
basedir=D:\\mysql-5.7.18-winx64\\
datadir=F:\\mysqlData\\
character-set-server=utf8

Note that basedir and datadir must be configured, basedir is the directory where you unzipped the files. The official documentation says that if you like to use slashes, you should use double slashes, but not backslashes. That is: D:\\mysql-5.7.13-winx64\\ or: D:/mysql-5.7.13-winx64/
Since I like to separate the database data files, I configure the datadir to other places for easy management.

4. Configure environment variables

Add a variable called MYSQL_HOME.
Modify the Path variable and add %MYSQL_HOME%\bin at the end

5. Initialize and start the Mysql service

Run cmd with administrator privileges, initialize MySQL, and execute

mysqld --initialize-insecure

Register the MySQL service, start MySQL, and execute

mysqld -install
net start mysql

6. Log in to MySQL and set the root password

mysql -uroot -p

When you log in for the first time, press Enter to log in without a password. After logging in to MySQL, set the root password

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

After changing the password, we can log in successfully using root.

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.