SQL Error during install

[adamface]

I am pretty sure I am using the right values.... just cant figure this out

I am getting the error message:

"mySQL Error: create command denied to user: 'adam@localhost' for table 'cgp_albums'"

here are my settings:

mySql host: localhost
mySQL database name: kanoah_net_-_main
MySQL table prefix: cgp_

help me obi-wan, you are my only hope

[Joachim Müller]

You will have to contact your webhost, since your mySQL user doesn't have permissions to create a table within your database. They will have to set the proper permissions for you. You need CREATE, ALTER, INSERT, SELECT (this is minimum to run coppermine). Usually you'll want DROP as well.

GauGau

[adamface]

thank you for your quick reply.

I had kind of figured that was the problem, I emailed my webhost.
It seems weird that they would advertise mySQL as part of the package, but not enable any permissions.

Thanks again,

Adam

[Joachim Müller]

Surely this didn't happen on purpose, they probably just made a mistake when creating your mySQL user. Things like this happen quite often, after all the server admins working for your webhost are only human.

GauGau