Project

General

Profile

Actions

Common Problems » History » Revision 5

« Previous | Revision 5/7 (diff) | Next »
Jessie Lee, 11/10/2017 03:56 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 (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

Updated by Jessie Lee over 6 years ago · 5 revisions

Also available in: PDF HTML TXT

Go to top