To prepare a MySQL database for Zen Cart to use:
- Open your hosting account's control panel.
- Find the "Databases" section
- Choose the MySQL option
- Click on the option to Create a database. Enter a name for it and submit. (Record the name for use in Zen Cart)
- Now create a user and password. (Record these for use in Zen Cart)
- Now you need to "grant" or "assign" the user to the database, granting appropriate permissions. See the section about Permissions, below.
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)
Using any of the optional items noted above does not create any significant security risk. Recommended approach for most storeowners is "All Privileges"
