MySQL软件ææä¾çæé(mysql.userãmysql.dbãmysql.host)
(1) ç³»ç»è¡¨mysql.user
useræé表ä¸å段å为åç±»: ç¨æ·å段ãæéå段ãå®å
¨å段åèµæºæ§å¶å段ã
ç¨æ·å段
ç¨æ·å段.png
æéå段
æéå段.png
å®å ¨å段
å®å ¨å段.png
# æ¥çæ¯å¦æ¯æsslæ åshow variables like 'have_openssl';123èµæºæ§å¶å段
èµæºæ§å¶.png
ç³»ç»è¡¨mysql.userä¸çææèµæºå段çé»è®¤å¼ä¸º0ï¼è¡¨ç¤ºæ²¡æä»»ä½éå¶ã
(2) ç³»ç»è¡¨mysql.dbåmysql.host
å¨ç³»ç»æ°æ®åºmysqlä¸ï¼æé表é¤äºè¡¨userå¤ï¼è¿æ表dbå表hostï¼è¿ä¸¤å¼ 表é½åå¨äºæ个ç¨æ·å¯¹æ°æ®åºçæéã
ç¨æ·å段
mysql.db表
mysql.db表.png
mysql.host表
mysql.host表.png
æéå段
æéå段.png
(3)å
¶ä»æé表
å¨ç³»ç»æ°æ®åºmysqlä¸ï¼é¤äºä¸è¿°æé表å¤ï¼è¿æ表tables_privåcolumns_privï¼å
¶ä¸æ tables_privç¨æ¥å®ç°å个表çæé设置ï¼è¡¨columns_privç¨æ¥å®ç°å个å段åçæé设置ã
ç³»ç»è¡¨mysql.tables_priv表ç»æ
mysql.tables_priv表ç»æ.png
mysql.tables_priv表ç»æ.png
ç³»ç»è¡¨mysql.columns_privç表ç»æ
columns_privç表ç»æpng
ç¨æ·æºå¶
(1) ç»å½åéåºMySQL软件çå®æ´å½ä»¤
(2) å建æ®éç¨æ·è´¦æ·
æ§è¡CREATE USERè¯å¥æ¥å建ç¨æ·è´¦æ·
create user 'mazaiting'@'localhost' identified by '123456';12æ§è¡INSERTè¯å¥æ¥å建ç¨æ·
insert into user(host,user,password,ssl_cipher,x509_issuer,x509_subject)values('localhost', 'linghaoyu', password('linghaoyu'),'','','');# 使æ°å»ºç¨æ·çæflush privileges;12345æ§è¡GRANTè¯å¥æ¥å建ç¨æ·
grant select on company.t_deptto 'wangxingqin'@'localhost' identified by 'wangxingqin';123(3) å©ç¨è¶ 级æéç¨æ·rootä¿®æ¹ç¨æ·è´¦æ·å¯ç
ä¿®æ¹è¶ 级æéç¨æ·è´¦æ·å¯ç
# éè¿mysqladminå½ä»¤ä¿®æ¹rootç¨æ·å¯ç mysqladmin -u root -p password "123456"# éè¿SETå½ä»¤ä¿®æ¹å¯ç set password=password("123456");# æ´æ°ç³»ç»è¡¨mysql.useræ°æ®è®°å½ä¿®æ¹rootç¨æ·å¯ç update user set password=password("123456")where user="root" and host="localhost";12345678(4) å©ç¨æ¥æè¶ çº§æéç¨æ·rootä¿®æ¹æ®éç¨æ·è´¦æ·å¯ç
# å建ç¨æ·grant select,create,drop on *.*to 'mazaiting'@'localhost' identified by 'mazaiting'with grant option;# éè¿grantå½ä»¤ä¿®æ¹ç¨æ·å¯ç grant select,create,drop on *.*to 'mazaiting'@'localhost' identified by '123456';# éè¿setå½ä»¤ä¿®æ¹ç¨æ·å¯ç set password for 'mazaiting'@'localhost'=password("123456");# æ´æ°ç³»ç»è¡¨mysql.useræ°æ®è®°å½ä¿®æ¹ç¨æ·å¯ç update user set password=password("mazaiting")where user='mazaiting' and host='localhost';# ç»å½å½åç¨æ·ï¼å¹¶ä½¿ç¨setå½ä»¤ä¿®æ¹å¯ç set password=password("123456");123456789101112131415(5) å é¤æ®éç¨æ·è´¦æ·
éè¿DROP USERè¯å¥å é¤æ®éç¨æ·
drop user 'mazaiting'@'localhost';12å é¤ç³»ç»è¡¨mysql.useræ°æ®è®°å½å®ç°å é¤ç¨æ·è´¦å·
# éæ©mysqlæ°æ®åºuse mysql;# å é¤ç¨æ·delete from user where user='mazaiting' and host='localhost';12345æé管ç
(1) 对ç¨æ·è¿è¡ææ
(2) æ¥çç¨æ·ææ¥ææé
show grants for 'mazaiting'@'localhost' \G12(3) æ¶åç¨æ·ææ¥ææé
# åæ¶ç¨æ·çæ¥è¯¢æérevoke select on *.* from 'mazaiting'@'localhost';# åæ¶ç¨æ·çå ¨é¨æérevoke all privileges, grant optionfrom 'mazaiting'@'localhost