1.通過mysql數(shù)據(jù)庫的user表查看用戶相關(guān)信息
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)
2.創(chuàng)建數(shù)據(jù)庫
mysql> create database [databasename] default character set utf8 collate utf8_general_ci; Query OK, 1 row affected (0.00 sec)
3.創(chuàng)建用戶
mysql> create user 'dba'@'%' identified by '*******'; Query OK, 0 rows affected (0.00 sec)
user表中host列的值的意義
% ? ? ? ? ? ? ?匹配所有主機
localhost ? ?localhost不會被解析成IP地址，直接通過UNIXsocket連接
127.0.0.1 ? ? ?會通過TCP/IP協(xié)議連接，并且只能在本機訪問；
::1 ? ? ? ? ? ? ? ??::1就是兼容支持ipv6的，表示同ipv4的127.0.0.1
4.對dba用戶給予針對指定數(shù)據(jù)庫進行增刪改查的權(quán)限
mysql> grant select,insert,update,delete,create on [databasename].* to dba; Query OK, 0 rows affected (0.00 sec)
注意：修改完權(quán)限以后 一定要刷新服務(wù)，或者重啟服務(wù)，刷新服務(wù)用：FLUSH PRIVILEGES
5.可以通過show grants命令查看權(quán)限，若想要在原來的基礎(chǔ)上增加權(quán)限則繼續(xù)執(zhí)行g(shù)rant
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)
?
6.通過revoke命令可以移除用戶的相關(guān)權(quán)限
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)
?
? 版權(quán)聲明
文章版權(quán)歸作者所有，未經(jīng)允許請勿轉(zhuǎn)載。
THE END
