Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Installing SilverStripe /

Getting SilverStripe up and running on your computer and on your web server.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

MySQL user privileges settings for Silverstripe


Reply


7 Posts   2447 Views

Avatar
HansR

Community Member, 140 Posts

20 February 2009 at 8:10pm

I just had Silverstripe screw up on me on a test server because I didn't give its MySQL username enough privileges on the database. This happened after I installed it. What are the minimum privileges that are required? I just enabled everything except the administration privileges, and now it works fine.

Avatar
bennettpr

Community Member, 37 Posts

3 August 2009 at 10:04am

any response on this?
From a security perspective I'd like to know the minimum privilege level I can run a MySQL user as once the site has been fully developed.

Create, insert, update, delete?

Paul

Avatar
HansR

Community Member, 140 Posts

3 August 2009 at 10:39am

No idea what the minimum privileges are, sorry. I just made sure that it didn't have admin privileges, and left it at that.

Hans

Avatar
Tama

Community Member, 132 Posts

2 June 2010 at 1:51pm

The system admin who is setting up our production website has asked me exactly the same question.

Any ideas from anyone?

Avatar
HansR

Community Member, 140 Posts

2 June 2010 at 2:16pm

On my test server, the Silverstripe database user has the following privileges:
SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER.

That works fine for me. Silverstripe should complain if it doesn't have adequate permissions for an operation.

Hans

Avatar
bennettpr

Community Member, 37 Posts

2 June 2010 at 2:25pm

Hi Tama,

Running the user account with all privileges during development is required as the ORM will create and alter tables as your models changes.

It *should* then be OK to drop the privilege level down to select, insert, update, delete as during production SilverStripe won't be making any structural changes to tables.

Avatar
Tama

Community Member, 132 Posts

23 June 2010 at 10:41am

Hi there

Thank you for the replies, I'll let our sysadmin know.

Cheers
Tama