Reader small image

You're reading from  Webmin Administrator's Cookbook

Product typeBook
Published inMar 2014
Reading LevelIntermediate
Publisher
ISBN-139781849515849
Edition1st Edition
Languages
Tools
Right arrow
Author (1)
Michal Karzynski
Michal Karzynski
author image
Michal Karzynski

Michał Karzyński, with a scientific research background in the areas of molecular biology and bioinformatics, has been running Unix-like operating systems since 2002. He works as a web application developer, programming in dynamic languages such as JavaScript, Python, Perl, and PHP. He specializes in designing programming interfaces between servers and client applications based on the HTTP protocol. He has been using Webmin for over five years to assist in setting up and managing servers. He is currently employed as a project manager at the Gdańsk University of Technology in Poland. His blog can be found at http://michal.karzynski.pl.
Read more about Michal Karzynski

Right arrow

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...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Webmin Administrator's Cookbook
Published in: Mar 2014Publisher: ISBN-13: 9781849515849

Author (1)

author image
Michal Karzynski

Michał Karzyński, with a scientific research background in the areas of molecular biology and bioinformatics, has been running Unix-like operating systems since 2002. He works as a web application developer, programming in dynamic languages such as JavaScript, Python, Perl, and PHP. He specializes in designing programming interfaces between servers and client applications based on the HTTP protocol. He has been using Webmin for over five years to assist in setting up and managing servers. He is currently employed as a project manager at the Gdańsk University of Technology in Poland. His blog can be found at http://michal.karzynski.pl.
Read more about Michal Karzynski