Project

General

Profile

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