Using cPanel to create a database and a database user

1. Like many hosNng services, the one I use for this demonstraNon offers the cPanel control panel. cPanel is web-based, so you don't need to install anything on your computer to use it. Using your web browser, you just log into your hosNng service using the username and password they provide to you.

2. From the cPanel Home Page, I select MySQL Databases.

3. Then, I enter the name of the database and click on the Create buton.


4. The previous screenshot contains some very important informaNon that I will need later.

5. For Magento to connect to this database, it must know:

Q  Where to find the MySQL host
Q  The name of the database
Q The username and password of a user who has access to that database

6. NoNce the name of the MySQL host, localhost:/tmp/mysql5.sock. This is where
an applicaNon that is located on the same server will find the MySQL host. It is one
of the parameters that I will enter into Magento. I will also need the name of the
database—in this case, magento.

7. Now, I will create a user for this database. I've selected magento as the username, and I will give that user all privileges on that database:

8. Using cPanel, this is all I need to create a database and a database user for Magento.

magento one step checkout - fancy product designer - magento extensions