How to Unlock a Root User in MySql

This video was made with Clipchamp

To unlock the ‘root’ user account issue the following sql statement:
alter user ‘root’at the rate’localhost’ account unlock;
you can use the following sql query to see if the mysql root user accout is locked or not:

select user, account_locked
from mysql.user
where user=’root’;
if you want to reset root user password
alter user ‘root’ at the rate’ localhost’ identified by ‘new_password’;