How to Create a MySQL Database

by austingulati on January 11, 2011

  • Share
  • CevherShare
  • Share

Before you get going with your next big project, you’re going to have to create a database for it to use. Here’s a quick guide on the few different ways that you can create a database.

The first method that you can use is a helper script. A really popular one for MySQL is phpMyAdmin. phpMyAdmin provides you with an interface to do all of the database tasks that you will ever need to do. It’s a very helpful tool – if you don’t have it installed on your server you should really consider trying it out.

A tool is provided by phpMyAdmin for creating databases. It looks like this:

It’s fairly self explanatory, you just put in the name of the database and then let phpMyAdmin handle the rest. You don’t really have to worry about the two collation options that are provided – phpMyAdmin automatically chooses the right settings for you.

Obviously, other tools that are available will have different interfaces for creating databases. They all should be fairly self explanatory, like the one that phpMyAdmin provides. If you have any questions about specific tools, feel free to leave a comment and I’ll see what I can do to help you.

The other way that databases can be created is manually. You can write the query to create a database in the same way that you write a query to insert into a database or select from a database. The syntax for creating databases is as follows:

CREATE DATABASE database_name;

It can get a little more complex than this, but this should suffice for now. You can read more in depth information on how to form this query on MySQL’s reference page.

You can run this query as you would with any other query. For example, you can run it from the MySQL console. It would look like this:

mysql> CREATE DATABASE database_name;
Query OK, 1 row affected (0.00 sec)

You can also run it from PHP:

<?php
mysql_query("CREATE DATABASE database_name");
?>

That’s pretty much all that you need to know in order to create a MySQL database. If you have any questions, feel free to leave a comment!

Leave a Comment

Previous post:

Next post: