1. 备份
mysqldump -uroot -p*** db_name > db_name.sql
2. 恢复
先创建要恢复的数据库名
create database db_name CHARSET=utf8;
mysql -uroot -p*** db_name < db_name.sql
备份用mysqldump, 恢复直接用mysql命令既可以了。
3. 创建用户和分配权限
CREATE USER 'hrg'@'%' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON *.* TO 'hrg'@'%' IDENTIFIED BY '123456' with grant option;
flush privileges;