Published 7/5/2007 11:00:22 PM  in  MySQL

This code snippet shows you how to list all databases available on a MySQL server. The trick is to use the show databases command:

string sConn = "Database=mysql;Data Source=localhost;User id=root;Password=whatever";

MySql.Data.MySqlClient.MySqlConnection oConn = 
 new MySql.Data.MySqlClient.MySqlConnection(sConn);

oConn.Open();

MySql.Data.MySqlClient.MySqlCommand oCommand = oConn.CreateCommand();
oCommand.CommandText = "show databases";
MySql.Data.MySqlClient.MySqlDataReader oReader = oCommand.ExecuteReader();

while (oReader.Read())
{
 string sOneDatabase = oReader[0].ToString();
//add your code to do something with the name...
}
oReader.Close();
oConn.Close();