1.创建保存备份文件的文件夹mkdir/data/mysqlbak2.编写脚本cd/data/mysqlbakvisqlAutoBak.shSH脚本内容：DBUSER"root"DBPASS"root"你的数据库密码DBHOST"localhost"DBNAME"test"你要备份的数据库BINDIR"/usr/bin"BCKDIR"/d

1、环境OS:SUSELinuxEnterprise12SP3X86_64(Kernel:4.4.16294.69.2)DB:12.2.0.1两节点RAC参考文档：在SLES12上安装OracleDatabase12.264bit（AMD64/EM64T）的要求(文档ID2

!(https://oscimg.oschina.net/oscnet/fe6d1798e33674a302b8ff67a7312ca2a67.png)https的实现​1）CA服务器端，生成自签证书root@ca~cd/etc/pki/CA/root@caCA(umask077;

开发工具IntellijIdea,版本Ultimate2020.2JDK：1.81.使用SpringInitializr新建项目,如果是社区版Idea，可以在线创建然后导入!(https://oscimg.oschina.net/oscnet/up5d92896117accfe498515c85fd59048bf19.png)

1.修改pom.xml，添加Druid依赖<dependency<groupIdcom.alibaba</groupId<artifactIddruidspringbootstarter</artifactId<v

1.添加依赖<dependency<groupIdorg.mybatis.spring.boot</groupId<artifactIdmybatisspringbootstarter</artifactId<version2.1.1</version</dependency<dependency<groupI

1.创建security模块!(https://oscimg.oschina.net/oscnet/up6c1e37e69bdae2b47cfccd0d90355efb21c.png)2.引入SpringSecurity依赖!(https://oscimg.oschina.net/oscnet/up1958a1d7b14ee0ad0

1.创建security模块!(https://oscimg.oschina.net/oscnet/up6c1e37e69bdae2b47cfccd0d90355efb21c.png)2.引入SpringSecurity依赖!(https://oscimg.oschina.net/oscnet/up1958a1d7b14ee0ad0

1.通过SpringInitializr创建父项目!(https://oscimg.oschina.net/oscnet/upe30ae6d283aac39d9744b4f1d6a43475b63.png)2.创建成功后!(https://oscimg.oschina.net/oscnet/up130513ac62ab47609dc

1、原理通过配置参数“skip\_grant\_tables”在mysql启动时跳过grant\_tables(授权表)，从而通过命令来充值root帐号的密码2、方式首先需要停止mysql服务（1）在my.ini文件的\mysqld\块下增加“skip\_gran