Answers for "alter mysql root user password"

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

Posted by: Guest on February-01-2021

reset mysql root password using alter user statement

ALTER USER 'root'@'localhost' IDENTIFIED BY 'my_password';

Posted by: Guest on June-23-2021

Code answers related to "alter mysql root user password"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "alter mysql root user password"

Code answers related to "alter mysql root user password"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "alter mysql root user password"

Code answers related to "alter mysql root user password"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us