Select Permission Denied on Test Database

[leevil123]

I've created a test store based off of my existing store following some instructions that I found on the forums. Here's a quick version of the steps that I followed.

- Downloaded my store files locally.
- Did a backup of my store database using phpMyAdmin
- Created a test directory for my test store. /teststore
- Created a test database for my test store.
- Imported my db backup into the new test db using phpMyAdmin.
- Created a test user for my test store db and gave that user ALL permissions to the test db using cPanel.
- Modified the /includes/configure.php and admin/includes/configure.php files in my /teststore directory to point to the new test environment and test database.

When I try to access my test store, I get a "1142 SELECT command denied to user."

I've double checked the username/password for the db user and double checked the 2 configuration files, are there any steps that I missed?

Thanks in advance.

[Ajeh]

Check the user in your Control Panel that you did not just make a user and add it to the database but that you ALSO gave the user all of the permissions to use the database ...

In the MySQL where you setup the database and user you will see the username connected to the database ... the username is a link to the permissions granted to that user ...

[leevil123]

Check the user in your Control Panel that you did not just make a user and add it to the database but that you ALSO gave the user all of the permissions to use the database ...

In the MySQL where you setup the database and user you will see the username connected to the database ... the username is a link to the permissions granted to that user ...

I did select All Privileges after clicking on the user name and saved the changes which is what led me to this post. According to cPanel, it updated the privileges for that user.

Been trying to verify permissions in phpMyAdmin, but it doesn't let me.

[leevil123]

Hey everyone, does anyone have any other suggestions on this?

Thanks.