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
Subject
Written By
Posted
Using skip-grant-tables in MySQL 8.0.28
July 04, 2022 02:02AM
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.