mysql用戶管理：創(chuàng)建用戶
方法一颜矿、CREATE USER user1@'localhost' IDENTIFIED BY 'QianFeng@123456';
驗(yàn)證：select * from mysql.user\G;
方法二法竞、GRANT ALL ON *.* TO 'user3'@'localhost' IDENTIFIED BY 'QianFeng@123456';
驗(yàn)證：select * from mysql.user\G;
（再去查詢庫(kù)級(jí)權(quán)限表中，是否有權(quán)限呢氏堤？
并沒(méi)有屑彻，因?yàn)檫@是全局權(quán)限（所有庫(kù)）伟件。）
如果想針對(duì)某個(gè)庫(kù)分配權(quán)限，可以賦予一個(gè)用戶质况，針對(duì)一個(gè)庫(kù)設(shè)置權(quán)限低零。如圖一
FLUSH PRIVILEGES;? 或重啟
查看幫助信息? ?help grant：
Example 1: Create an account that uses the default authentication
plugin and the given password. Mark the password expired so that the
user must choose a new one at the first connection to the server:
CREATE USER 'jeffrey'@'localhost'
? IDENTIFIED BY 'new_password' PASSWORD EXPIRE;
Example 2: Create an account that uses the sha256_password
authentication plugin and the given password. Require that a new
password be chosen every 180 days:
CREATE USER 'jeffrey'@'localhost'
? IDENTIFIED WITH sha256_password BY 'new_password'
? PASSWORD EXPIRE INTERVAL 180 DAY;
CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'mypass';
GRANT ALL ON db1.* TO 'jeffrey'@'localhost';
GRANT SELECT ON db2.invoice TO 'jeffrey'@'localhost';
ALTER USER 'jeffrey'@'localhost' WITH MAX_QUERIES_PER_HOUR 90;
刪除用戶方法一如下圖：
DROP USER 'user1'@'localhost';
方法二如下圖：
修改用戶密碼：root修改自己密碼
方法一如下圖：
方法二如下圖：
方法三如下圖：
root修改其他用戶密碼：方法一如下圖：
方法二如下圖：
普通用戶修改自己密碼如下圖：
丟失root用戶密碼：
# vim /etc/my.cnf
? ? [mysqld]
? ? skip-grant-tables
? ? # service mysqld restart
? ? # mysql -uroot
? ? mysql> UPDATE mysql.user SET authentication_string=password('new_password')
WHERE user='root' AND host='localhost';
? ? mysql> FLUSH PRIVILEGES;
登錄和退出mysql如下圖：
語(yǔ)法格式如下圖：
權(quán)限應(yīng)用的順序：user (Y|N) ==> db ==> tables_priv ==> columns_priv
grant示例：
賦予權(quán)限分以下幾種：
回收權(quán)限：
查看當(dāng)前權(quán)限：
復(fù)制當(dāng)前權(quán)限：
替換grant/revoke,替換to/from
