Answers for "how to change user and password of my sql"

mysql change user password

SET PASSWORD FOR 'user-name'@'localhost' = PASSWORD('NEW_USER_PASSWORD');FLUSH PRIVILEGES;

Posted by: Guest on April-28-2020

mysql change password

UPDATE mysql.user SET authentication_string=PASSWORD("rootpass") WHERE User='root';

Posted by: Guest on April-21-2021

Code answers related to "how to change user and password of my sql"