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?
Read »
