MySQL权限笔记

1、用root用户登陆

 

>mysql -h 127.0.0.1 -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.1.50-community MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

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

mysql>

 

2、查看权限

 

mysql> show grants for 'root'@'localhost';
+---------------------------------------------------------------------+
| Grants for root@localhost                                           |
+---------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
+---------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql>

 

3、为用户赋予特定数据库权限

mysql> grant select,insert,update,delete,create,drop on myblog.* to 'myblog'@'lo
calhost' identified by 'myblog';
Query OK, 0 rows affected (0.03 sec)

 

mysql> grant select,insert,update,delete,create,drop on myblog.* to 'myblog'@'*'
 identified by 'myblog';
Query OK, 0 rows affected (0.00 sec)