Windows MySQL 5.6 zip installation and create user-given database permissions

1. download MySQL 5.6 Zip

　　Download MySQL 5.6 Zip first (on the official website (http://www.mysql.com/downloads/) or any other site), then unzip it on your computer D:\java\mysql-5.6.22-winx64 Finally, add D:\java\mysql-5.6.22-winx64\bin to the environment variable path to facilitate direct command operation

2. Order Preparation before installation

Locate the unpacked My-default.ini File open (recommended notepad++ here)

Add these two variables inside

basedir=d:\java\mysql-5.6.22-winx64 where MySQL is located
Datadir=d:\java\mysql-5.6.22-winx64\data Data Location

3. Start the installation command

This requires administrator privileges, or it will report no permissions issues.

Go to the Bin folder of the installation directory: Mysqld-install service successfully installed indicates successful installation

4. Start the service:

net start MySQL in Task Manager--service to see if there is a MySQL service

5. Log in to MySQL

Mysql-u root-p (first login without password, press ENTER directly)

6. Create a new User:

Insert into Mysql.user (Host,user,password) VALUES ('% ', ' test ', Password (' Test ')); % means connecting from any address

Flush privileges; Refresh system tables

7. Create a database:

Create Database TestDB;

8. Assigning permissions to users:

Authorization format:

Grant all privileges the testdb.* to [e-mail protected] identified by ' Test ';

Flush privileges;//Refresh System Permissions Table

Windows MySQL 5.6 zip installation and create user-given database permissions