Pages
Archives
Categories
Blogroll
Live Traffic Feed.
Tag Archives: mysql
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
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