Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example

The CREATE DATABASE statement is used to declare an MySQL database within an Omnidex Environment File. This statement can either be issued directly, or it can be extracted from MySQL using the EXTRACT statement as discussed in the previous section.

The CREATE DATABASE statement must include the database name and the MySQL user and password. Note that the datatype type is ODBC, with a subtype of MYSQL, reflecting that ODBC is the primary method of accessing a MySQL database.

create database                "SIMPLE"
 type                          odbc
 subtype                       mysql
 user                          "simple"
 password                      "simple"
 index_directory               "idx"
 in                            "simple.xml";

Omnidex provides two methods of supporting MySQL security. The first option is for administrators to register a single user and password in the Omnidex Environment File to access an MySQL database. The second option is to pass a user and password in the Omnidex Connection String. This use user and password will be passed directly to MySQL to access the database. Administrators should insure that the user and password provides access to all of the database objects referenced in the Omnidex Environment Files.

Prev | Next

See also: