mysql use root password code example
Example 1: change root password mysql
#First Login with administrative account (Even root itself)
mysql> use mysql;
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD("NewPassword");
mysql> flush privileges;
#Now quit and login
mysql> quit
mysql -u root -p
#Click enter and It will prompt you to enter password
#Just to be safe you should also still try to log in without entering a password
Example 2: mysql set root password
use mysql;
update user set authentication_string=PASSWORD("mynewpassword") where User='root';
flush privileges;
quit