rds本地库到rds恢复_华为云RDS备份导入到本地

RDS备份导入到本地

一、安装本地数据库

1、下载安装mysql

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

yum -y install mysql57-community-release-el7-10.noarch.rpm

yum -y install mysql-community-server

2、启动mysql

systemctl strat mysqld.service

systemctl status mysqld.service

3、登录

查看root初始密码：

grep "password" /var/log/mysqld.log

登录：

mysql -uroot –p

4、修改root密码：

ALTER USER 'root'@'localhost' IDENTIFIED BY '数据库密码';

5、授权远程登录

grant all on *.* to root@'%' identified by '数据库密码';

flush privileges;<