Using non-root MySQL users with C5
Permalink
Hey all!
Before I went out of town this last weekend, I created a "live" and "demo" copy of a client's content database and setup a "live" and "demo" website in IIS.
I went a bit further by creating a MySQL user for that client and giving it rights to the content databases.
However, when my teammate switched out the credentials, the site malfunctioned, so he put it back to root.
I'm just getting started looking at it, but I was hoping someone else might have done something like this already and knows what to do!
I'll post specific error messages when I start digging into it. Any general guidance is appreciated. Thanks!
Before I went out of town this last weekend, I created a "live" and "demo" copy of a client's content database and setup a "live" and "demo" website in IIS.
I went a bit further by creating a MySQL user for that client and giving it rights to the content databases.
However, when my teammate switched out the credentials, the site malfunctioned, so he put it back to root.
I'm just getting started looking at it, but I was hoping someone else might have done something like this already and knows what to do!
I'll post specific error messages when I start digging into it. Any general guidance is appreciated. Thanks!
Of course you can use any user other than root. You have to make sure it has all the rights to the database tables.
As well as "alter table" permissions. Sometimes people don't give out this access, believing it to be unnecessary - but we use it from time to time when installing/upgrading blocks, etc...
