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, 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.