SQL

how to know mysql password

--Stop the MySQL process.

--Start the MySQL process with the --skip-grant-tables option.
--Start the MySQL console client with the -u root option.
--List all the users;

SELECT * FROM mysql.user;
Reset password;

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