In that case you either need the users password or create a user with the same
permissions and try with that user
Olaf
-Original Message-
From: Pete Harlan [mailto:[EMAIL PROTECTED]
Sent: Tue 7/24/2007 7:30 PM
To: Mogens Melander
Cc: Carlo Sogono; mysql@lists.mysql.com
Subject: Re: su
On Tue, Jul 24, 2007 at 02:18:21AM +0200, Mogens Melander wrote:
>
> On Mon, July 23, 2007 10:19, Carlo Sogono 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
Ok, if memory serves me right, phpmyadmin use the credentials
from mysql's grant/deny schema. So when loggin into PMA, you
will have the priveleges on the server that was granted to that
user. When installing/configuring PMA, it will insist on getting
a root/privilleged users login/password to use
Mogens Melander wrote:
On Mon, July 23, 2007 10:19, Carlo Sogono 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. Hav
On Mon, July 23, 2007 10:19, Carlo Sogono 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 keep
That does not work ...
Ownership should not be an issue as all files should belong to the mysql
user anyway
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 fo