A script for automatically backing up MySQL
Students of background development and operation and maintenance are certainly familiar with MySQL backup. Regular online database backup is necessary, and this process is generally automatic. This paper will introduce a shell script, which has the function of automatically backing up MySQL and automatically clearing expired backup data
Back ...
Added by shan111 on Thu, 04 Nov 2021 03:08:22 +0200
Day 04 ssl encrypted connection and password plug-in
Connect MySQL instance
Connect via local socket mysql -S /tmp/mysql.sock -u root -pConnect via TCP/IP mysql -u tbs -pTbs_SOft!Connect through my.cnf configuration file
-- Production view socket Where are the files
tbs@localhost:[(none)]>show variables like "socket%";
+---------------+-----------------------------+
| Variable_name | Value ...
Added by capitala on Sun, 24 Oct 2021 17:39:50 +0300