New Install!

[SundayNiagara]

Hi:
    New guy here.  I just uploaded all the files, started the install and thought I did everything correctly, including setting up the db.  Well, this is what I get:  Could not create a mySQL connection, please check the SQL values entered

MySQL error was : Access denied for user: 'sundayni_@localhost' (Using password: YES)

I'd appreciate a little help.
Mark

[Tranz]

Make sure you add the user to the db, which is a separate process from creating the user.

[SundayNiagara]

Done that, problem still exists.
Mark

[SundayNiagara]

Anyone?  I can install via Fantastico, but would prefer doing it manually, for the experience.
Mark

[kegobeer]

First, this isn't a hotline.  Bumping a reply after only a few hours is very bad form.

Second, have you verified that your database information (database server, database user, database password, database name) is correct?  This isn't a Coppermine issue, it's a MySQL issue.  Coppermine can't connect because that user is being denied access to the database.

http://dev.mysql.com/doc/mysql/en/access-denied.html

[SundayNiagara]

Everything appears to be correct.  My question now is, this:  cpg133_  Do I change this, or does it stay the same.? The instructions are vague on this.
Mark

[kegobeer]

cpg133_ is the table prefix, it has nothing to do with connecting to the database.  Unless you have other tables in your database with a prefix of cpg133_, you don't need to change it.

Coppermine uses the information you provide to establish a connection to your database server, authenticate, and access the correct database.  Go here and use that test script to see if you can access your database.

[SundayNiagara]

I figured it out, there was an extra character in the userid.  Thanks for your help..
Mark