How do I create a MySQL database?

Using cPanel to create a MySQL database

To use Zen Cart, you need a database.

To prepare a MySQL database for Zen Cart to use:

  1. Open your hosting account’s control panel.
  2. Find the “Databases” section
  3. Choose the MySQL option
  4. Click on the option to Create a database.  Enter a name for it and submit. (Record the name for use in Zen Cart)
  5. Now create a user and password. (Record these for use in Zen Cart)
  6. Now you need to “grant” or “assign” the user to the database, granting appropriate permissions.  See the section about Permissions, below.

That’s it !!

Now in the Zen Cart Installer, on the Database Setup section, supply all of the database information you just set up: name, user, password, and host. Usually the “host” is “localhost” unless your hosting company uses a specific different configuration.

What Database Permissions/Privileges Do I Give to my Database User?

For the purposes of Zen Cart sites, the following permissions (“privileges”) are required for the database user:

  • SELECT

  • INSERT

  • UPDATE

  • DELETE

  • FILE  (not used by core code, but easiest to leave it checked)

  • CREATE

  • ALTER

  • INDEX

  • DROP

  • CREATE TEMPORARY TABLES (not required by the core code, but may be required by some addons)

  • LOCK TABLES  (not used by core code; required only for database backups)

If you’re using a cPanel hosting account, you would usually check the box for “ALL PRIVILEGES” instead of checking off individual options.

Using any of the optional items noted above does not create any significant security risk.  Recommended approach for most storeowners is “All Privileges”.




Still have questions? No problem! Just head over to the Zen Cart support forum and ask there in the appropriate subforum. In your post, please include your Zen Cart and PHP versions, and a link to your site.

Is there an error or omission on this page? Please post to General Questions on the support forum. Or, if you'd like to open a pull request, just review the guidelines and get started. You can even PR right here.
Last modified September 20, 2020 by Scott C Wilson (f3bd368).