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