Archive for the ‘Mysql’ Category

List all the users:

SELECT * FROM mysql.user;

Reset password;

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

Advertisements