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:
GRANT all privileges on *. * to identified by ' 123 ' with GRANT OPTION;
Execute this sentence when the error:
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement mysql> 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 this statement |
This time we just need to
, 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>