I am trying to set up Zen Cart and created a MySql database – only thing I need to do now is grant permissions and I am not sure how. I set up MySql 5.0 and I am hosting at GoDaddy, the Zen Cart tutorials only said this:
What Database Permissions Do I Give to my Database User?
For the purposes of Zen Cart sites, the following permissions are required for the database user:
* SELECT
* INSERT
* UPDATE
* DELETE
* FILE (optional, 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 (required only for database backups)
I’ve looked around in the MyPHPadmin and couldn’t really figure anything out, any help would be grealty appreciated!
Next: What Would Be A Good Domain Name?
Previous: Can Someone Help Me With Creating A Web Site?
"How Do I Grant Permissions In Mysql For Zen Cart?" was posted on Monday, January 18th, 2010 at 3:33 am.
Hi there,
I haven’t done any hosting with GoDaddy, but in almost all cases, the MySQL user and password given to you already have full permission to your database, except the permission to modify the permission itself.
So you can already do SELECT, INSERT, UPDATE, etc without making any changes at all. But you can’t change your user’s permission to make it more restricted or grant certain permissions to other users.
So in short, you can just skip this step.