数据库之用户权限管理和数据库备份

用户权限管理和数据库备份

-- 创建一个用户
CREATE  USER `saxon1` identified by '123456';
-- 更改用户的密码，但是不适用于高版本
SET PASSWORD FOR `saxon2`= PASSWORD('123456789')
-- 更改用户的名字
RENAME USER saxon1 TO saxon2 
-- 显示用户的权限
SHOW GRANTS  FOR  `saxon`
-- root账户的权限
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO `saxon`@`%` WITH GRANT OPTION
--