How to Create Database in MySQL or Mariadb

<<Back to MySQL & MariaDB Main Page

Creating a Database in MySQL or Mariadb

Command to create a database in MySQL or MariaDB is same and is super easy. All that you need to know to create a database is
collation_name
charset_name
db_name
Lets quickly have a look at help manual of create database.

I am going to create a new database called provisioning_wdcee. I already have the character set and collation_name with me.
MariaDB> CREATE DATABASE `provisioning_wdcee` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;

Once the database is created we can quickly verify the presence of the database.
you can issue show databases like 'provisioning_wdcee'; as shown above.
You can also check for the existence of folder dedicated for this database in you datadir directory

Now you need to create the user and allow the access on this database to access the database from outside of the box.

Creating an user in mysql will be discussed later in a separate post.