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: wagnerbianch...@gmail.com Lattes: http://lattes.cnpq.br/2041067758113940 Twitter: http://twitter.com/wagnerbianchi Skype: infodbacet 2010/1/29 Suresh Kuna <sureshkumar...@gmail.com> 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 > <muralikrishn...@gmail.com>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 >