So you lock yourself out of MySQL and see the following error when you try and change the password using the –skip-grant-tables option
mysql> GRANT ALL PRIVILEGES ON *.* TO “w000t@%” IDENTIFIED BY ‘passwordthinggy’;
ERROR 1290 (HY000): The MySQL server is running with the –skip-grant-tables option so it cannot execute this statement
Its because the grant tables still have to be loaded – if you want to change the password so you’ll need to
FLUSH PRIVILEGES;
Before you issue your grant statement.
Tags: MySQL