Tag Archives: linux

InnoDB Corruption and Recovery

Databases get corrupted for many reasons. In my case, ourĀ  hard drive went down during writes to the database from a power failure. InnoDB corruption can causeĀ all of the databases running on that server to become inaccessible. My server is … Continue reading

Posted in Linux, MySQL | Tagged , | Leave a comment

Set Password Policy in Mysql 5.6

——————————————————————————————- 1) INSTALL PLUGIN loads the plugin, and also registers it in the mysql. plugins table to cause the plugin to be loaded for each subsequent normal server startup. ——————————————————————————————- mysql> INSTALL PLUGIN validate_password SONAME ‘validate_password.so’; ——————————————————————————————- 2) Edit my.cnf … Continue reading

Posted in Linux, MySQL | Tagged , | Leave a comment