Most hosting services that include mySQL automatically configure permissions so that once you have created a database, it is accessible by the user that is assigned to it. We have found dedicated server plans (RackSpace) that do not work this way. If the database settings are correct within config.inc.php and the database is on the local host, but the database is still inaccessible, it may be that permission to access this database has not been granted within mySQL. Permissions can be granted through SSH shell access.
Here is the mySQL client syntax to grant write permissions for database tables.
Once you've logged into the server with your SSH client, you need to make sure you're working as user "root". If you've logged in as another user, simply enter the following command at the prompt:
su
You will then be prompted for root's password (note: password will not echo). You're now ready to fire up the MySQL client. Just type the following at the prompt:
mysql -u root -p
You will then be prompted for the MySQL root user's password. Just hit enter here, as no password has yet been set. You should now be presented with a MySQL client prompt, that looks like this:
mysql>
This is the client ccommand interpreter where you enter your commands, which are always followed by a semicolon (;). Just enter the following to get your permissions set:
grant all on ashopmab.* to gmccausl@localhost identified by '66X8T4wY' with grant option;
(note: this is all on one line). Now hit enter, and type or cut/paste the following:
grant all on ashopmab.* to gmccausl@"%" identified by '66X8T4wY' with grant option;
This should get your permissions set to database "ashopmab" for user "gmccausl" with password "66X8T4wY". You can then type:
quit;
to exit the MySQL client. It's also a good idea to follow up with:
mysqladmin reload
to make sure the new permissions take effect. Now you should have full grant permissions on the database in question.
For a very good in-depth overview and tutorial of MySQL, you can't do much better than MySQL's site:
http://www.mysql.com/documentation/mysql/bychapter/index.html