How to reset the Mysql Password in Kali linux

update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';Hello Friends We are 1ND14N H4X0R5 T34M (IHT)
Love to :- Null_Port_Govind , Mr. R@66IT , Spy-Hunter , Karate Katrina , Haxor Rahul , Grey-Noob
Lets Start:-

Question :- How to set MySql default password in kali linux for login.

Setups :-
1 Stop the mysql service with the help of this command.
 Syntax:- service mysql stop 

2 Start the MySQL (mysqld) server/daemon process with the --skip-grant-tables option so that it will not prompt for password.
Syntax:- mysqld_safe --skip-grant-tables

    [ Output:

[1] 5988
Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[6025]: started
Step # 3: Connect to mysql server using mysql client: ]

3 Connect to mysql server as the root user.
 Synatx:- mysql -u root 

4 Now we are going to select the  database with name here.
 Syntax:- use mysql 

5 Now we are going to change the password of mysql database.
  Syntax:-update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';

6 Then use  flush privileges command for reload the vaules in database memory.
Syntax:-  flush privileges;

7 Restart the mysql database with the help of this command.
Syntax:- service mysql restart 

8 Now password changed so you are able to log in mysql with your new password.By the help of this command.
Syntax:- mysql -u root -p 

 here u for user name and -p for password :) Now our work is complete :)
 Thanks for reading 
                        
                                 Jai Hind
                              Jai Bharat 

Posted in: Kali linux