Posts Tagged ‘database’

This tutorial will show you how to add a database in cPanel. This is useful for manually installing content management systems, blogging softwares, and any other scripts that rely on a database to function. (Basically anything that uses PHP) Let’s get started…

1.) Log in to your cPanel Hosting account. To access cPanel you should navigate to either http://cpanel.mywebsite.com or http://mywebsite.com:2082 (Note: You will need to replace “mywebsite.com” with your domain name and extension, this is normally .com)

2.) Once logged in, look on the right hand side for a box similar to the one below. Click on MySQL Database Wizard.

3.) This is the easiest way to create a database as all you really have to do is fill in the fields and it does the rest of the work for you. As seen in the first screen shot, you will need to choose a database name, on the second screen you will need to choose a user name, and password. Then on the third you will need to select the permissions your user will have to the database specified in step one.

(Note: When entering the database name and user name into your script such as Joomla! remember that your cPanel user name with an underscore will precede the database name and user name for the database. e.x. If your database and user name are both “test” and your cPanel user name is “testing” then your full database and user name will be “testing_test”)

4.) If you found this tutorial useful please leave a comment. Thanks.