Databases wizard (MySQL)
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:
- Open a creation wizard for a database. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - for details, see Databases - Properties
- Privileges panel - Setting Permissions or Privileges for an Object
- DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
- 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.