建立用户，授权数据库：
|
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 |
mysql> create user 'byrd'@'localhost' identified by 'admin123'; #建立主机为localhost，密码为admin123的用户byrd Query OK, 0 rows affected (0.05 sec) mysql> show grants for 'byrd'@'localhost'; #查看byrd权限，USAGE表示连接权限 +-------------------------------------------------------------------------------------------------------------+ | Grants for byrd@localhost | +-------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'byrd'@'localhost' IDENTIFIED BY PASSWORD '*01A6717B58FF5C7EAFFF6CB7C96F7428EA65FE4C' | +-------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> select user,host from mysql.user; +------+-----------+ | user | host | +------+-----------+ | root | 127.0.0.1 | | root | ::1 | | root | lamp | | byrd | localhost | | root | localhost | +------+-----------+ 5 rows in set (0.00 sec) mysql> grant all on gbk.* to 'byrd'@'localhost'; #用户byrd、主机localhost对数据库gbk拥有所有权限 Query OK, 0 rows affected (0.01 sec) mysql> show mysqls for 'byrd'@'localhost'; +-------------------------------------------------------------------------------------------------------------+ | Grants for byrd@localhost | +-------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'byrd'@'localhost' IDENTIFIED BY PASSWORD '*01A6717B58FF5C7EAFFF6CB7C96F7428EA65FE4C' | | GRANT ALL PRIVILEGES ON `gbk`.* TO 'byrd'@'localhost' | +-------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) mysql> flush privileges; mysql> grant all on gbk.* to test@'localhost' identified by 'admin123'; #建立用户test，用户gbk数据库所有权限，同上 mysql> show grants for 'test'@'localhost'; +-------------------------------------------------------------------------------------------------------------+ | Grants for test@localhost | +-------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'test'@'localhost' IDENTIFIED BY PASSWORD '*01A6717B58FF5C7EAFFF6CB7C96F7428EA65FE4C' | | GRANT ALL PRIVILEGES ON `gbk`.* TO 'test'@'localhost' | +-------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) Query OK, 0 rows affected (0.00 sec) |
远程连接同上：
|
0 1 |
mysql> grant all on gbk.* to 'user'@'授权可连接主机' identified by 'admin123'; #这是Server端 [root@lamp ~]# /usr/local/mysql/bin/mysql -uroot -p'admin123' -h hk.t4x.org #这是client端 |
申明：本文由BYRD原创(基于Mysql5.6.16)，未经许可禁止转载！
数据库权限参考：http://note.t4x.org/database/all-privileges-detailed/ SourceByrd's Weblog-https://note.t4x.org/database/grant-databases-identified/
申明：除非注明Byrd's Blog内容均为原创,未经许可禁止转载!详情请阅读版权申明!
