Required DB User Permissions?

Discussion regarding Joomla! 3.x security issues.

Moderators: Bernard T, mandville, fcoulter, PhilD, General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant / FPA - If you are serious about wanting help, you will use this tool to help you post.
Post Reply
phillywebguy
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Thu Apr 05, 2018 4:19 pm

Required DB User Permissions?

Post by phillywebguy » Wed Apr 11, 2018 3:00 pm

I'm looking for some sort of guide on best practices for using only the necessary permissions for the (MySQL) database user. I could easily just grant everything, but I only want to grant what is necessary. Any resources I can reference?

gws
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3452
Joined: Tue Aug 23, 2005 1:56 pm
Location: South coast, UK
Contact:

Re: Required DB User Permissions?

Post by gws » Wed Apr 11, 2018 3:28 pm

The problem is necessary to whom? As long as you are using a strong password for the DB granting all privileges shouldn't be a problem to you.You can restrict access to the DB in your cpanel to only your installation ie no external access.

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 19105
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
Contact:

Re: Required DB User Permissions?

Post by leolam » Wed Apr 11, 2018 3:32 pm

You should just grant everything without any restrictions. As gws mentioned just make sure you have a strong password (use the 'generator in cPanel) with 16 digits and copy this to a safe place!

Leo 8)
Joomla's #1 Professional Support Provider:
-> Joomla Professional Support: https://gws-desk.com -
-> Joomla Specialized Hosting Solutions: https://gws-host.com -
Member Joomla Bug Squad & Joomla CMS Release Team


Post Reply

Return to “Security in Joomla! 3.x”