• Register
0 votes
158 views

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?

7 5 2
3,870 points

Please log in or register to answer this question.

1 Answer

0 votes

Solution :

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.

9 7 4
38,600 points

Related questions

0 votes
1 answer 654 views
654 views
Problem : I am facing a strange MySQL error may be it is related to the database's read-only flag. The Web application that is using the MySQL is running on Debian 7.9. It was running well but suddenly started attempting to access the application powered website ... - SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --read-only option so it cannot execute this statement
asked Nov 20, 2019 peterlaw 6.9k points
0 votes
1 answer 187 views
187 views
Problem : I get mysql error help the mysql server is running with the --secure-file-priv option so it cannot execute this statement
asked Nov 7, 2019 peterlaw 6.9k points
1 vote
1 answer 4 views
4 views
Problem: Facing serious issue during MySQL installation. Fatal error: can't open and lock privilege tables: table 'mysql.host' doesn't exist.
asked Mar 26 PkGuy 13.1k points
0 votes
1 answer 2 views
2 views
Problem: When Ubuntu installed, i wanted to open my D drive (ntfs) but get the following error: The ntfs partition is in an unsafe state my question is: does exist any command for mounting partition in the form of read/write.
asked Mar 20 ummesalma 21.9k points
0 votes
1 answer 6 views
6 views
Problem: How to fix this Error 2002 (hy000): can't connect to local mysql server through socket '/tmp/mysql.sock' (38).
asked Apr 1 rakib1 50.4k points
1 vote
1 answer 3 views
3 views
Problem : I'm new to Linux and MySQL, I currenty have a LAMP, running on Ubuntu 14.04, yesterday everything was fine, but today my MYSQL is not working.I get the following error message: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) I have no ideia about what to do!
asked Mar 31 Shovo210 13.2k points
0 votes
1 answer 93 views
93 views
Problem : My problem kicked off when I was unable to log in as the root any more on the mysql install. I was trying to run mysql without the passwords turned on however when I ran my below command : # mysqld_safe --skip-grant-tables & I never got my prompt back. ... socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
asked Jan 4, 2020 alecxe 7.5k points
0 votes
1 answer 46 views
46 views
Problem : My problem started with me when I was unable to log in as root any more on the mysql install. I was trying to run mysql without passwords turned on... but whenever I ran the below command # mysqld_safe --skip-grant-tables & I would never get my prompt back ... socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
asked Dec 27, 2019 alecxe 7.5k points
1 vote
1 answer 8 views
8 views
Problem : I am trying to add one manager in Docker swarm. But it is showing me the below error. Cannot connect to the Docker daemon. Is the docker daemon running on this host? Any ideas on what I need to do to fix this? Thanks!
asked Mar 31 Shovo210 13.2k points
0 votes
1 answer 74 views
74 views
Problem : After I tried to update my Docker version to 0.8.0, I face an error message while I try to enter sudo docker version as below : Client version: 0.8.0 Go version (client): go1.2 Git commit (client): cc3a8c8 2020 ... 12:55:57 initserver: open /var/lib/docker/aufs/layers/cf2414da53f9bcfaa48bc3d58360d7f1cfd3784e4fe51fbef95197709dfc285d: no such file or directory How can I resolve the issue?
asked Jan 3, 2020 alecxe 7.5k points