mysql 权限管理 针对库 授权

mysql>grantselecton db1.*to‘mike‘@‘localhost‘;
Query OK, 0 rows affected (0.05 sec)

mysql>select*from mysql.db\G;

mysql>exit
Bye

[root@mysql ~]# mysql -umike -p123
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands endwith ; or \g.
Your MySQL connection id is6
Server version: 5.6.36 Source distribution

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;‘or‘\h‘for help. Type ‘\c‘to clear the current input statement.

mysql> show databases;
+--------------------+|Database|+--------------------+| information_schema || db1                || test               || test_1             |+--------------------+4 rows inset (0.00 sec)

mysql>use db1;
Reading table information for completion oftableandcolumn names
You can turn off this feature to get a quicker startup with-A

Database changed
mysql> 
mysql> show tables;
+---------------+| Tables_in_db1 |+---------------+| innodb__t_t1  || innodb__t_t2  || innodb__t_t3  || innodb__t_t4  || t1            || t3            |+---------------+6 rows inset (0.00 sec)

mysql>desc t1;
+-------+-----------------------+------+-----+---------+-------+| Field | Type                  |Null|Key|Default| Extra |+-------+-----------------------+------+-----+---------+-------+| id    |int(11)               | YES  ||NULL||| name  |varchar(50)           | YES  ||NULL||| sex   | enum(‘male‘,‘female‘) | YES  ||NULL||| age   |int(4)                | YES  ||NULL||+-------+-----------------------+------+-----+---------+-------+4 rows inset (0.00 sec)

mysql>select*from t1;
+------+------+--------+------+| id   | name | sex    | age  |+------+------+--------+------+|1| mike | male   |15||2| alex | female |16||3|NULL|NULL|NULL||4|NULL|NULL|NULL|+------+------+--------+------+4 rows inset (0.00 sec)


mysql>insertinto t1 values(5,‘jack‘,‘male‘,5);
ERROR 1142 (42000): INSERT command denied touser‘mike‘@‘localhost‘fortable‘t1‘