coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Installation & Setup => Topic started by: SundayNiagara on July 06, 2005, 01:03:03 AM

Title: New Install!
Post by: SundayNiagara on July 06, 2005, 01:03:03 AM
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
Title: Re: New Install!
Post by: Tranz on July 06, 2005, 06:36:19 AM
Make sure you add the user to the db, which is a separate process from creating the user.
Title: Re: New Install!
Post by: SundayNiagara on July 06, 2005, 02:32:35 PM
Done that, problem still exists.
Mark
Title: Re: New Install!
Post by: SundayNiagara on July 06, 2005, 11:31:39 PM
Anyone?  I can install via Fantastico, but would prefer doing it manually, for the experience.
Mark
Title: Re: New Install!
Post by: kegobeer on July 06, 2005, 11:37:31 PM
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
Title: Re: New Install!
Post by: SundayNiagara on July 07, 2005, 01:33:15 AM
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
Title: Re: New Install!
Post by: kegobeer on July 07, 2005, 03:05:31 AM
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 (http://forum.coppermine-gallery.net/index.php?topic=16217.msg75687;topicseen#msg75687) and use that test script to see if you can access your database.
Title: Re: New Install!
Post by: SundayNiagara on July 07, 2005, 03:20:48 PM
I figured it out, there was an extra character in the userid.  Thanks for your help..
Mark