MySQL Forums
Forum List  »  Newbie

Re: Accessing the Database from Other Machines on the LAN
Posted by: Peter Brawley
Date: August 08, 2017 09:41AM

Don't create multiple root users. And, user root is usually best defined just on localhost, more secure.

An app running against a DB needs its own defined user(s), known only to the app. Users of the app should be defined in your own user table, defining where they can log in from and which app user's privs they will enjoy.

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.