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
