MySQL Forums
Forum List  »  Newbie

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

Hi,

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?

Regards,

--

gzh

Options: ReplyQuote




Sorry, only registered users may post in this forum.

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.