Common Problems¶

Updated about 7 years ago by Jessie Lee

• Table of contents
• Common Problems
  • Lost Mysql root password
    • Reset method 1
    • Reset method 2 (Use method 1 first, may not work on Debian!)
  • fail2ban locked me out

Lost Mysql root password¶

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;

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

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

fail2ban locked me out¶