Common Problems » History » Revision 5
Revision 4 (Jessie Lee, 11/10/2017 03:39 PM) → Revision 5/7 (Jessie Lee, 11/10/2017 03:56 PM)
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
Go to top