Why grant all privileges for MySQL user when making Wordpress DB
-
Christine Giglio
MemberIn the article:
http://vpsbible.com/content-management/wordpress-subversion/under
Create a MySQL Database for WordPress from the Command LineIt says to create a user granting them all privileges (ie GLOBAL) which will give that user permission across all databases (am I correct?). Is there a specific reason this is done?
I have been creating mine with restrictive rights meaning userA has almost full permissions (I uncheck Grant under Administration the rest privileges are checked) to only userAdatabase. Each database has it's own user that only has access to that single database.
Am I doing it wrong? It hasn't caused trouble so far but will it in the future?
Or is my setup the work of a paranoid person? ;-)Thank you for any advice/cookies in advance.
Posted 1 year ago # -
that assumes the db administrator is also the main VPS admin, Christine .. for any other VPS user, absolutely, they should have restricted permissions (and that could be clearer, hmmn).
will depend from case to case but the golden rule as with all permissions is not to grant more than needed, use site-specific dbs and ensure db users have rights only to 1 databases, even if that means a user with access to several dbs has different usernames.
Posted 1 year ago #
Reply
You must log in to post.
Want HTML?
a blockquote code em strong ul ol liPlace code between backticks `codeHere`
You've got it.