ZenCart Install MySQL DB error

[dynamo34]

I downloaded a fresh copy from the zen-cart.com address, placed it in a new directory, followed their instructions including permission requirements and then proceeding to install.

After clicking install in the ZenCart install screen I have all green check marks except for 2 items,

• PHP open_basedir restrictions = /home/:/tmp
• PHP Output Buffering (gzip) = OFF

I then input the database, username and password, previously created with the MySQL database in CPanel, I receive the following error.

Database does not exist
Access denied for user 'my_username'@'localhost' to database 'my_database_name'

Here is the database set up info from CPanel:

my_database_name 0.00 MB Delete Database
my_database_name2 0.00 MB Delete Database

 

[dynamo34]

I successfully installed ZenCart! :biggrin:

I solved the MySQL DB error issue by deleting all users and all databases.
Next I used the MySQL Wizard instead of creating them in the MySQL Databases area of CPanel.

The video tutorial has the user accessing MySQL Databases instead of the MySQL Wizard. This should be resolved or clarified in the video to make it understood.

What is the difference in using either the MySQL Database or MySQL Wizard to set up a database?
The MySQL Wizard sets permissions to the database, without which you can not access that database.

 

[Corey]

The MySQL wizard provides a step by step to set up the database, user, and permissions. You can do this all manually via the database section without the wizard though. The only difference is it's easier if you don't know how to do it yourself.