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