Project

General

Profile

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