BuycPanel Blog

Latest news and updates

Creating WordPress Accounts, Username, and Databases with phpMyAdmin

Posted by Alex on 26 01 2017.

Ask any cPanel user which content management system (CMS) they use and you will most likely get a lot of answers telling you “WordPress.” There are many god reasons for this, some of which include the system being one, if not the most powerful CMSs available today, boasting of an easy-to-navigate and –use interface, and best of all, you can get it for absolutely nothing at all.

There are many ways to get WordPress, either directly through your cPanel account, or your cPanel’s phpMyAdmin. In this tutorial, you will learn how to acquire WordPress via cPanel’s phpMyAdmin.

Using your phpMyAdmin to via cPanel to Create an Account with WordPress

To use your phpMyAdmin via cPanel, just follow these steps:

Go to your cPanel account.

Locate the “Databases” heading and look for and click the icon for “phpMyAdmin.”

Creating a WordPress Account through phpMyAdmin

Some web servers already have installed phpMyAdmin for their clients. In this case, you can just follow the steps below for creating an account with WordPress, a database, and a username.

Take note though that these directions apply for phpMyAdmin 3.5.

If you do not have a WordPress-related database under the dropdown list for “Database”, you need to create one. You just need to pick a name you prefer for your WordPress database. The names “blog” or “wordpress” are the most popularly used. However, a lot of web host companies require their users to create a database name starting with their username plus an underscore.

After you have named your database and chose the most appropriate collation, hit on the “Create” button.

On the upper left hand corner of the page, you will find the “phpMyAdmin” icon. Click this so you can go back to the main page. Once you are back, hit the “Users” tab.

Just in case you cannot find a WordPress-related user in the list you see, simply generate one through these steps:

Click on the “Add user” button found on the bottom of the list.

Again, choose a WordPress username for the user and key it in the field for “User name.” You should select the “Use text field” from the dropdown menu.

Generate a very secure and powerful password. This means creating one that combines both lower- and upper-case letters, symbols, and numbers. Then, put the password you chose in the field for “Password”. Another reminder here is to ensure you selected the “Use text field” from the dropdown menu. You will have to re-enter your chosen password.

Make sure you have taken notes of the credentials you just entered.

Do not change anything under the “Global privileges” option.

Hit the “Go” button.

Go back to the “Users” screen. Here, look for the “Edit privileges” option for the newly created user and click on it. The “Database-specific privileges” menu will appear. Choose the newly created WordPress database which you will find in the “Add privileges to the following database” dropdown menu. Once the page refreshes, mark the “Check All” option to ensure you have every privilege selected. Click the “Go” button.

The last step above will redirect you to a page with the host name indicated at the top of the page, right next to Server: Take note of this. In most cases, this usually appears in the form of the term “localhost.”