Differences

This shows you the differences between two versions of the page.

--- wiki:mysql [2024/04/21 12:52] – 5.152.82.90
+++ wiki:mysql [2024/05/08 08:19] (current) – 5.152.82.90
@@ Line 24: / Line 24: @@
 **Cut single table from dump**
 <code>sed -n '/^-- Table structure for table `licenses`/,/^--Table structure for table /p' database.sql > table.sql</code>
+=====Useful commands====
+**Purge Binlog**
+<code>
+BINLOG_FILE=$(mysql -e "SHOW MASTER STATUS"|tail -n1|awk '{print $1}')
+mysql -e "PURGE BINARY LOGS TO '${BINLOG_FILE}'"</code>
+**DB Size**
+<code>mysql -e "SELECT table_schema, SUM(data_length+index_length)/1024/1024 FROM information_schema.TABLES GROUP BY table_schema"</code>
+**Secure Installation**
+<code>
+mysql -e "UPDATE mysql.user SET Password = PASSWORD('NEWPASSWORD') WHERE User = 'root'"
+mysql -e "DROP USER ''@'localhost'"
+mysql -e "DROP USER ''@'$(hostname)'"
+mysql -e "DROP DATABASE test"
+mysql -e "FLUSH PRIVILEGES"
+</code>

Trace: • kubernetes