4571 Posts in 1384 Topics by 1376 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 2098 Views |
-
MySQL user privileges settings for Silverstripe
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.
-
Re: MySQL user privileges settings for Silverstripe
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
-
Re: MySQL user privileges settings for Silverstripe
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
-
Re: MySQL user privileges settings for Silverstripe
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?
-
Re: MySQL user privileges settings for Silverstripe
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
-
Re: MySQL user privileges settings for Silverstripe
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.
-
Re: MySQL user privileges settings for Silverstripe
23 June 2010 at 10:41am
Hi there
Thank you for the replies, I'll let our sysadmin know.
Cheers
Tama
| 2098 Views | ||
|
Page:
1
|
Go to Top |
