Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: SQL Error during install  (Read 3094 times)

0 Members and 1 Guest are viewing this topic.

adamface

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
SQL Error during install
« on: August 20, 2004, 05:20:10 am »

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


Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: SQL Error during install
« Reply #1 on: August 20, 2004, 07:36:53 am »

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
Logged

adamface

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
Re: SQL Error during install
« Reply #2 on: August 20, 2004, 07:57:35 am »

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
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: SQL Error during install
« Reply #3 on: August 20, 2004, 08:02:37 am »

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
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 19 queries.