Oracle与MySQL的备份还原及密码修改等

1.在本地电脑中安装Oracle与MySQL数据库，Oracle创建表空间并新建管理员账号epoint，密码为Gepoint。

创建表空间

CREATE  tablespace epoint DATAFILE 'E:\app\Devil\oradata\orcl\epoint.dbf' SIZE 100M autoextend ON NEXT 50m;

新建用户名为epoint，密码为Gepoint的账号

CREATE USER epoint identified BY Gepoint DEFAULT tablespace EPOINT ;

给epoint账号授权

GRANT dba TO epoint;

2. 远程访问数据库

1. 防火墙新建入站规则即可进行远程访问
   
   
   
   
   

（Oracle端口号1521与上述相同）

远程连接Oracle数据库

远程连接MySQL数据库

3. 备份还原Oracle与 MySQL

Oracle：

1. 创建emp表并添加数据，添加备份的目录：
   

2. 备份:

expdp epoint/Gepoint directory=dump dumpfile=epoint.dmp schemas=epoint logfile=epoint_expdp.log

3. 还原

impdp epoint/Gepoint directory=dump dumpfile=EPOINT.DMP remap_schema=epoint:epoint remap_tablespace=epoint:epoint logfile=epoint_impdp.log

MySQL:

1. 创建数据库和表及插入表数据:
   

2. 备份:(提前创建好存放的文件夹)

>mysqldump -uroot -pGepoint --single-transaction -ER --master-data=2 --set-gtid-purged=off epoint > e:\backup\epoint.sql

3. 还原

mysql -uroot -pGepoint epoint < e:\backup\epoint.sql

4. Oracle与MySQL修改密码操作

在sql编辑器上直接执行sql语句即可
MySQL：

set password for root@'%'='Gepoint';

（注：root为我的库名，Gepoint为修改后密码）
Oracle：

alter user epoint identified by Gepoint;

（注：epoint为我的库名，Gepoint为修改后密码）
最后不要忘了刷新

flush privileges;

个人笔记，仅供参看，如有纰漏，请评论区告知谢谢！