mysql数据备份与恢复和mysql多实例部署
1.mysql数据库备份与恢复
1.1 数据库常用备份方案
数据库备份方案：
冷备份：先把数据库服务停掉，然后拷贝数据库目录下的文件进行备份 物理备份
温备份：
热备份：数据库服务正常运行情况，直接对数据库进行备份
全量备份：全部备份
增量备份：第一次全备，第二次在第一次全备更改的基础上备份
差异备份：全部备份，差异备份-->全备
备份方案 特点
全量备份 全量备份就是指对某一个时间点上的所有数据或应用进行的一个完全拷贝。数据恢复快。备份时间长
增量备份 增量备份是指在一次全备份或上一次增量备份后，以后每次的备份只需备份与前一次相比增加和者被修改的文件。这就意味着，第一次增量备份的对象是进行全备后所产生的增加和修改的文件；第二次增量备份的对象是进行第一次增量备份后所产生的增加和修改的文件，如此类推。没有重复的备份数据，备份时间短，恢复数据时必须按一定的顺序进行
差异备份 备份上一次的完全备份后发生变化的所有文件。差异备份是指在一次全备份后到进行差异备份的这段时间内，对那些增加或者修改文件的备份。在进行恢复时，我们只需对第一次全量备份和最后一次差异备份进行恢复。
1.2 mysql备份工具mysqldump
//语法：
mysqldump [OPTIONS] database [tables ...]//备份表（多表之间用空格连接）
mysqldump [OPTIONS] --all-databases [OPTIONS]//全备
mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]//备份指定的数据库
//常用的OPTIONS：
-uUSERNAME //指定数据库用户名
-hHOST //指定服务器主机，请使用ip地址
-pPASSWORD //指定数据库用户的密码
-P# //指定数据库监听的端口，这里的#需用实际的端口号代替，如-P3307
[root@mr ~]# mysqldump -uroot -pmarui runtime tb_course > tb_course-$(date '+%Y%m%d%H%M%S').sql （备份表）
mysqldump: [Warning] Using a password on the command line interface can be insecure.
[root@mr ~]# ls
tb_course-20220731140014.sql
[root@mr ~]# vim .my.cnf（免密登录）
[mysqldump]
user=root
password=marui
（实现免密登录）
[root@mr ~]# mysqldump runtime tb_course > tb_course-$(date '+%Y%m%d%H%M%S').sql
[root@mr ~]# ls
tb_course-20220731140014.sql
tb_course-20220731140726.sql
[root@mr ~]# mysqldump --databases runtime > runtime-$(date '+%Y%m%d%H%M%S').sql（备份数据库）
[root@mr ~]# ls
runtime-20220731141008.sql
[root@mr ~]# mysqldump --all-databases > all-$(date '+%Y%m%d%H%M%S').sql（全备）
[root@mr ~]# ls
all-20220731141206.sql
[root@mr ~]# 1.3 mysql数据恢复
mysql> delete from tb_course where id = 5 or id = 6;（删除数据）
Query OK, 2 rows affected (0.01 sec)
mysql> select * from tb_course;
+----+-------------+
| id | course_name |
+----+-------------+
| 1 | Java |
| 2 | Mysql |
| 3 | Python |
| 4 | Go |
+----+-------------+
4 rows in set (0.00 sec)
mysql>
[root@mr ~]# vim .my.cnf
[mysqldump]
user=root
password=marui
[client]
user=root
password=marui
方法一：
[root@mr ~]# mysql runtime < tb_course-20220731140726.sql
mysql> show tables;
+-------------------+
| Tables_in_runtime |
+-------------------+
| tb_course |
| tb_students_info |
+-------------------+
2 rows in set (0.00 sec)
mysql> select * from tb_course;
+----+-------------+
| id | course_name |
+----+-------------+
| 1 | Java |
| 2 | Mysql |
| 3 | Python |
| 4 | Go |
| 5 | C++ |
| 6 | HTML |
+----+-------------+
6 rows in set (0.00 sec)
mysql>
方法二：
mysql> source tb_course-20220731140726.sql
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
......
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql> select * from tb_course;
+----+-------------+
| id | course_name |
+----+-------------+
| 1 | Java |
| 2 | Mysql |
| 3 | Python |
| 4 | Go |
| 5 | C++ |
| 6 | HTML |
+----+-------------+
6 rows in set (0.00 sec)
mysql> 物理备份
[root@mr ~]# cd /opt/data/
[root@mr data]# ls
auto.cnf client-key.pem ib_logfile1 mysql_bin.000003 performance_schema server-cert.pem
ca-key.pem ib_buffer_pool ibtmp1 mysql_bin.000004 private_key.pem server-key.pem
ca.pem ibdata1 mr.err mysql_bin.index public_key.pem sys
client-cert.pem ib_logfile0 mysql mysql.pid runtime
[root@mr data]# mkdir /opt/mysql_bak/
[root@mr data]# mv * /opt/mysql_bak/
[root@mr data]# ls
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.00 sec)
mysql>
[root@mr data]# mv /opt/mysql_bak/* .
[root@mr data]# ls
auto.cnf client-key.pem ib_logfile1 mysql_bin.000003 performance_schema server-cert.pem
ca-key.pem ib_buffer_pool ibtmp1 mysql_bin.000004 private_key.pem server-key.pem
ca.pem ibdata1 mr.err mysql_bin.index public_key.pem sys
client-cert.pem ib_logfile0 mysql mysql.pid runtime
[root@mr data]#
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| runtime |
| sys |
+--------------------+
5 rows in set (0.00 sec)
mysql> 1.4 差异备份
[root@mr ~]# vim /etc/my.cnf
[mysqld]
basedir = /usr/local/mysql
datadir = /opt/data
socket = /tmp/mysql.sock
port = 3306
pid-file = /opt/data/mysql.pid
user = mysql
skip-name-resolve
sql-mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
server-id=10
log-bin=mysql_bin
[root@mr ~]# systemctl restart mysqld
[root@mr ~]# mysqldump --single-transaction --flush-logs --master-data=2 --all-databases --delete-master-logs > all.chayi.sql
（--single-transaction是事务日志，--flush-logs是刷新日志，--master-data=2指定master标志符，--delete-master-logs删除主的日志）
[root@mr ~]# ls
all.chayi.sql
[root@mr ~]#
mysql> insert tb_course(course_name) values('English'),('math');
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> delete from tb_course where id = 4;
Query OK, 1 row affected (0.00 sec)
mysql> select * from tb_course;
+----+-------------+
| id | course_name |
+----+-------------+
| 1 | Java |
| 2 | Mysql |
| 3 | Python |
| 5 | C++ |
| 6 | HTML |
| 7 | English |
| 8 | math |
+----+-------------+
7 rows in set (0.00 sec)
mysql> 刷新二进制日志
[root@mr ~]# ll /opt/data/
total 123060
-rw-r-----. 1 mysql mysql 713 Jul 31 16:04 mysql_bin.000003
-rw-r-----. 1 mysql mysql 19 Jul 31 15:59 mysql_bin.index
drwxr-x---. 2 mysql mysql 8192 Jul 27 16:21 sys
[root@mr ~]# cat /opt/data/mysql_bin.index
./mysql_bin.000003
[root@mr ~]# mysqladmin -uroot -pmarui flush-logs
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
[root@mr ~]# ll /opt/data/
total 123064
drwxr-x---. 2 mysql mysql 4096 Jul 27 16:21 mysql
-rw-r-----. 1 mysql mysql 760 Jul 31 16:09 mysql_bin.000003
-rw-r-----. 1 mysql mysql 154 Jul 31 16:09 mysql_bin.000004
-rw-r-----. 1 mysql mysql 38 Jul 31 16:09 mysql_bin.index
[root@mr ~]# cat /opt/data/mysql_bin.index
./mysql_bin.000003
./mysql_bin.000004
[root@mr ~]#
[root@mr ~]# mysql < all.chayi.sql
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| runtime |
| sys |
+--------------------+
5 rows in set (0.00 sec)
mysql> use runtime;
Database changed
mysql> select * from tb_course;
+----+-------------+
| id | course_name |
+----+-------------+
| 1 | Java |
| 2 | Mysql |
| 3 | Python |
| 4 | Go |
| 5 | C++ |
| 6 | HTML |
+----+-------------+
6 rows in set (0.00 sec)
mysql>
mysql> show binlog events in 'mysql_bin.000003';
+------------------+-----+----------------+-----------+-------------+---------------------------------------+
| Log_name | Pos | Event_type | Server_id | End_log_pos | Info |
+------------------+-----+----------------+-----------+-------------+---------------------------------------+
| mysql_bin.000003 | 4 | Format_desc | 10 | 123 | Server ver: 5.7.38-log, Binlog ver: 4 |
| mysql_bin.000003 | 123 | Previous_gtids | 10 | 154 | |
| mysql_bin.000003 | 154 | Anonymous_Gtid | 10 | 219 | SET @@SESSION.GTID_NEXT= 'ANONYMOUS' |
| mysql_bin.000003 | 219 | Query | 10 | 294 | BEGIN |
| mysql_bin.000003 | 294 | Table_map | 10 | 352 | table_id: 140 (runtime.tb_course) |
| mysql_bin.000003 | 352 | Write_rows | 10 | 410 | table_id: 140 flags: STMT_END_F |
| mysql_bin.000003 | 410 | Xid | 10 | 441 | COMMIT /* xid=480 */ |
| mysql_bin.000003 | 441 | Anonymous_Gtid | 10 | 506 | SET @@SESSION.GTID_NEXT= 'ANONYMOUS' |
| mysql_bin.000003 | 506 | Query | 10 | 581 | BEGIN |
| mysql_bin.000003 | 581 | Table_map | 10 | 639 | table_id: 140 (runtime.tb_course) |
| mysql_bin.000003 | 639 | Delete_rows | 10 | 682 | table_id: 140 flags: STMT_END_F |
| mysql_bin.000003 | 682 | Xid | 10 | 713 | COMMIT /* xid=482 */ |
| mysql_bin.000003 | 713 | Rotate | 10 | 760 | mysql_bin.000004;pos=4 |
+------------------+-----+----------------+-----------+-------------+---------------------------------------+
13 rows in set (0.00 sec)
mysql>
[root@mr ~]# mysqlbinlog --stop-position=682 /opt/data/mysql_bin.000003 | mysql -uroot -pmarui
mysql: [Warning] Using a password on the command line interface can be insecure.
[root@mr ~]#
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| runtime |
| sys |
+--------------------+
5 rows in set (0.01 sec)
mysql> use runtime;
Database changed
mysql> select * from tb_course;
+----+-------------+
| id | course_name |
+----+-------------+
| 1 | Java |
| 2 | Mysql |
| 3 | Python |
| 4 | Go |
| 5 | C++ |
| 6 | HTML |
| 7 | English |
| 8 | math |
+----+-------------+
8 rows in set (0.00 sec)
mysql> 2 mysql多实例部署
1 软件下载
[root@mr ~]# cd /usr/src/
[root@mr src]# wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz2 配置用户和组并解压二进制程序至/usr/local下
[root@mr src]# id mysql
id: ‘mysql’: no such user
[root@mr src]# useradd -r -M -s /sbin/nologin mysql
[root@mr src]# ls
debug kernels mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz
[root@mr src]# tar xf mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz -C /usr/local/
[root@mr src]# cd /usr/local/
[root@mr local]# ll
total 0
drwxr-xr-x. 2 root root 6 May 19 2020 bin
drwxr-xr-x. 2 root root 6 May 19 2020 etc
drwxr-xr-x. 2 root root 6 May 19 2020 games
drwxr-xr-x. 2 root root 6 May 19 2020 include
drwxr-xr-x. 2 root root 6 May 19 2020 lib
drwxr-xr-x. 3 root root 17 Jul 6 09:33 lib64
drwxr-xr-x. 2 root root 6 May 19 2020 libexec
drwxr-xr-x. 9 root root 129 Jul 31 17:26 mysql-5.7.38-linux-glibc2.12-x86_64
drwxr-xr-x. 2 root root 6 May 19 2020 sbin
drwxr-xr-x. 5 root root 49 Jul 6 09:33 share
drwxr-xr-x. 2 root root 6 May 19 2020 src
[root@mr local]#
[root@mr local]# ln -s mysql-5.7.38-linux-glibc2.12-x86_64 mysql
[root@mr local]# ll
total 0
drwxr-xr-x. 2 root root 6 May 19 2020 bin
drwxr-xr-x. 2 root root 6 May 19 2020 etc
drwxr-xr-x. 2 root root 6 May 19 2020 games
drwxr-xr-x. 2 root root 6 May 19 2020 include
drwxr-xr-x. 2 root root 6 May 19 2020 lib
drwxr-xr-x. 3 root root 17 Jul 6 09:33 lib64
drwxr-xr-x. 2 root root 6 May 19 2020 libexec
lrwxrwxrwx. 1 root root 35 Jul 31 17:27 mysql -> mysql-5.7.38-linux-glibc2.12-x86_64
drwxr-xr-x. 9 root root 129 Jul 31 17:26 mysql-5.7.38-linux-glibc2.12-x86_64
drwxr-xr-x. 2 root root 6 May 19 2020 sbin
drwxr-xr-x. 5 root root 49 Jul 6 09:33 share
drwxr-xr-x. 2 root root 6 May 19 2020 src
[root@mr local]#
[root@mr local]# chown -R mysql.mysql mysql*
[root@mr local]# ll
total 0
drwxr-xr-x. 2 root root 6 May 19 2020 bin
drwxr-xr-x. 2 root root 6 May 19 2020 etc
drwxr-xr-x. 2 root root 6 May 19 2020 games
drwxr-xr-x. 2 root root 6 May 19 2020 include
drwxr-xr-x. 2 root root 6 May 19 2020 lib
drwxr-xr-x. 3 root root 17 Jul 6 09:33 lib64
drwxr-xr-x. 2 root root 6 May 19 2020 libexec
lrwxrwxrwx. 1 mysql mysql 35 Jul 31 17:27 mysql -> mysql-5.7.38-linux-glibc2.12-x86_64
drwxr-xr-x. 9 mysql mysql 129 Jul 31 17:26 mysql-5.7.38-linux-glibc2.12-x86_64
drwxr-xr-x. 2 root root 6 May 19 2020 sbin
drwxr-xr-x. 5 root root 49 Jul 6 09:33 share
drwxr-xr-x. 2 root root 6 May 19 2020 src
[root@mr local]# pwd
/usr/local
[root@mr local]# ls
bin etc games include lib lib64 libexec mysql mysql-5.7.38-linux-glibc2.12-x86_64 sbin share src
[root@mr local]# cd mysql
[root@mr mysql]# ls
bin docs include lib LICENSE man README share support-files
[root@mr mysql]# echo 'export PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql.sh
[root@mr mysql]# source /etc/profile.d/mysql.sh
[root@mr mysql]# ln -s /usr/local/mysql/include/ /usr/include/mysql
[root@mr mysql]# chown -R mysql.mysql /usr/include/mysql
[root@mr mysql]# ll -d /usr/include/mysql
lrwxrwxrwx. 1 mysql mysql 25 Jul 31 17:31 /usr/include/mysql -> /usr/local/mysql/include/
[root@mr mysql]#
[root@mr mysql]# vim /etc/ld.so.conf.d/mysql.conf
/usr/local/mysql/lib
[root@mr mysql]# vim /etc/man_db.conf
MANDATORY_MANPATH /usr/man
MANDATORY_MANPATH /usr/share/man
MANDATORY_MANPATH /usr/local/share/man
MANDATORY_MANPATH /usr/local/mysql/man3 创建各实例数据存放的目录
[root@mr ~]# mkdir -p /opt/data/{3306,3307,3308}
[root@mr ~]# chown -R mysql.mysql /opt/data/
[root@mr ~]# ll -d /opt/data/
drwxr-xr-x. 5 mysql mysql 42 Jul 31 17:40 /opt/data/
[root@mr ~]# tree /opt/data/
/opt/data/
├── 3306
├── 3307
└── 3308
3 directories, 0 files
[root@mr ~]# 4 初始化各实例
[root@mr ~]# mysqld --initialize --user mysql --datadir /opt/data/3306
2022-07-31T09:44:28.907046Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-07-31T09:44:29.040275Z 0 [Warning] InnoDB: New log files created, LSN=45790
2022-07-31T09:44:29.064827Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2022-07-31T09:44:29.068832Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 5f337cfb-10b5-11ed-8041-000c2950070e.
2022-07-31T09:44:29.069409Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-07-31T09:44:29.481826Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-07-31T09:44:29.481870Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-07-31T09:44:29.482251Z 0 [Warning] CA certificate ca.pem is self signed.
2022-07-31T09:44:29.507332Z 1 [Note] A temporary password is generated for root@localhost: ds=WqMxEw5B%
[root@mr ~]# echo 'ds=WqMxEw5B%' > 3306
[root@mr ~]# cat 3306
ds=WqMxEw5B%
[root@mr ~]#
[root@mr ~]# mysqld --initialize --user mysql --datadir /opt/data/3307
2022-07-31T09:45:57.115760Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-07-31T09:45:57.253402Z 0 [Warning] InnoDB: New log files created, LSN=45790
2022-07-31T09:45:57.274926Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2022-07-31T09:45:57.279112Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 93c74f09-10b5-11ed-844a-000c2950070e.
2022-07-31T09:45:57.280633Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-07-31T09:45:57.576351Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-07-31T09:45:57.576387Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-07-31T09:45:57.576764Z 0 [Warning] CA certificate ca.pem is self signed.
2022-07-31T09:45:57.596717Z 1 [Note] A temporary password is generated for root@localhost: LzXC#WG-x1Kd
[root@mr ~]# echo 'LzXC#WG-x1Kd' > 3307
[root@mr ~]# cat 3307
LzXC#WG-x1Kd
[root@mr ~]# mysqld --initialize --user mysql --datadir /opt/data/3308
2022-07-31T09:46:48.315446Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-07-31T09:46:48.483622Z 0 [Warning] InnoDB: New log files created, LSN=45790
2022-07-31T09:46:48.509017Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2022-07-31T09:46:48.517038Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: b251987e-10b5-11ed-8604-000c2950070e.
2022-07-31T09:46:48.517584Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-07-31T09:46:48.708884Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-07-31T09:46:48.708917Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-07-31T09:46:48.709402Z 0 [Warning] CA certificate ca.pem is self signed.
2022-07-31T09:46:48.811564Z 1 [Note] A temporary password is generated for root@localhost: ,L&rJy+Sm9z:
[root@mr ~]# echo ',L&rJy+Sm9z:' > 3308
[root@mr ~]# cat 3308
,L&rJy+Sm9z:
[root@mr ~]#
[root@mr ~]# ls
3306 3307 3308 anaconda-ks.cfg5 安装perl
[root@mr ~]# yum -y install perl
......
python3-rpm-macros-3-42.el8.noarch
qt5-srpm-macros-5.15.3-1.el8.noarch
redhat-rpm-config-125-1.el8.noarch
rust-srpm-macros-5-2.el8.noarch
systemtap-sdt-devel-4.7-1.el8.x86_64
unzip-6.0-46.el8.x86_64
zip-3.0-23.el8.x86_64
Complete!
[root@mr ~]# 配置配置文件/etc/my.cnf
[root@mr ~]# vim /etc/my.cnf
[mysqld_multi]
mysqld = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/bin/mysqladmin
[mysqld3306]
datadir = /opt/data/3306
port = 3306
socket = /tmp/mysql3306.sock
pid-file = /opt/data/3306/mysql_3306.pid
log-error=/var/log/3306.log
[mysqld3307]
datadir = /opt/data/3307
port = 3307
socket = /tmp/mysql3307.sock
pid-file = /opt/data/3307/mysql_3307.pid
log-error=/var/log/3307.log
[mysqld3308]
datadir = /opt/data/3308
port = 3308
socket = /tmp/mysql3308.sock
pid-file = /opt/data/3308/mysql_3308.pid
log-error=/var/log/3308.log启动各实例
[root@mr ~]# mysqld_multi start 3306
[root@mr ~]# ss -antl
State Recv-Q Send-Q Local Address:Port Peer Address:Port Process
LISTEN 0 128 0.0.0.0:22 0.0.0.0:*
LISTEN 0 80 *:3306 *:*
LISTEN 0 128 [::]:22 [::]:*
[root@mr ~]# mysqld_multi start 3307
[root@mr ~]# mysqld_multi start 3308
[root@mr ~]# ss -antl
State Recv-Q Send-Q Local Address:Port Peer Address:Port Process
LISTEN 0 128 0.0.0.0:22 0.0.0.0:*
LISTEN 0 80 *:3306 *:*
LISTEN 0 80 *:3307 *:*
LISTEN 0 80 *:3308 *:*
LISTEN 0 128 [::]:22 [::]:*
[root@mr ~]# 初始化密码
[root@mr ~]# ls
3306 3307 3308 anaconda-ks.cfg
[root@mr ~]# cat 3306
ds=WqMxEw5B%
[root@mr ~]# mysql -uroot -pds=WqMxEw5B% -S /tmp/mysql3306.sock
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.38
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> set password = password('3306');
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> exit
Bye
[root@mr ~]# mysql -uroot -p3306 -S /tmp/mysql3306.sock
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.38 MySQL Community Server (GPL)
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
[root@mr ~]# cat 3307
LzXC#WG-x1Kd
[root@mr ~]# mysql -uroot -pLzXC#WG-x1Kd -S /tmp/mysql3307.sock
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.38
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> set password = password('3307');
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> exit
Bye
[root@mr ~]# mysql -uroot -p3307 -S /tmp/mysql3307.sock
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.38 MySQL Community Server (GPL)
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
[root@mr ~]# cat 3308
,L&rJy+Sm9z:
[root@mr ~]# mysql -uroot -p',L&rJy+Sm9z:' -S /tmp/mysql3308.sock
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.38
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> set password = password('3308');
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> exit
Bye
[root@mr ~]# mysql -uroot -p'3308' -S /tmp/mysql3308.sock
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.38 MySQL Community Server (GPL)
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
