[RESOLVED] Loading openemm-2013.sql to MySQL database

[liongate]

I am using Plesk and have created the openemm database but when I try to import the openemm-2013.sql file into it I am receiving the following message:

QL query:

GRANT DELETE ,
INSERT ,

UPDATE ,
LOCK TABLES ,
SELECT ,
ALTER ,
INDEX ,
CREATE TEMPORARY TABLES ,
DROP ,
CREATE ON openemm . * TO 'agnitas'@'localhost' IDENTIFIED BY 'openemm';

MySQL said:

#1044 - Access denied for user 'openemm'@'localhost' to database 'openemm'

I have created a database user named openemm. What's causing this problem? Is there a password somewhere in openemm-2013.sql that needs to be set for the openemm user? It does appear that the database became populated, and I see the offending script appears at the very end of the openemm-2013.sql file.

[maschoff]

Did you use MySQL user "root" to create the OpenEMM database?

[liongate]

I could not use MySql user root because Plesk 11 establishes admin as root and does not permit creation of a MySql root account.

[maschoff]

IMHO, this is the reason why the database does not work.

[liongate]

IMHO, this is the reason why the database does not work.

I haven't got to the point where I know whether the DB will work or not -- only that I couldn't CREATE it using the command line as instructed in the install guide.

[liongate]

Okay -- I've got it figured out. There are TWO databases, i.e. openemm-2013.sql and openemm_cms.sql, that have to be imported. When I did the import from the SSH command line, the import actually worked, although I did receive an error at the end. Once I got the second DB installed, I can log in to the administrative panel.

[liongate]

I understand what was happening how. The database was loading, but the last line, which created and granted access to the agnitas@localhost user was not running. I was able to accomplish this through the Plesk control panel or at the mysql> prompt so now the correct permissions have been assigned.