Re: su-like functionality

2007-07-24 Thread Pete Harlan
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 web-hosting

RE: su-like functionality

2007-07-24 Thread Stein, Olaf
-like functionality 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

su-like functionality

2007-07-23 Thread Carlo Sogono
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

Re: su-like functionality

2007-07-23 Thread Olaf Stein
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

Re: su-like functionality

2007-07-23 Thread Mogens Melander
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 keeps

Re: su-like functionality

2007-07-23 Thread Carlo Sogono
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.

Re: su-like functionality

2007-07-23 Thread Mogens Melander
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