Project

General

Profile

Actions

Common Problems » History » Revision 4

« Previous | Revision 4/7 (diff) | Next »
Jessie Lee, 11/10/2017 03:39 PM


Common Problems

Updated over 6 years ago by Jessie Lee

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

  • 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

Updated by Jessie Lee over 6 years ago · 4 revisions

Also available in: PDF HTML TXT

Go to top