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_safe --skip-grant-tables@ 
* go into mysql console 
* type FLUSH PRIVILEGES; 
* SET PASSWORD FOR root@'localhost' = PASSWORD('password');

h3. Reset method 2 

* create file containing the following: 
<pre>UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;</pre>
* start mysql with mysqld_safe --init-file=/path/to/file &
* it should be reset!

h2. fail2ban locked me out