Common Problems¶

Updated about 7 years ago by Jessie Lee

• Table of contents
• Common Problems
  • Lost Mysql root password
    • Reset method 1
  • 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;

h3.Reset method 2

• 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¶