Answers for "how to change mysql root password for window"

SQL

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

mysql set root password

use mysql;

update user set authentication_string=PASSWORD("mynewpassword") where User='root';

flush privileges;

quit

Posted by: Guest on March-10-2020

Source

how to change mysql root password in windows 10

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

Posted by: Guest on October-14-2020

Source

Code answers related to "how to change mysql root password for window"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

Answers for "how to change mysql root password for window"

Code answers related to "how to change mysql root password for window"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us