實訓(xùn)案例名稱：權(quán)限管理一、任務(wù)介紹下面將創(chuàng)建數(shù)據(jù)庫、表、索引的權(quán)限賦予xiaogang這個用戶，然后再撤回這個權(quán)限，接著授予所有權(quán)限。二、實現(xiàn)步驟#使用用戶名root和相應(yīng)密碼，連接本地MySQLC:\Users\Administrator>mysql-uroot-p123456mysql:[Warning]Usingapasswordonthecommandlineinterfacecanbeinsecure.#顯示用戶xiaogang的權(quán)限，USAGE表示沒有任何權(quán)限mysql>SHOWGRANTSFORxiaogang;+---------------------------------------------------------+|Grantsforxiaogang@%|+---------------------------------------------------------+|GRANTUSAGEON*.*TO'xiaogang'@'%'WITHGRANTOPTION|+---------------------------------------------------------+1rowinset(0.00sec)#將創(chuàng)建數(shù)據(jù)庫、表、索引的權(quán)限授予用戶xiaogangmysql>GRANTCREATEON*.*TO'xiaogang'@'%'WITHGRANTOPTION;QueryOK,0rowsaffected,1warning(0.00sec)#顯示用戶xiaogang的權(quán)限，該用戶擁有創(chuàng)建數(shù)據(jù)庫、表、索引的權(quán)限mysql>SHOWGRANTSFORxiaogang;+---------------------------------------------------------+|Grantsforxiaogang@%|+---------------------------------------------------------+|GRANTCREATEON*.*TO'xiaogang'@'%'WITHGRANTOPTION|+---------------------------------------------------------+1rowinset(0.00sec)#撤銷用戶xiaogang創(chuàng)建數(shù)據(jù)庫、表、索引的權(quán)限mysql>REVOKECREATEON*.*FROM'xiaogang'@'%';QueryOK,0rowsaffected(0.00sec)#權(quán)限撤銷后，用戶xiaogang無任何權(quán)限mysql>SHOWGRANTSFORxiaogang;+---------------------------------------------------------+|Grantsforxiaogang@%|+---------------------------------------------------------+|GRANTUSAGEON*.*TO'xiaogang'@'%'WITHGRANTOPTION|+---------------------------------------------------------+1rowinset(0.00sec)#授予用戶xiaogang所有權(quán)限mysql>GRANTALLPRIVILEGESON*.*TO'xiaogang'@'%'WITHGRANTOPTION;QueryOK,0rowsaffected,1warning(0.00sec)#顯示用戶xiaogang的權(quán)限，該用戶擁有所有權(quán)限mysql>SHOWGRANTSFORxiaogang;+-----------------------------------------------------------------+|Grantsforxiaogang@%|+-----------------------------------------------------------------+|GRANTALLPRIVILEGESON*.*TO'xiaogang'@'%'WITHGRANTOPTION|+-----------------------------------------------------------------+1rowinset(0.00sec)#查詢用戶xiaogang擁有的具體權(quán)限mysql>SELECT*FROMmysql.userWHEREuser='xiaogang'\G***************************1.row***************************Host:%User:xiaogangSelect_priv:YInsert_priv:YUpdate_priv:YDelete_priv:YCreate_priv:YDrop_priv:YReload_priv:YShutdown_priv:YProcess_priv:YFile_priv:YGrant_priv:YReferences_priv:YIndex_priv:YAlter_priv:YShow_db_priv:YSuper_priv:YCreate_tmp_table_priv:YLock_tables_priv:YExecute_priv:YRepl_slave_priv:YRepl_client_priv:YCreate_view_priv:YShow_view_priv:YCreate_routine_priv:YAlter_routine_priv:YCreate_user_priv:YEvent_priv:YTrigger_priv:YCreate_tablespace_priv:Yssl_type:ssl_cipher:0xx509_issuer:0xx509_subject:0xmax_questions:0max_updates:0max_connections:0max_user_connections:0plugin:caching_sha2_passwordauthentication_string:$A$005$7password_expired:Npassword_last_changed:2023-06-1500:04:12password_lifetime:NULLaccount_locked:NC