1. Download the latest version of MySQL.
Http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.15-winx64.zip
2. Extract to Folder.
D:\software\mysql\mysql5.7a
Copy My-default.ini to My.ini
3. Editor My.ini
# These are commonly set, remove the # and set as required.
Basedir = "d:/software/mysql/mysql57a"
datadir = "D:/software/mysql/mysql57a/data"
port=3308
Modify the installation directory and the data directory.
4. Install MySQL service.
Use Administrator Command mode.
Go to the Bin directory.
Execute command mysqld-install mysql57a
5. Initialize
Mysqld–initialize
The data generated in the directory is as follows:
6. Start MySQL service.
Net–start mysql57a
7. Password-Free login configuration.
The first logon generally does not have a password, if you cannot log in follow the steps below.
mysql–uroot–p–p3308
Add Configuration in My.ini
Skip-grant-tables
Restart the service and retry the logon.
mysql–uroot–p–p3308
This time you do not have to enter the password to log in.
Execute use MySQL
Update Mysql.user set Authentication_string=password (' root ') where user= ' root ';
And then delete:
Skip-grant-tables configuration.
Restart the MySQL service.
Using commands
mysql–uroot–proot–p3308 and then it's OK.
The above is a small set to introduce the MySQL 5.7 zip file in Windows installation tutorial detailed, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!