Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

MySQL5.7 reported an error

2025-04-25 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Mysql configuration file directory: / etc/my.cnf

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

Skip-grant-tablesGRANT ALL PRIVILEGES ON *. * TO IDENTIFIED BY '123' WITH GRANT OPTION

Error in executing this sentence:

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

At this point, all we need

Flush privileges

In a moment, you will OK after adding users.

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)

At this time, we have successfully done it, and then log in.

If an error is reported, the following information is reported:

Error: Cannot retrieve repository metadata (repomd.xml) for repository: InstallMedia. Please 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

All we have to do is go to / etc/yum.repo.s and delete the packetxxxx.repo and redhat.repo files, and then start it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 249

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report