mysql 相关操作记录

新建用户

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

给数据库赋权

GRANT ALL ON databasename.tablename TO 'username'@'host';
-- 一个库的所有表赋权
GRANT ALL ON databasename.* TO 'username'@'%';
-- 特定的操作和表
GRANT SELECT, INSERT ON test.user TO 'pig'@'%';
-- 所有的库及表
GRANT ALL ON *.* TO 'pig'@'%';

修改密码

SET PASSWORD FOR 'username'@'host' = PASSWORD('newpassword');
-- 如果是当前用户
SET PASSWORD = PASSWORD("newpassword");