{"id":426,"date":"2019-10-18T15:01:49","date_gmt":"2019-10-18T08:01:49","guid":{"rendered":"https:\/\/mariadbtutorial.com\/?page_id=426"},"modified":"2020-04-11T23:24:03","modified_gmt":"2020-04-11T16:24:03","slug":"mariadb-create-database","status":"publish","type":"page","link":"https:\/\/www.mariadbtutorial.com\/mariadb-basics\/mariadb-create-database\/","title":{"rendered":"MariaDB Create Database"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the MariaDB create database<\/code> statement to create a new database.<\/p>\n\n\n\n

Introduction to the MariaDB create database statement<\/h2>\n\n\n\n

To create a new database in a MariaDB server, you use the create database<\/code> statement with the following syntax:<\/p>\n\n\n

create<\/span> [or<\/span> replace<\/span>] database<\/span> [if<\/span> not<\/span> exists<\/span>] database_name\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n
[character set = charset_name]<\/p>\n\n\n\n
\n[collate = collation_name];\n\n<\/p>\n\n\n\n
In this syntax:<\/p>\n\n\n\n
First, specify the name of the database that you want to create after the create database<\/code> keywords. The database name must be unique in the MariaDB server instance. If you create a database that has the same name as an existing database, MariaDB will issue an error.<\/p>\n\n\n\n
Second, the optional or replace<\/code> clause instructs MariaDB to drop the database first if it exists before creating the new database. It is a shortcut for the following statements:<\/p>\n\n\n
drop<\/span> database<\/span> if<\/span> exists<\/span> database_name;\ncreate<\/span> database<\/span> database_name;\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Note that MariaDB has supported the or replace<\/code> clause since version 10.1.3.<\/p>\n\n\n\n
Third, use the if not exist<\/code> option to conditionally create a database if it does not exist. In other words, if you try to create a database that already exists with the if not exist<\/code> option, MariaDB will do nothing.<\/p>\n\n\n\n
Finally, optionally specify a character set and collation for the new database. A character set defines how and which characters that the database will store to support particular languages. A collation defines the rule for comparing strings, for example, the letter a<\/code> appears before the letter b<\/code>, etc.<\/p>\n\n\n\n
Notice that you need the create<\/code> privilege for the database in order to create a new database.<\/p>\n\n\n\n
Creating a new database using mysql command-line program<\/h2>\n\n\n\n
To create a new database via the mysql command-line program, you follow these steps:<\/p>\n\n\n\n
First, log in to the MariaDB server using a user account that has the create<\/code> privilege for the database:<\/p>\n\n\n
>mysql -u root -p\nEnter password: ********\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Type the password for the root<\/code> user and hit the Enter<\/code> keyboard.<\/p>\n\n\n\n
Second, show databases<\/a> in the current server using the show databases<\/code> statement:<\/p>\n\n\n
mysql> show<\/span> databases<\/span>;\n+--------------------+<\/span>\n| Database           |\n+--------------------+<\/span>\n| information_schema |\n| mysql              |\n| nation             |\n| performance_schema |\n| test               |\n+--------------------+<\/span>\n5 rows in set<\/span> (0.01<\/span> sec)\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Third, create a new database name crm<\/code>:<\/p>\n\n\n
mysql> create<\/span> database<\/span> crm;\nQuery OK, 1 row affected (0.01 sec)\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Fourth, show the databases again:<\/p>\n\n\n
mysql> show<\/span> databases<\/span>;\n+--------------------+<\/span>\n| Database           |\n+--------------------+<\/span>\n| crm                |\n| information_schema |\n| mysql              |\n| nation             |\n| performance_schema |\n| test               |\n+--------------------+<\/span>\n6 rows in set<\/span> (0.00<\/span> sec)\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
The database crm<\/code> is on the list.<\/p>\n\n\n\n
In this tutorial, you have learned how to use the MariaDB create database<\/code> statement to create a new database.<\/p>\n
\n\t
\n\t\t
Was this tutorial helpful ?<\/div>\n\t\t
\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
\n\t\t
\n\t\t\t
<\/div>\n\t\t\t\n\t\t\t
After creating the new database, you can select the database<\/a> as the current database to work with.<\/p>\n\n\n\n