Required DB User Permissions?

Discussion regarding Joomla! 3.x security issues.

Moderators: mandville, 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.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Locked
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?
Top
gws
Joomla! Champion
Joomla! Champion
Posts: 5922
Joined: Tue Aug 23, 2005 1:56 pm
Location: South coast, UK
Contact:
Contact gws

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.
Top
User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 20652
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ Germany/ S'pore/Bogor/ North America
Contact:
Contact leolam

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 Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
Top
Locked

Return to “Security in Joomla! 3.x”