How to Create a MySQL Database

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:

{code type=sql}CREATE DATABASE database_name;{/code}

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:

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

You can also run it from PHP:

{code type=php}{/code}

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 Reply

Your email address will not be published.

More Posts

How to use PHP Type Declarations

PHP has developed into a more strictly typed language in recent years. Type Declarations help with that and are a fairly new addition to PHP,


If you have come to JavaScript from a background in Java or C, then you will like the variation on the for loop. It is

Context Object Manipulation

One of the key concepts of JavaScript is the keyword this, which signifies the JavaScript context object. If you write an inner function, you can access

Polymorphic Functions

It is possible to define multiple functions with the same name in JavaScript, and the last one of those that you define will be the