cPanel is a control panel for hosting servers that allows you to control many aspects of your website.
In most cases, if you want to set up a WordPress website on a server that has cPanel, you can do so with the click of a button and install the system automatically. However, there are cases where it is necessary to install WordPress manually, or to set up a new database specifically, without reinstalling the entire content management system. In this guide, we will explain how to create a database for WordPress using cPanel.
- Log in to your cPanel using your username and password.
- Select the MySQL Database Wizard option, located in the Databases category. You can also search for it.
- On the next screen, you must choose a name for the database. You can only enter a name with English characters and numbers. Please note that there is a prefix before the name you choose (usually your cPanel username, followed by an underscore), which you will also need to connect the database to WordPress. Enter a name and click Next Step.
- Now you need to set up a user for the database. You can set up an existing user if you know their password, but you don't have to; you can also set up a new user. Here too, the username has a prefix (the same prefix as the database name).
- At this stage, you must also choose a password for the user. Sifanel will indicate whether the password is strong enough. To shorten the process, you can click on Password Generator, which will choose a strong password for you. Copy the password and save it, as you will need it later. It is not necessary to choose a memorable password, as in most cases you will not need to re-enter the password after installing WordPress, and it is available in the wp-config.php file.
- After entering your username and password, click Create User.
- The next step is to connect the user to the database and grant them privileges. Check the All Privileges checkbox and click Next Step.
- If everything is correct, the system will notify you with a green message that the user you created has been successfully added to the new database. At this point, you can add a new database, add another user to the database you created, or return to the first screen.
- Enter all the required details in the WordPress wp-config file.