h1. Common Problems

{{lastupdated_at}} by {{lastupdated_by}}

{{>toc}}


h2. Lost Mysql root password

h3. Reset method 1

* stop mysql
* start mysql on command line with @ mysqld --skip-grant-tables@ 
* go into mysql console 
* type FLUSH PRIVILEGES; 
* SET PASSWORD FOR root@'localhost' = PASSWORD('password');

h3. Reset method 2 (Use method 1 first, may not work on Debian!)

* create file containing line @SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');@ with the new password replacing MYNewPass
* start mysql with mysqld --init-file=/path/to/file &
* it should be reset!

h2. fail2ban locked me out