By dougl on

I am new to drupal and have recently uploaded my site to the server, (acquia_drupal). I am getting SQL ERROR 1044 is encountered upon attempting to import the database that was exported locally as instructed. NOTE: My acquia_drupal local site is comprised of 4 separate databases, (acquia_drupal, information_schema, mysql, and test which is the only empty db).

When exporting the db's into one gzip sql file, it is combining the 4 db's. When I attempt the import, the error 1044 is encountered as follows:

Error

SQL query:

CREATE DATABASE `acquia_drupal` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1044 - Access denied for user 'bigdogsb'@'localhost' to database 'acquia_drupal'

********************************************************************

I have created a user for the db on my web server: root, (also tried admin). This attaches the username as a suffix after my server username as follows:
myservername_root.

I created a db on the server named drupal, which is also attached to the server username as follows: myservername_drupal

When I export all the db's from my install, it is named: 127.0.0.0.sql.gz

Any advise on what my malfunction(s) may be?

⋅ Categories: Drupal 6.x

Comments

billyy2288’s picture

billyy2288 commented

Thanks you for the post.
_________________
http://moviesonlinefree.biz

postscripter’s picture

postscripter commented

Go back and re-export your data and be sure you're exporting your tables and not your databases

jscoble’s picture

jscoble commented

You need to grant the user you, bigdogsb, are using to connect to MySQL permissions on your acquia_drupal database:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX,
ALTER, CREATE TEMPORARY TABLES, LOCK TABLES
ON acquia_drupal.*
TO 'bigdogsb'@'localhost'
IDENTIFIED BY 'password';

Make sure you replace password with the password for biddogsb.