MySQL Forums
Forum List  »  Newbie

Using skip-grant-tables in MySQL 8.0.28
Posted by: zhu guan
Date: July 04, 2022 02:02AM


I have had a Website working for 7 years and have had no problems
until a few weeks ago I replace my MySQL server with a newer one.

MySQL version (old): MySQL 5.1
MySQL version (new): MySQL 8.0.28

When I specify the skip-grant-tables in the /etc/my.cnf file.

In MySQL 5.1, it is possible for users from other networks to connect to the server.
In MySQL 8.0.28, skip-grant-tables automatically enables skip-networking, which does not allow remote connections.

Is there any easy way to maintain compatibility?




Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.