coppermine-gallery.com/forum

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: rrace on March 17, 2004, 02:42:09 AM

Title: [Solved]: Error connecting to MySQL
Post by: rrace on March 17, 2004, 02:42:09 AM
When I try to install Coppermine, I get the following error:

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

I have checked the username and password for MySQL and they are correct.  The above login works with phpMyAdmin (just checking the server).

Any suggestions on how to get past this and get the install to complete?

I manually installed the database and uploaded the sql files.  When I try to connect ..coppermine/index.php, I still the same MySQL error message.  How do I manually insert the admin and password into the database (or would that matter at this point since it will not access the database?)

R Race
Title: [Solved]: Error connecting to MySQL
Post by: Joachim Müller on March 17, 2004, 09:27:41 AM
edit include/config.inc.php to verfy your db settings - there must be something wrong with them. If coppermine can't connect to the db, there's little point in adding the admin user manually to the db, so you'll have to get the db connection working in the first place.
To create the admin user manually, run a query like this:INSERT INTO yourCoppermineTablePrefix_users VALUES (1, 1, 'YES', 'adminUsername', 'adminPassword');

GauGau
Title: [Solved]: Error connecting to MySQL
Post by: rrace on March 18, 2004, 03:05:09 AM
At this point I am stumped.  Unless it is a setting in PHP or Apache, I don't know where to go.  I put comments in the code before the mysql_connect and the variables are correct. The code if failing to connect with the database.

Any resources for hire that could help with this code?  I don't know if Coppermine offers such setup survices.

R Race
Title: [Solved]: Error connecting to MySQL
Post by: Joachim Müller on March 18, 2004, 08:11:46 AM
sent you a pm.

GauGau
Title: [Solved]: Error connecting to MySQL
Post by: rrace on March 19, 2004, 04:05:42 AM
The problem was the php setup, register_globals needed to be true. After that it installed and worked like it should.

Nice application, well done.
Title: [Solved]: Error connecting to MySQL
Post by: Joachim Müller on March 19, 2004, 08:14:46 AM
leaving register_globals on is not recommended and should not be necessary to run coppermine if the server is set up properly. Although I'm glad to hear that you were able to solve the issue on your own, I recommend you take a further look into it.

GauGau