Common Problems » History » Revision 6
Revision 5 (Jessie Lee, 11/10/2017 03:56 PM) → Revision 6/7 (Jessie Lee, 11/10/2017 03:59 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 method 2
(Use method 1 first, may not work on Debian!)
* create file containing line @SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');@ with the following:
<pre>UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root'; new password replacing MYNewPass
FLUSH PRIVILEGES;</pre>
* start mysql with mysqld_safe mysqld --init-file=/path/to/file &
* it should be reset!
h2. fail2ban locked me out
Go to top