MySQL Forums
Forum List  »  Newbie

Re: Using skip-grant-tables in MySQL 8.0.28
Posted by: zhu guan
Date: July 05, 2022 09:19PM

>Did you read https://dev.mysql.com/doc/refman/8.0/en/server-options.html#option_mysqld_skip-grant-tables
>
>Running an app with --skip-grant-tables is just not sound. The grant tables are required for normal operation. You will need to rethink your app.
Thank you for your reply.I have read the link you sent.I also know that as of MySQL 8.0.3, skip-grant-tables enabled skip-networking, which automatically doesn’t allow remote connections.Just like what you said, the change is just sound, but my website is used for internal employees. The requirements for security are not very high. My customers want to upgrade the database from 5.1 to 8.0.28 at the minimum cost.Re-design will increase a lot of costs.I'm sorry I didn’t explain the background. Is there any way to solve this problem by modifying the settings?

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.