MariaDB – Create Database

MariaDB – Create Database

Creation or deletion of databases in MariaDB requires privileges typically only given to root users or admins. Under these accounts, you have two options for creating a database − the mysqladmin binary and a PHP script.

mysqladmin binary

The following example demonstrates the use of the mysqladmin binary in creating a database with the name Products

[root@host]# mysqladmin -u root -p create PRODUCTS
Enter password:******

PHP Create Database Script

PHP employs the mysql_query function in creating a MariaDB database. The function uses two parameters, one optional, and returns either a value of “true” when successful, or “false” when not.


Review the following create database script syntax −

bool mysql_query( sql, connection );

The description of the parameters is given below −

S.NoParameter & Description

This required parameter consists of the SQL query needed to perform the operation.


When not specified, this optional parameter uses the most recent connection used.

Try the following example code for creating a database −

      <title>Create a MariaDB Database</title>

         $dbhost = 'localhost:3036';
         $dbuser = 'root';
         $dbpass = 'rootpassword';
         $conn = mysql_connect($dbhost, $dbuser, $dbpass);
         if(! $conn ) {
            die('Could not connect: ' . mysql_error());

         echo 'Connected successfully<br />';
         $retval = mysql_query( $sql, $conn );
         if(! $retval ) {
            die('Could not create database: ' . mysql_error());

         echo "Database PRODUCTS created successfullyn";

On successful deletion, you will see the following output −

mysql> Database PRODUCTS created successfully 
| Database              | 
| PRODUCTS              | 

Was this article helpful?

Related Articles

Leave A Comment?

You must be logged in to post a comment.