mysql root recover password code example

Example 1: mysql root permission denied lost

GRANT ALL ON *.* TO 'user'@'localhost' with GRANT OPTION;

Example 2: remove root password mysql

mysqladmin -u root -pType_in_your_current_password_here password ''