The mysql server is running with the --skip-grant-tables option so it cannot execute this statement

Question

Problem :

I am very new to the Linux but want to set up my MySQL databases on the Amazon ec2 instance. I have followed some directions I found about resetting a user login pass by using a --skip-grant-tables option of the MySQL. Now I want to add my user and unable to figure out now how to turn the option off.

This is what I want to do:

mysql> GRANT CREATE,SELECT,INSERT,UPDATE,DELETE ON ...my db username and pass

However I face below error:

ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

How can I turn above option off?

Answer 1

You need to just login to mysql

 mysql -u root -p

After that execute below command:

flush-privileges;

If this doesn't work then execute below command:

FLUSH PRIVILEGES;

 OR

You can make this done just by using the below steps.

[root@backups1 mysql5.7]# bin/mysqld_safe --skip-grant-tables --user=mysql

Need to connect to your mysql without the password and execute below commands:

mysql> flush privileges;

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '';

mysql> flush privileges;

Now just switch to the normal mode of mysql then connect without password.

I hope this will work for you.