WordPress Tutorial: Setting Up A MySQL Database With cPanel

Teli Adlam —  July 19, 2006

If you’re installing WordPress manually, then you will need to know how to create a database with your host. The tutorial below assumes that your host uses cPanel and has phpMyAdmin installed.

  1. Click MySQL Icon in cPanel Log into your website’s admin panel (cPanel) and click on the MySQL Databases icon.
  2. Create New Database When the MySQL overview page loads, scroll down to the section labeled Add a Database and type the desired name of your database in the box below, then click on the Add Db button (some hosts may have the button labeled Create Database). If the database was created successfully, you’ll receive a confirmation message, click on the Go back link to return to the MySQL overview page.
  3. Create A Database User Scroll down to the area labeled Add a Database User and type the desired username for the new database user and a password, then click on the Create User button. If all went well, you’ll be presented with a confirmation message, click on the Go back link to return to the MySQL overview page.
  4. Add A User to the Database In order for your scripts to access your new database, you’ll need to give a user permission to access it. To do this, scroll down to the area marked Grant Access to a Database User (or Add Users to Your Databases depending on your host) and from the User drop down menu, select the user you want to associate with your database and then select the database from the Database drop down menu. Click on the Add User to Db button. If all went well, you’ll be greeted with a confirmation message, click on the Go back link.
  5. From the MySQL overview page, verify that the user was added to the database with the proper permissions. If so, then you’re all set, now must make a note of the database name, the username, and the user’s password for later reference.
0 Shares

Teli Adlam

Posts

2 responses to WordPress Tutorial: Setting Up A MySQL Database With cPanel

  1. thanks. your tutorial helped me create my first mysql database. it is actually so easy.

  2. Thank you VERY MUCH. I am a beginning blogger flopping around and this tutorial was beautifully simple.