MySQL Forums
Forum List  »  General

Re: about priveleges
Posted by: Peter Brawley
Date: July 29, 2015 09:52AM

First, root shouldn't have web access. Create another user with exactly the privileges required to manage the web database & app.

Second, create another user for the webapp's database connection with exactly the privileges required by the app itself.

Third, track & autheenticate individual webapp users with another table altogether, not the mysql.user table.

Options: ReplyQuote


Subject
Written By
Posted
July 29, 2015 07:34AM
Re: about priveleges
July 29, 2015 09:52AM
July 29, 2015 11:00AM
July 30, 2015 09:28AM


Sorry, you can't reply to this topic. It has been closed.

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.