mysql创建账户密码

create user 'appuser'@'%' identified by 'password'

GRANT ALL PRIVILEGES ON *.* TO 'appuser'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;  

GRANT ALL PRIVILEGES ON *.* TO 'appuser'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;  

FLUSH PRIVILEGES;

# 模糊导出表

mysqldump -u账户 -p密码 数据库 $(mysql -u账户 -p密码 -D 数据库 -Bse "SHOW TABLES LIKE '匹配规则%'") > master.sql