Friday, January 1, 2021

How to change root password & Reset forget mysql root password

 Q. How to recover forget root password ?

if you forget root mysql password so If you want to recover mysql password & reset new password .

Step 1 : STOP mysql service 

#systemctl stop mysqld

Step 2: 

#mysqld_safe --skip-grant-tables &  

Step 3: Login in mysql

#mysql  -uroot    ( Enter )

Step 4: Reset new password 

#use mysql   (Change database)

# update USER  set password=password('NewPassword') where User='root' ;

#flush privileges;

#quit 

Step 6: Restart mysql server and resolve issue.

#systemctl  restart mysqld

 




No comments:

Post a Comment

How to Find the Third highest salary in mysql

  set @b:=0; set @b1:=3;   # #select distinct salary,@b:=@b+1 as Row_no from emp select  * from emp where salary=( select salary from ( sele...