MySql（5）-用户权限管理

/*创建用户*/
CREATE  USER ttxiaxue IDENTIFIED BY '654321'

/*修改当前用户密码*/
SET PASSWORD =PASSWORD('123456')

/*修改指定用户密码*/
SET PASSWORD FOR ttxiaxue = PASSWORD('123456')

/*重命名 rename user 原名 to 新名*/
RENAME USER ttxiaxue TO tiantianxx

/*用户授权 all privileges  全部的权限 */
/*all privileges  除了给别人授权 其他都能干*/
GRANT ALL PRIVILEGES ON *.* TO tiantianxx

/*查询权限*/
SHOW GRANTS FOR root@localhost 

/*root用户权限 GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION*/

/*撤销权限 revoke*/
REVOKE ALL PRIVILEGES ON *.* FROM tiantianxx

/*删除用户*/
DROP USER tiantianxx