That does not work ...
Ownership should not be an issue as all files should belong to the mysql
Just create a second user for the individual databases (you could also just
create one account that can do everything, though I do not recommend that)
with more rights and use that account for administrative work
On 7/23/07 4:19 AM, "Carlo Sogono" <carlo.sogono@stripped> wrote:
> Is there a way for mysql to login as an administrator and "su" to a
> normal user?
> What I'd like to achieve is a way to log in to our clients' accounts (we
> are a web-hosting company) without having to use their passwords. Having
> to su keeps ownerships and stuff like that in check.
> Thanks in advance,
Center for Quantitative and Computational Biology
Columbus Children's Research Institute
700 Children's Drive