[Solved]: Error connecting to MySQL

[rrace]

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

[Joachim Müller]

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:

Code Select Expand

INSERT INTO yourCoppermineTablePrefix_users VALUES (1, 1, 'YES', 'adminUsername', 'adminPassword');

GauGau

[rrace]

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

[Joachim Müller]

sent you a pm.

GauGau

[rrace]

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.

[Joachim Müller]

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