check if mysql/mariadb database exists

[bdexterholland]

hi guys!

well, i`m planning to make a wizard to my system. If database doesn`t exist then run script to create a startup database.

wonderful, miracle, champagne for all

but:
* if database doesn`t exist MySQL57Conn raises ESQLDatabase Error;
* if database exists but login is wrong MySQL57Conn raises ESQLDatabase Error;
* if database exist, login is right but password is wrong MySQL57Conn raises ESQLDatabase Error;

How can I check if database doesn`t exist?

[BSaidus]

Do execute SQL query

Code: SQL  [Select][+][-]

1. SHOW DATABASES

in a query and see in result if your database exists.

[PierceNg]

Even if database exists it may be some other database that happens to have the same name. So next thing to do is to verify the schema. Which your application will have to do eventually for its database due to evolving schema.

[bdexterholland]

Do execute SQL query

Code: SQL  [Select][+][-]

1. SHOW DATABASES

in a query and see in result if your database exists.

OK, but you use a TSQLQuery and connect to mysql schema before run this command?

TMySQL<xx>Connection needs to specify a database before connect

[bdexterholland]

Even if database exists it may be some other database that happens to have the same name. So next thing to do is to verify the schema. Which your application will have to do eventually for its database due to evolving schema.

That`s a good point but for now i`m not worrying about it. Maybe a second step. For now, who should use my software probably don`t have a mysql installed for another systems. This is for a first run or a recovery...