Databases wizard (MySQL)

From DBArtisan
Jump to: navigation, search

Go Up to MySQL object wizards

The MySQL Database Wizard lets you build and execute a basic CREATE DATABASE statement and grant privileges on the database.

To create a new database using a wizard:

  1. Open a creation wizard for a database. For details, see Opening an Object Wizard.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Execute button to create the object.

Databases - Properties

When creating or editing database, this tab/panel lets you work with the following settings:

Setting Description

Database Name

The database name you choose can be up to 64 characters long. Feel free to use all alphabetic characters or mix in some special or numeric characters. But a name cannot be exclusively special or numeric characters.

Default Character Set

This is the character set for a language or alphabet. If you do not make a selection from the drop-down list (click the arrow to see the choices), the database will use the server’s default character set.

Collation

The collation encodes the rules governing character used for a language (like Greek) or an alphabet. The database will use the server’s default collation unless you specify otherwise.

Note: It’s possible to create databases with different character sets and collations on the same MySQL server.