How to change USERNAME And PASSWORD of MySQL using query?

Just use this query:
UPDATE mysql.user SET user='root',
password=PASSWORD('1234') WHERE user='root';
FLUSH PRIVILEGES;

Post a Comment

0 Comments