Could not connect to or create the PhotoPost database.

[i9000]

I am getting the following error when trying to do a clean install of Photopost 6.2

Content visible to verified customers only.

I know my SQL settings are OK, I've tested them at the command line.
Any suggestions?

[Chuck S]

That error is pretty self explanatory the user does not have either create priveledges.

[i9000]

It doesn't appear to be that simple. I take the MySQL settings from the installer page, paste them directly into the mysql command and I can create a table.


mysql -ucarshowg_carshow -pXXXXXXXXXX carshowg_carshowgallery

mysql> CREATE TABLE example(
-> id INT NOT NULL AUTO_INCREMENT,
-> PRIMARY KEY(id),
-> name VARCHAR(30),
-> age INT);
Query OK, 0 rows affected (0.15 sec)

[Chuck S]

well double check the host username password database are all settings that are correct as the error you post suggests it is not.