MySQL Forums
Forum List  »  Newbie

Re: Using skip-grant-tables in MySQL 8.0.28
Posted by: Phillip Ward
Date: July 11, 2022 07:25AM

Quote

... my website is used for internal employees. The requirements for security are not very high. ...

I do not think that either your fellow Employees or your company as a whole would appreciate such a "cavalier" attitude to their Data.
Just because you're "only" on an internal network does not mean that you can just "forget" about Data Security.

"skip grants" is there for emergencies only.
It's so that you can get in and clean up the mess that somebody (or something) else made.

You must not be running any Application using this option.
If you are, it means that your database is security is non-existent and needs to be corrected. Urgently.

Quote

Is there any way to solve this problem by modifying the settings?

Short answer - No.
MySQL has [quite rightly] decided that this is a highly dangerous practice and has "slammed the door" on it.

[Get the Developers to] Fix the Application so that it works with database security instead of trying to ignore it.

Regards, Phill W.

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.