Common Problems » History » Revision 4
Revision 3 (Jessie Lee, 11/10/2017 03:39 PM) → Revision 4/7 (Jessie Lee, 11/10/2017 03:39 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 h3.Reset method 2
* 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