User Manuals

Learn how to use WordPress – and take advantage of its advanced features.

  • Setup, Usage & Integration

Setting up MySQL Database and User

Before you can install WordPress or WordPress Multisite you first need to create a MySQL database and user on your domain using your cPanel.

In simple terms your MySQL database stores all blog information including files, blog posts and comments and is backed-up almost constantly by your hosting company to ensure no data is lost.

1. Log into cPanel using your account details supplied by your hosting company.

  • Appearance of cPanel does vary slightly depending on what theme your hosting company uses.
  • Not all hosting companies use cPanel

Image of Cpanel

[non members only]small-450-banner1[/non members only]
[members only]

2. Scroll down to the Database section of cPanel and click on MySQL Databases

3. Create a database by entering the name wpms and clicking create database

4. Once the database has been created click on the Go Back link.

Please Note:

  • The name of your database and user are both given the default prefix of your domain name.
  • This is to ensure it has a unique name from other databases when it is stored on your host’s servers.

5. Next create a new user by adding their username and password then click Create User.

  • Make sure you record your username and password in a safe location as you will need to add this when you edit your wp-config.php file.

6. Once the user has been created click on the Go Back link.

7. Now add your user to your database by scrolling down to Add User to Database and click on Add.

8. On the Manage User Privileges page select All Privileges.


[/members only]
See Next: Creating and Editing your wp-config.php file