Creating a new database

Creating a new MySQL database through Webmin's interface is very quick and simple.

How to do it...

Follow these steps to create a new database:

1. Navigate to Servers | MySQL Database Server.

2. Click the Create a new database link.

3. Enter Database name, for instance, new_db.

4. Set Character set to utf8 (UTF-8 Unicode).

5. Set Collation order to utf8_unicode_ci (UTF-8 Unicode).

   Note

   The character set specifies how letter characters are stored in your database and the utf8 character set contains all the letters of most alphabets. The collation order, on the other hand, specifies what order the letters should be placed in when sorting alphabetically. The utf8_unicode_ci collation aims to be universal, but there may be regional variations that make a local collation such as utf8_polish_ci more appropriate for your situation.

6. Set Initial table to None.

7. Click the Create button.

How it works...

Webmin takes the information that you provide and creates a new database by connecting to the MySQL server...