zh:notes:install_mysql
差别
这里会显示出您选择的修订版和当前版本之间的差别。
| 两侧同时换到之前的修订记录 前一修订版 后一修订版 | 前一修订版 | ||
|
zh:notes:install_mysql [2022/06/05 15:28] pzczxs [Configuring MySQL 8 Server on a CentOS 8] |
zh:notes:install_mysql [2023/07/30 17:38] (当前版本) pzczxs [Remove binlog files] |
||
|---|---|---|---|
| 行 66: | 行 66: | ||
| </code> | </code> | ||
| + | ===== Firewall Configuration ===== | ||
| + | [[:zh:notes:centos_mysql_remote|MySQL Remote Access]] | ||
| + | |||
| + | ===== Remove binlog files ===== | ||
| + | The location of binlog files can be shown by using the following commands. | ||
| + | <code bash> | ||
| + | > mysql -uroot -p | ||
| + | > show binary logs; | ||
| + | </code> | ||
| + | |||
| + | The binlog files can be removed by using the following commands. | ||
| + | <code bash> | ||
| + | > RESET MASTER; // remove all binlog files. | ||
| + | > PURGE MASTER LOGS to "binlog.000100"; // remove all binlog files before "binlog.000100" | ||
| + | > PURGE MASTER LOGS BEFORE "2023-07-28 22:00:00"; // remove all binlog files before 2023-07-28 22:00:00 | ||
| + | </code> | ||
| + | |||
| + | ~~DISCUSSION:closed~~ | ||
zh/notes/install_mysql.1654414090.txt.gz · 最后更改: 2022/06/05 15:28 由 pzczxs