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
How to connect to mysql databases
amol, Thursday, March 21, 2002, 10:17:53 AM, you wrote: as Hi all . I am on a Linux 6.2 client and accessing MySql directly on as the server. I have connected to server using Telnet. I am at mysql as prompt as and when I say show databases ; it showing me the databases over as there. However how can I connect to these databases. I used connect as comand but it's not working Use following commant: USE database_name; You can also use connection string: mysql -u your_user -p your_database as Amol -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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
Re: How to connect to mysql databases
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
Re: How to connect to mysql databases
what is the output of show database command --- amol sonaikar [EMAIL PROTECTED] wrote: 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 __ 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
Re: How to connect to mysql databases
Do the folowing mysqlshow grant for root@localhost; mysqlgrant 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