Using skip-grant-tables in MySQL 8.0.28

[zhu guan]

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