Setting Up a Database:
WordPress requires a MySQL database to store the information for your site, such as your blog posts, page content, usernames and passwords, custom-post type information, and more.
If you use an installer like ‘Auto Installer’ to set up WordPress, this database will be automatically created for you. If not, these instructions will help you set one up yourself.
To set up a MySQL database using a hosting control panel:
- In your browser, navigate to the URL of your cPanel (control panel) and log in using your administrative username and password.
- In the ‘Advanced’ section, select “MySQL Databases” Wizard.
Click “MySQL Database”
- In the 1st field of the Database Wizard, enter the name of the database you would like to create. In our example we are calling the database ‘wpsite’ but you can use any unique name you want.
- In 2nd filed of the Database Wizard, you will need to create a MySQL username and password. Enter a username (wuser in our example) and click “Generate Password“.
- Now you will see that cPanel has automatically created a password for you. We recommend using this automatically generated password for security purposes, since it’s difficult to guess. You can create a password manually, but the random password is usually a better choice. You will not need to type this password to log in to WordPress or anything else; it’s only needed during database setup, so don’t worry about it being hard to remember.
- Now click the “Create” button on the Database wizard.
Type Database Name, Username and Password. Click “Create” button to create your database.
- At the top of the screen, you will now see the actual username and password that were created. Note that in our example the ‘u837336792_prefix’ has been added to the ‘wuser’ username we typed in previously. Make a note of the username and password for use when you install WordPress later.
In Above show your Database Username and Password. Save it in your computer.
Your MySQL database has been created and a user account has been added to it for WordPress to utilize. You can now move on to “Installing WordPress.”