This may be a dumb question but here goes anyway.
I've been a Jodohost user/reseller for several years and have only recently come across this problem because we are changing the CMS we use and I'm not quite sure how to handle it.
If I have multiple databases that all use the same database user as the administrator, then I delete one of those databases, the user gets deleted too. I discovered this by accident when deleting a database for a site we were doing the CMS changeover for and all the other sites went down too because all the sudden there was no valid database user.
What's the easiest way around this? This is for MySQL/Linux .
Thanks.
Mark
I've been a Jodohost user/reseller for several years and have only recently come across this problem because we are changing the CMS we use and I'm not quite sure how to handle it.
If I have multiple databases that all use the same database user as the administrator, then I delete one of those databases, the user gets deleted too. I discovered this by accident when deleting a database for a site we were doing the CMS changeover for and all the other sites went down too because all the sudden there was no valid database user.
What's the easiest way around this? This is for MySQL/Linux .
Thanks.
Mark