Creating a MySQL Database for WordPress

Once you’ve got WordPress uploaded in the correct spot on your web server, the next step is to create a MySQL (pronounced “my – ess – cue – ell”) database for it to connect to. Blogs work by referencing a database which stores all your posts, comments, etc. WordPress needs a specific type of database, called MySQL. Almost all web hosting companies offer free MySQL databases, and they are usually very easy to set up. After you create the database, you’ll connect your WordPress files to the new database.

How to create a MySQL database for WordPress:

To create a MySQL database, look around in your web hosting control panel for links labeled MySQL, or even better MySQL wizard. It often looks something like the below picture.

mysql-database-wizard-cpanel-icon

When you find the MySQL features, all you need to do is

  1. Create a new database (write down the name of the database)
  2. Create a new user (write down the username)
  3. Create a password for your user (write down the password)
  4. Finally, make sure that the user you created in step 2 is assigned to the database you created in step 1, and given ALL PRIVILEGES.

This is actually much easier than it sounds. Watching the below video will usually be enough to get most people through the process of creating a new database. [Note: if you use older Godadddy hosting (non-cPanel), the process for setting up MySQL is pretty non-standard. Click here for Godaddy-specific help.]

If you can’t figure it out, call your web hosting technical support and ask them to walk you through the process of setting up a new MySQL database, and make sure you get the three vital pieces of information: database name, username (user must be given all priveledges), and password.


Once you’ve got WordPress uploaded in the correct spot on your web server, the next step is to create a MySQL (pronounced “my – ess – cue – ell”) database for it to connect to. Blogs work by referencing a database which stores all your posts, comments, etc. WordPress needs a specific type of database, called MySQL. Almost all web hosting companies offer free MySQL databases, and they are usually very easy to set up. After you create the database, you’ll connect your WordPress files to the new database.

How to create a MySQL database for WordPress:

To create a MySQL database, look around in your web hosting control panel for links labeled MySQL, or even better MySQL wizard. It often looks something like the below picture.

mysql-database-wizard-cpanel-icon

When you find the MySQL features, all you need to do is

  1. Create a new database (write down the name of the database)
  2. Create a new user (write down the username)
  3. Create a password for your user (write down the password)
  4. Finally, make sure that the user you created in step 2 is assigned to the database you created in step 1, and given ALL PRIVILEGES.

This is actually much easier than it sounds. Watching the below video will usually be enough to get most people through the process of creating a new database. [Note: if you use Godadddy as your webhost, their process for setting up MySQL is pretty non-standard. Click here for Godaddy-specific help.]

If you can’t figure it out, call your web hosting technical support and ask them to walk you through the process of setting up a new MySQL database, and make sure you get the three vital pieces of information: database name, username (user must be given all priveledges), and password.

Once you’ve got WordPress uploaded in the correct spot on your web server, the next step is to create a MySQL (pronounced “my – ess – cue – ell”) database for it to connect to. Blogs work by referencing a database which stores all your posts, comments, etc. WordPress needs a specific type of database, called MySQL. Almost all web hosting companies offer free MySQL databases, and they are usually very easy to set up. After you create the database, you’ll connect your WordPress files to the new database.

How to create a MySQL database for WordPress:

To create a MySQL database, look around in your web hosting control panel for links labeled MySQL, or even better MySQL wizard. It often looks something like the below picture.

mysql-database-wizard-cpanel-icon

When you find the MySQL features, all you need to do is

  1. Create a new database (write down the name of the database)
  2. Create a new user (write down the username)
  3. Create a password for your user (write down the password)
  4. Finally, make sure that the user you created in step 2 is assigned to the database you created in step 1, and given ALL PRIVILEGES.

This is actually much easier than it sounds. Watching the below video will usually be enough to get most people through the process of creating a new database. [Note: if you use Godadddy as your webhost, their process for setting up MySQL is pretty non-standard. Click here for Godaddy-specific help.]

If you can’t figure it out, call your web hosting technical support and ask them to walk you through the process of setting up a new MySQL database, and make sure you get the three vital pieces of information: database name, username (user must be given all priveledges), and password.

If you’ve searched the tutorials and can't find what you need, please contact us. We’re here to help. Contact Us