mysqldump -u root -p mantis>mantis.sql // 导出数据库
mysql>CREATE DATABASE IF NOT EXISTS mantis default charset utf8 COLLATE utf8_general_ci; // 新建数据库
mysql>source mantis.sql; //还原数据库
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY '123456' WITH GRANT OPTION; // 强制本地登录时使用密码
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; // 允许异地用密码登录