Jump to:

4950 Posts in 13981 Topics by 1490 members

Installing SilverStripe

SilverStripe Forums » Installing SilverStripe » MySQL user privileges settings for Silverstripe

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

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

Page: 1
Go to End
Author Topic: 2371 Views
  • HansR
    Avatar
    Community Member
    140 Posts

    MySQL user privileges settings for Silverstripe Link to this post

    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.

  • bennettpr
    Avatar
    Community Member
    37 Posts

    Re: MySQL user privileges settings for Silverstripe Link to this post

    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

  • HansR
    Avatar
    Community Member
    140 Posts

    Re: MySQL user privileges settings for Silverstripe Link to this post

    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

  • Tama
    Avatar
    Community Member
    130 Posts

    Re: MySQL user privileges settings for Silverstripe Link to this post

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

    Any ideas from anyone?

  • HansR
    Avatar
    Community Member
    140 Posts

    Re: MySQL user privileges settings for Silverstripe Link to this post

    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

  • bennettpr
    Avatar
    Community Member
    37 Posts

    Re: MySQL user privileges settings for Silverstripe Link to this post

    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.

  • Tama
    Avatar
    Community Member
    130 Posts

    Re: MySQL user privileges settings for Silverstripe Link to this post

    Hi there

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

    Cheers
    Tama

    2371 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.