详细说明MySQL创建数据库与创建用户以及授权

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select host,user,password from user ;+-----------+------+-------------------------------------------+
  host        user   password                                   
+-----------+------+-------------------------------------------+
  localhost   root   *87F2746835A04895BB77E12AA5054A767*******  
  qxyw        root                                              
  127.0.0.1   root                                              
  localhost                                                     
  qxyw                                                          
+-----------+------+-------------------------------------------+
5 rows in set (0.00 sec)

mysql> create database [databasename] default character set utf8 collate utf8_general_ci;
Query OK, 1 row affected (0.00 sec)

mysql> create user 'dba'@'%' identified by '*******';
Query OK, 0 rows affected (0.00 sec)

mysql> grant select,insert,update,delete,create on [databasename].* to dba;
Query OK, 0 rows affected (0.00 sec)

mysql> grant drop on [databasename].* to dba;
Query OK, 0 rows affected (0.00 sec)
mysql> show grants for dba;+----------------------------------------------------------------------------------------------------+
  Grants for dba@%                                                                                    
+----------------------------------------------------------------------------------------------------+
  GRANT USAGE ON *.* TO 'dba'@'%' IDENTIFIED BY PASSWORD '*****************************************'  
  GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON `[databasename]`.* TO 'dba'@'%'               
+----------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> revoke drop on [databasename].* from dba;
Query OK, 0 rows affected (0.00 sec)
mysql> show grants for dba;+----------------------------------------------------------------------------------------------------+
  Grants for dba@%                                                                                    
+----------------------------------------------------------------------------------------------------+
  GRANT USAGE ON *.* TO 'dba'@'%' IDENTIFIED BY PASSWORD '*****************************************'  
  GRANT SELECT, INSERT, UPDATE, DELETE, CREATE ON `[databasename]`.* TO 'dba'@'%'                     
+----------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)