miniBB ® miniBB®
miniBB Support Forums
 | Forums | Register | Reply | Search | Statistics | Manual |
The Other miniBB Support Forums / The Other /   

Database privileges for miniBB forum

Author kuopassa
Registered
#1 | Posted: 23 Jul 2013 06:47 
In cPanel there's an option to place specific privileges to the miniBB's database user. Here's a screenshot of available options:

mySQL privileges in cPanel

Can Paul or someone who knows more about this please confirm what are the privileges that miniBB needs? I'd say only these are needed:

CREATE
DELETE
INSERT
SELECT
UPDATE


Are there more?

Author Paul
Lead Developer
#2 | Posted: 23 Jul 2013 11:41 
You have mentioned all privileges miniBB needs.

I would also add 'Lock Tables' privilege - some mySQL dumps may contain this command.
Could be useful in the future - and it's not critical in a security term.

It's a good idea to limit mySQL rights to the account which is used by forum. Despite in most cases this account is assigned to 'localhost' and could not be used in remote access, some possible new mySQL-injections could protect your database from unwanted actions.

Author kuopassa
Registered
#3 | Posted: 23 Jul 2013 12:32 
Okey, excellent. Thanks for clarifying this. :-)

The Other miniBB Support Forums / The Other / Database privileges for miniBB forum Top

Your Reply Click this icon to move up to the quoted message

 Short link for this topic:

 ?
You are welcome to post anonymously, by entering a nickname with no password (if the similar Username has not been taken yet), or by leaving both fields empty. If you have a forums account, you can also sign in from this page without posting a message, or sign in and post at once.


Before posting, make sure your message is compliant with our forum posting rules. If not, it may be locked or deleted with no explanation.
 
miniBB Support Forums Powered by Forum Software miniBB ® Features  Requirements  Demo  Download  Showcase  Gallery of Arts
Compiler  Premium Extensions  Premium Support  License  Contacts
Check out the Captcha add-on: protect your miniBB-forums from the automated spam and flood.
Captcha Addon for miniBB