meta data for this page
  •  

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
linux:databases [2015/07/13 07:50] niziaklinux:databases [2022/04/11 10:27] (current) niziak
Line 1: Line 1:
 +====== Databases ======
 +
 ===== Reset password ===== ===== Reset password =====
 Start database without permission checking: Start database without permission checking:
Line 46: Line 48:
 </code> </code>
  
 +=== Optimize databases ===
 +<code bash>
 +#!/bin/bash
 +mysqlcheck --all-databases
 +mysqlcheck --all-databases -o
 +mysqlcheck --all-databases --auto-repair
 +mysqlcheck --all-databases --analyze
 +</code>