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

Transferred from: http://www.cnblogs.com/iosdev/archive/2013/07/15/3190431.html

MySQL configuration file directory:/ETC/MY.CNF

The root password is empty when the following sentence in the configuration file:

skip-grant-tables

GRANT all privileges on *. * to identified by ' 123 ' with GRANT OPTION;

Execute this sentence when the error:

ERROR 1290 (HY000): The MySQL server isrunning with the --skip-grant-tables option so it cannot execute this statementmysql> GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY ‘123‘ WITH GRANT OPTION;ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute thisstatement

This time we just need to

flush privileges

, the user is OK to add,

mysql> flush Privileges;
Query OK, 0 rows affected (0.01 sec)

Mysql> Grant all privileges on *. * to identified by ' 123 ' with GRANT OPTION;
Query OK, 0 rows Affected (0.00 sec)

This time we have successfully done, and then log on to it.

If the error message is as follows:

Error:cannot Retrieve repository metadata (Repomd.xml) for Repository:installmedia. Verify its path and try again
You could try using--skip-broken to work around the problem
You could try Running:rpm-va--nofiles--nodigest

We just have to/etc/yum.repo.s under the Packetxxxx.repo and Redhat.repo two files removed, and then start on it,

ERROR 1290 (HY000): The MySQL server is running with the--skip-grant-tables option so it cannot execute this statemen< /p>