1, create schema [database name] default character set UTF8 collate utf8_general_ci;--CREATE database with Create schema and creation database The same as the fruit. 2, create user ' [user name] ' @ '% ' identified by ' [user password] ';--Create password of 8 or more, including: uppercase letters, lowercase letters, numbers, special characters%: Match all hosts, the place can also be set to ' LocalHost ', which represents only local access, for example, the root account default is ' localhost ' 3, Grant select,insert,update,delete,create on [database name].* to [user name];-- User Authorization database * represents the entire database 4, flush privileges;--immediately enable modify 5, revoke all on *. * FROM tester;--cancels all permissions of the user all databases (tables) 6, delete from Mysql.user where user= ' tester ';--delete user 7, drop database [schema name | database name];--DELETE DB classification: Database
MySQL CREATE database and create user and authorize