设置mysql免密码登录配置（前提是当前主机安装了“mysql-client”）可以避免Warning:Usingapasswordonthecommandlineinterfacecanbeinsecure.[root@xxxx-zabbx-12l~]#mysql_config_editor设置--login-path=confdb--user=xxxx--socket=/tmp/dingding.logmysql.sock.X11-unix/.font-unix/sess_vutauod8dd2etpnugs0peb9845.XIM-unix/hsperfdata_root/systemd-private-4fe3e89c1d0d4336b0f8eb906b-vgauth.service.aWuBPGJ/zabbix_server_5297.pinger.ICE-unix/systemd-private-4fe3e89c1d0d4336b0f8eb906b922e7a-vmtoolsd.service-6bsXLG/zabbix_server_alerter.sockjetty-0.0.0.0-8080-xwiki-_x290d.anyd260.test-unix/zabbix_server_preprocessing.sock[root@xxxx-zabbx-12l~]#mysql_config_editorset--login-path=confdb--host=192.168.0.68--port=3306--user=xxxx--socket=/tmp/mysql.sock--password输入密码：[root@xxxx-zabbx-12l~]#mysql--login-path=confdbmysql>showdatabases;+--------------------+|数据库|+--------------------+|信息架构||配置|+--------------------+2rowsinset(0.00sec)mysql>useconfig;mysql>显示表；+----------------------------+|表_in_config|+----------------------------+|应用信息|+---------------------------+[root@xxxx-zabbx-12l~]#mysql_config_editorprint--all##查看配置信息[confdb]user=xxxxpassword=*****host=192.168.0.68socket=/tmp/mysql.sockport=3306设置定时任务&&备份脚本编写[root@uat-mysqlredis-214l~]#crontab-l301***/usr/sbin/ntpdate192.168.0.76>>/var/log/ntpdate.log108,11,15,18,22***/usr/bin/sh/root/mysql-rdb_backup.sh[root@uat-mysqlredis-214l~]#catmysql-rdb_backup.sh#!/bin/bash#数据库备份脚本#author:sean-litx2019-11-29PATH=/data/mysql/bin:/data/xxxx-java/bin:/data/xxxx-java/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/root/bindate=$(date+%Y%m%d%H)#mysql_config_editorset--login-path=rdb_home--host=192.168.0.214--port=3306--user=xxxx--socket=/tmp/mysql.sock--password#mysql_config_editorset--login-path=61-rdb_tech--host=192.168.0.61--port=3306--user=xxxx--socket=/tmp/mysql.sock--password#mysql_config_editorset--login-path=72-rdb_tech--host=192.168.0.72--port=3306--user=xxxx--socket=/tmp/mysql。sock--passwordbackupdir=/data/mysql-home_backupmkdir-pv$backupdirmysqldump--login-path=rdb_home--database-Bxxxx_dt_home_rdbxxxx_dt_business_rdb|gzip>$backupdir/rdb-home-multi-${date}.sql.gzmysqldump--login-path=72-rdb_tech--databasexxxx_library_rdb|复制代码gzip>$backupdir/rdb-tech-library-${date}.sql.gz找到${backupdir}-mtime+7-name'rdb-*'-execrm-rf{}\;##Reserve7天备份gzip-dxxxxx-${date}.sql.gz#解压
