MySQL CREATE database and create user and authorize

1, create schema [database name] default character set UTF8 collate utf8_general_ci;--CREATE database

The CREATE schema is the same as creating database.

2, create user ' [user name] ' @ '% ' identified by ' [user password] ';--Create users

Password more than 8, including: uppercase letters, lowercase letters, numbers, special characters

%: Matches all hosts, the place can also be set to ' localhost ', which means only local access, for example, the root account defaults to ' localhost '

3. Grant Select,insert,update,delete,create on [database name].* to [user name];--user authorization Database

* Represents the entire database

4, flush privileges;--Enable modification now

5, revoke all on * * from tester;--Cancel all permissions of user all database (table)

6. Delete from Mysql.user where user= ' tester ';--delete user

7. Drop DATABASE [schema name | database name];--DELETE databases

MySQL CREATE database and create user and authorize