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.
phillywebguy
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Thu Apr 05, 2018 4:19 pm

Required DB User Permissions?

Postby 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: 3264
Joined: Tue Aug 23, 2005 1:56 pm
Location: Kent / Sussex / Surrey border UK
Contact:

Re: Required DB User Permissions?

Postby 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: 18723
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
Contact:

Re: Required DB User Permissions?

Postby 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)
Celebrating 12-Years of Professional Joomla Support Services
- Joomla Professional Support:https://gws-desk.com -
- Joomla Specialized Hosting Solutions:https://gws-host.com -
- Member Joomla Bug Squad & J-CMS Release Team


Return to “Security in Joomla! 3.x”

Who is online

Users browsing this forum: No registered users and 7 guests