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 so you can use it later in Zen Cart). If you are given an option for choosing a Character Set, choose utf8mb4; if offered a Collation option, choose utf8mb4_0900_ai_ci or utf8mb4_unicode_520_ci.
  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? Use the Search box in the upper right, or try the full list of FAQs. If you can't find it there, 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 March 17, 2021 by Chris Brown (3b42304).