Do the folowing mysql>show grant for root@localhost; mysql>grant all on test.* to root@localhost identified by 'password';
$mysqladmin reload --- amol sonaikar <[EMAIL PROTECTED]> wrote: > There is still error > > I did as per your say > at mysql> use test; but the error it gave was > ERROR 1044: Access denied for user: '@localhost' to > database 'test' > > even if I do something like this > mysql> mysql -u amol test -p > > ERROR 1045: Access denied for user: 'amol@localhost' > (Using password: > YES) "This result we get ". What can be way out. > Is there any > suggestions. > > Amol > > > On Thu, 21 Mar 2002 16:35:56 -0800 > "Sherwin T. Ang" <[EMAIL PROTECTED]> wrote: > >to connect to a certain database type in, > > > >mysql> use databasename; > >where databasename is the name of your database. > > > >or you can specify the database in the command line > like: > > > >mysql -uroot databasename -p > >where root is the user and databasename is the > database to > >use/connect to. > > > >Hope that helps =) > > > > > >Regards, > > > >Sherwin T. Ang > >Web Technical Administrator / Programmer > >Alchemy Solutions > >http://www.alchemy.com.ph > >Creative. Technology. > > > >Tridel Technologies, Inc. > >7th Floor Hanston Building > >Emerald Ave., Ortigas Center > >Pasig City > >Philippines > > > >Tel: (632) 634-5141/ (632) 634-5140 Local 1040 > >Fax: (632) 634-5139 > >----- Original Message ----- > >From: "amol sonaikar" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Sent: Thursday, March 21, 2002 12:17 AM > >Subject: How to connect to mysql databases > > > > > >> Hi all . I am on a Linux 6.2 client and accessing > MySql directly on > >> the server. I have connected to server using > Telnet. I am at mysql> > >> prompt > >> and when I say show databases ; it showing me the > databases over > >> there. However how can I connect to these > databases. I used connect > >> comand but it's not working > >> > >> Amol > >> --------------------------------------------- > >> http://mail.indiainfo.com > >> India's first ISO certified portal > >> Check world time at http://time.indiainfo.com > >> > >> > --------------------------------------------------------------------- > >> Before posting, please check: > >> http://www.mysql.com/manual.php (the manual) > >> http://lists.mysql.com/ (the list > archive) > >> > >> To request this thread, e-mail > <[EMAIL PROTECTED]> > >> To unsubscribe, e-mail > ><[EMAIL PROTECTED]> > >> Trouble unsubscribing? Try: > >>http://lists.mysql.com/php/unsubscribe.php > >> > >> > > > > > > --------------------------------------------- > http://mail.indiainfo.com > India's first ISO certified portal > Check world time at http://time.indiainfo.com > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __________________________________________________ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php