實訓案例名稱：數(shù)據(jù)庫用戶管理一、任務介紹通過連接MySQL、新增用戶、修改用戶密碼等來實現(xiàn)數(shù)據(jù)庫用戶管理。二、實現(xiàn)步驟1.連接MySQL（1）數(shù)據(jù)庫本地連接#使用用戶名root和相應密碼，連接本地MySQLC:\Users\Administrator>mysql-uroot-p123456mysql:[Warning]Usingapasswordonthecommandlineinterfacecanbeinsecure.mysql>（2）數(shù)據(jù)庫遠程連接#使用用戶名root和相應密碼，連接遠程MySQLC:\Users\Administrator>mysql-h10.120.71.89-uroot-p123456mysql:[Warning]Usingapasswordonthecommandlineinterfacecanbeinsecure.mysql>2.新增用戶#使用用戶名root和相應密碼，連接本地MySQLC:\Users\Administrator>mysql-uroot-p123456mysql:[Warning]Usingapasswordonthecommandlineinterfacecanbeinsecure.#創(chuàng)建用戶并指定密碼mysql>CREATEUSERshopdb@'%'IDENTIFIEDBY'shopdb_123456';QueryOK,0rowsaffected(0.07sec)#授予對所有數(shù)據(jù)庫的所有權限mysql>GRANTALLPRIVILEGESON*.*TOshopdb@'%'WITHGRANTOPTION;QueryOK,0rowsaffected(0.01sec)#授予指定權限，把增、刪、改、查操作權限授予用戶shopdbmysql>GRANTSELECT,INSERT,UPDATE,DELETEon*.*toshopdb@"%"WITHGRANTOPTION;QueryOK,0rowsaffected,1warning(0.71sec)#授予對指定數(shù)據(jù)庫（test數(shù)據(jù)庫）的權限mysql>GRANTSELECT,INSERT,UPDATE,DELETEontest.*toshopdb@"%"WITHGRANTOPTION;QueryOK,0rowsaffected,1warning(0.71sec)#撤銷對指定數(shù)據(jù)庫（test數(shù)據(jù)庫）的SELECT權限mysql>REVOKESELECTONtest.*FROM'shopdb'@'%';QueryOK,0rowsaffected(0.00sec)#退出mysql>exit;Bye#使用用戶名shopdb和相應密碼，連接本地MySQLC:\Users\Administrator>mysql-ushopdb-pshopdb_1234563.修改用戶密碼#使用用戶名root和相應密碼，連接本地MySQLC:\Users\Administrator>mysql-uroot-p123456mysql:[Warning]Usingapasswordonthecommandlineinterfacecanbeinsecure.#授予reload權限mysql>GRANTreloadON*.*to'shopdb'@'%';QueryOK,0rowsaffected(0.08sec)#修改密碼mysql>ALTERUSER'shopdb'@'%'IDENTIFIEDBY'123456';QueryOK,0rowsaffe