By smedved on

I created a database called test in MyPHPAdmin in my hosting provider GoDaddy.com. I exported my database from myPHP on my localhost.

When I try to import my database to my PHPAdmin within my hosting provider GoDaddy.com, it generated the following error:

SQL query:

--
-- Database: `drupal_test`
--
CREATE DATABASE `drupal_test` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1044 - Access denied for user 'test'@'%' to database 'drupal_test

I think that the test user in Godaddy.com PHPMyAdmin does not have privileges.

How can I grant the test userid privileges even though I do not see the privileges tab on the top. Even though without the privileges being visible I can not create other users.

⋅ Categories: Drupal 6.x

Comments

scoutbaker’s picture

scoutbaker commented

Check your control panel for how to create databases, users, and add permissions. If you have further questions, you need to ask your provider, GoDaddy.

GDHosting’s picture

GDHosting commented

smedved,

The reason you were, or still are, getting this error is because the database is already created so you won't be able to execute the statement - CREATE DATABASE. Instead, replace it with "USE drupal_test;" or the actual name of the database.

Thanks,
Alicia

sutharsan’s picture

sutharsan commented

I had the same error message, but in my case cause by the LOCK command

LOCK TABLES `access` WRITE;
...
UNLOCK TABLES;

Removing the LOCK and UNLOCK allowed me to upload the database.

-- Erik