Skip-grant-tables under
GRANT all privileges on *. * to Helei identified by ' MANAGER ' 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 Helei identified by ' MANAGER ' 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
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 Helei identified by ' MANAGER ' 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,
Password change in skip-grant-tables mode