Re: connect to mySQL without database
Probably I was late in replying (just busy with some stupid work). In all the API if you dont specify the dbname in the mysql_connect() functions. In C the connection function is mysql_real_connect(), in PHP its mysql_pconnect(), donno about other APIs. You can get a list of dbs by issueing "show databases" SQL. One thing you have to make sure is that you have the permission :) regards, karam --- Michael Seele <[EMAIL PROTECTED]> wrote: > oh! sorry! i use java! > > [EMAIL PROTECTED] schrieb am 09.08.2004 14:33: > > >Not which natural language, which programming > language? We need to know in > >order to help you. C, C++, Java, Perl, PHP, > Python... The answer will > >differ. > > > >Alec > > > > > > > > > >Michael Seele <[EMAIL PROTECTED]> > >09/08/2004 13:20 > > > >To > >[EMAIL PROTECTED] > >cc > > > >Subject > >Re: connect to mySQL without database > > > > > > > > > > > > > >i use mySQL english version! why? > > > >Karam Chand schrieb am 09.08.2004 14:13: > > > > > > > >>Yes. > >> > >>Which language you are using? > >> > >>Regards, > >>Karam > >> > >>--- Michael Seele <[EMAIL PROTECTED]> wrote: > >> > >> > >> > >> > >> > >>>hi, > >>>is it possible to connect to a mySQL-Server > without > >>>entering a database > >>>and then check all available databases? > >>>thx mseele > >>> > >>>-- > >>>G & H Softwareentwicklung GmbH Tel.: > >>>+49(0)7451/53706-20 > >>>Robert-Bosch-Str. 23 Fax: > >>>+49(0)7451/53706-90 > >>>D-72160 Horb a.N. > >>>http://www.guh-software.de > >>> > >>> > >>>-- > >>>MySQL General Mailing List > >>>For list archives: http://lists.mysql.com/mysql > >>>To unsubscribe: > >>> > >>> > >>> > >>> > >>> > >>http://lists.mysql.com/[EMAIL PROTECTED] > >> > >> > >> > >> > >>> > >>> > >> > >> > >>__ > >>Do you Yahoo!? > >>Yahoo! Mail Address AutoComplete - You start. We > finish. > >>http://promotions.yahoo.com/new_mail > >> > >> > >> > >> > >> > > > > > > > > -- > G & H Softwareentwicklung GmbH Tel.: > +49(0)7451/53706-20 > Robert-Bosch-Str. 23 Fax: > +49(0)7451/53706-90 > D-72160 Horb a.N. > http://www.guh-software.de > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: connect to mySQL without database
Michael Seele <[EMAIL PROTECTED]> wrote: > is it possible to connect to a mySQL-Server without entering a database > and then check all available databases? Sure, SHOW DATABASES is it: http://dev.mysql.com/doc/mysql/en/Show_database_info.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: connect to mySQL without database
oh! sorry! i use java! [EMAIL PROTECTED] schrieb am 09.08.2004 14:33: Not which natural language, which programming language? We need to know in order to help you. C, C++, Java, Perl, PHP, Python... The answer will differ. Alec Michael Seele <[EMAIL PROTECTED]> 09/08/2004 13:20 To [EMAIL PROTECTED] cc Subject Re: connect to mySQL without database i use mySQL english version! why? Karam Chand schrieb am 09.08.2004 14:13: Yes. Which language you are using? Regards, Karam --- Michael Seele <[EMAIL PROTECTED]> wrote: hi, is it possible to connect to a mySQL-Server without entering a database and then check all available databases? thx mseele -- G & H Softwareentwicklung GmbH Tel.: +49(0)7451/53706-20 Robert-Bosch-Str. 23 Fax: +49(0)7451/53706-90 D-72160 Horb a.N. http://www.guh-software.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail -- G & H Softwareentwicklung GmbH Tel.: +49(0)7451/53706-20 Robert-Bosch-Str. 23 Fax: +49(0)7451/53706-90 D-72160 Horb a.N. http://www.guh-software.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: connect to mySQL without database
i use mySQL english version! why? Karam Chand schrieb am 09.08.2004 14:13: Yes. Which language you are using? Regards, Karam --- Michael Seele <[EMAIL PROTECTED]> wrote: hi, is it possible to connect to a mySQL-Server without entering a database and then check all available databases? thx mseele -- G & H Softwareentwicklung GmbH Tel.: +49(0)7451/53706-20 Robert-Bosch-Str. 23 Fax: +49(0)7451/53706-90 D-72160 Horb a.N. http://www.guh-software.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail -- G & H Softwareentwicklung GmbH Tel.: +49(0)7451/53706-20 Robert-Bosch-Str. 23 Fax: +49(0)7451/53706-90 D-72160 Horb a.N. http://www.guh-software.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: connect to mySQL without database
Yes. Which language you are using? Regards, Karam --- Michael Seele <[EMAIL PROTECTED]> wrote: > hi, > is it possible to connect to a mySQL-Server without > entering a database > and then check all available databases? > thx mseele > > -- > G & H Softwareentwicklung GmbH Tel.: > +49(0)7451/53706-20 > Robert-Bosch-Str. 23 Fax: > +49(0)7451/53706-90 > D-72160 Horb a.N. > http://www.guh-software.de > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
