Coppermine setup error - SELECT command denied

Discussion in 'Troubleshooting' started by buffpam, Jan 19, 2007.

  1. buffpam

    buffpam New Member

    Joined:
    Jan 17, 2007
    Messages:
    11
    The install instructions for coppermine are pretty short (and really need clarification,) - there is also no troubleshooting information.

    How do I correct the error:

    Coppermine Db and Prefix - incorrect value. Error: SELECT command denied to user 'bright48_amember'@'localhost' for table 'cpg_users'

    What value is incorrect? Is there in fact an incorrect value, or was the connection denied by mySql?

    My Coppermine Db and Prefix is bright48_copp1.cpg_, and that's what I have entered in the appropriate space.

    Perhaps, in addition to clarification, the instructions need some reformatting. All that displays is one huge paragraph, no line breaks - example:

    "Coppermine Plugin Coppermine Plugin is designed to provide single-signon access for users of aMember Pro and Coppermine. Installation 1 - Enable plugin at aMember CP -> Setup/Configuration -> Plugins 2 - Configure plugin at aMember CP -> Setup/Comfiguration -> Coppermine 3 - Place file amember.inc.php within /coppermine/bridge/ folder, where /coppermine/ -- folder where your Coppermine script installed."

    What is coppermine 3? :) Plugins 2? ;) What is a "Comfiguration" :eek: Where is amember.inc.php located?

    Seriously, Where is amember.inc.php located, and how do I fix the database error?

    Rick Drew
  2. buffpam

    buffpam New Member

    Joined:
    Jan 17, 2007
    Messages:
    11
    I found the solution - What you need to do is add aMember as a member in the coppermine database with full access / all priviliges. Once aMember is added as a USER then the database settings worked.

Share This Page