Retrieve And Update Mysql username and Password with SQL

List all the users:

SELECT * FROM mysql.user;

Reset password;

UPDATE mysql.user SET Password=PASSWORD('[password]') WHERE User='[username]';

Advertisements