List:General Discussion« Previous MessageNext Message »
From:Wagner Bianchi Date:January 29 2010 10:29am
Subject:Fwd: how to switch between users
View as plain text  
On other SGBDs you can issue:

sqlplus> conn other_user;

But, using MySQL you can't do it...start new connection.

--
Wagner Bianchi - Web System Developer and Database Administrator
Phone: (31) 8654-9510 / 3272-0226
E-mail: wagnerbianchijr@stripped
Lattes: http://lattes.cnpq.br/2041067758113940
Twitter: http://twitter.com/wagnerbianchi
Skype: infodbacet


2010/1/29 Suresh Kuna <sureshkumarilu@stripped>

Hi Murali,
> We can switch to another user only by a new connection and not possible in
> mysql prompt.
>
> Thanks
> Suresh Kuna
> MySQL DBA
>
> On Fri, Jan 29, 2010 at 2:24 PM, muralikrishna g
> <muralikrishna4g@stripped>wrote:
>
> > i am working on my pc with mysql-5.0.27-community-nt
> > i have created users by using create user and i given some privileges,
> but
> > i
> > dont know how to switch between users on mysql command line, please help
> me
> > regarding this..
> > thanks in advance
> >
>
>
>
> --
> Thanks
> Suresh Kuna
> MySQL DBA
>

Thread
Fwd: how to switch between usersWagner Bianchi29 Jan