Before installing Zen Cart, you will need to create a database. This step-by-step guide follows the process for creating a database if your webhost uses cPanel.
-
Log in to your cPanel Control Panel
Your cPanel is located at either http://YourSitesIPAddress/cpanel (for example, http://1.2.3.4/cpanel), or http://www.yourdomainname.com/cpanel
or http://cpanel.yourdomainname.com/.Your cPanel username and password will generally be found in a welcome email from your webhost.
Scroll down to the section Databases and click on MySQL Databases.
-
Create Database
Enter a name for your new database in the box and click Create Database. Record this name as you will need it again during the Zen Cart installation.
Click on Go Back to return to the previous screen following confirmation that your new database has been added. -
Create Database User
This user account is used by the application, in our case Zen Cart, to communicate with the database. You will not need to use this account for general access.
Scroll down to the Add New User section under the MySQL Users section.
Enter a username in the box provided.When it comes to the password, you can either enter a password in the box or click on Generate Password. It is recommended to use the Generate Password option to ensure a strong password is used.
Record both the username and the password along with the database name.
Click on Use Password.Click on Create User.
Click on Go Back.
-
Add User to Database
Scroll down to the Add User to Database section under the MySQL Users section.
From the drop down menus, select both the username and the database name that you have just created.
Click on Add.
Tick the All Privileges checkbox and then click on Make Changes.Click on Go Back.
Well done! You have now successfully created a MySQL database ready for the installation of Zen Cart.
