--001636426fb9a0ee78047e49c887
Content-Type: text/plain; charset=ISO-8859-1
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
--001636426fb9a0ee78047e49c887--
--000e0cd22f586f13af047e49d45b
Content-Type: text/plain; charset=ISO-8859-1
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
> 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
--000e0cd22f586f13af047e49d45b--
--0016e6d99a218015c8047e4b1be3
Content-Type: text/plain; charset=ISO-8859-1
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@gmail.com
Lattes: http://lattes.cnpq.br/2041067758113940
Twitter: http://twitter.com/wagnerbianchi
Skype: infodbacet
2010/1/29 Suresh Kuna
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
>
>
> > 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
>
--0016e6d99a218015c8047e4b1be3--