mysql簡単なユーザー管理文

1861 ワード

--       
CREATE USER zhangsan IDENTIFIED BY '123456';


--     
SET PASSWORD FOR 'zhangsan'=PASSWORD('123456')


--     
GRANT ALL ON *.* TO zhangsan
--     
SHOW GRANTS FOR 'root'@'localhost'

--         
SHOW GRANTS FOR CURRENT_USER

--     
REVOKE ALL ON *.* FROM zhangsan

--     
DROP USER zhangsan