Creating a New Empty MySQL Database

In order to create MySQL Server databases, MySQL 5.0 or later must be installed on one of the network servers or workstations (see Installing MySQL).

If another database is already open then you will need to close that database first before creating a new database (see Closing a MySQL Database). To create a new At Your Service MySQL database, select File  New Database  Empty MySQL Database from the main menu.

The only MySQL connection type presently supported is the MySQL ODBC connector. Enter the corresponding connection parameter, and click the Login button to connect to the MySQL server. Click the Cancel button or press the Esc key to cancel without connecting to the MySQL server. The following table summarizes the connection type and parameters.

MySQL Connection Types

Connection Type	Description
ODBC DSN data source	An ODBC DSN data source utilizes one of the above connection methods configured as a System DSN within the Data Sources (ODBC) component in the Windows Control panel. Enter the name of the DSN data source.

 

If the connection to the MySQL server was successful then you will be prompted to enter the name for the new empty database. Enter a name and press the Create button to create the new database. A progress bar will track the progress as the database is created. Click the Cancel button or press the Esc key to cancel without creating a database.

The actual name of the physical database on the MySQL server will be prefixed with “AYS_” to distinguish it from other databases on the same MySQL server (e.g. if the name “sample” is entered then the actual name of the physical database on the MySQL server will be “AYS_sample”).

After creating a MySQL database the name of the database must be configured in the MySQL Connector/ODBC system DSN in order for printing to work correctly (see Installing MySQL).

(See also Importing an Access Database to a New MySQL Database, Creating a New Empty Access Database, and Creating a New Empty Microsoft SQL Server Database.)

More:

Importing an Access Database to a New MySQL Database