mysql创设用户、授权使用数据库、删除用户之各两种方法解决

mysql创建用户、授权使用数据库、删除用户之各两种方法解决
使用root登陆mysql；

创建用户并授权使用数据库方法一

mysql> use mysqlDatabase changedmysql> insert into user(Host,User,Password) values("localhost","little_bill",password("1234"));Query OK, 1 row affected, 3 warnings (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> exitByeE:\>mysql -u root -pEnter password: Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 8Server version: 5.1.41-community MySQL Community Server (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> create database little_billDB;Query OK, 1 row affected (0.03 sec)mysql> grant all privileges on little_billDB.* to little_bill@localhost identified by '1234';Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> exitBye

mysql> use mysqlDatabase changedmysql> DELETE FROM user WHERE User="little_bill" and Host="%";Query OK, 1 row affected (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> exitBye

mysql> CREATE USER 'little_bill'@'%' IDENTIFIED BY  '123456';Query OK, 0 rows affected (0.00 sec)mysql> CREATE DATABASE IF NOT EXISTS  `little_billDB`;Query OK, 1 row affected (0.00 sec)mysql> GRANT ALL PRIVILEGES ON  `little_billDB` . * TO  'little_bill'@'%';Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> exitBye

mysql> drop user 'little_bill'@'%';Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)