Unable to connect to database! MySQL said: Access denied for user

[matheso]

Two days ago I changed my MySQL database password that Coppermine was connecting to, and this produced the error seen here: http://taskbasket.net/gallery/

So then I changed the password value in the dbconnect.php file and re-uploaded,refreshed and still didn't work. I've changed the password back to the original and no change. I've read the other threads with similar issue but they're dated 2008 and only mention to change the file include/config.inc.php .. but this doesn't exist in 1.5 !

Why can't Coppermine connect even though settings are correct?? Thank you

[Krys]

Hello,

The include/config.inc.php file does exist in Coppermine 1.5. However, I can't find the dbconnect.php file in my installation (which is using the latest 1.5.34 release). How did you install your Coppermine?

[matheso]

I followed the 10-step installation process as defined by the docs. I didn't know there were other ways..

What can I do??

[allvip]

gallery/incude/config.inc.php:

Code Select Expand


<?php
// Coppermine configuration file
// MySQL configuration
$CONFIG['dbserver'] =                         'localhost';        // Your database server
$CONFIG['dbuser'] =                         ' ';        // Your mysql username
$CONFIG['dbpass'] =                         ' ';                // Your mysql password
$CONFIG['dbname'] =                         ' ';        // Your mysql database name


// MySQL TABLE NAMES PREFIX
$CONFIG['TABLE_PREFIX'] =                'cpg15x_';


FOR dbuser you use the same username you use when you login in your host control panel.
Same for pass.
dbname - the database you use for coppemine when you install it.

In your host Cpanel you have phpMyAdmin.

I post it in the french forum attachment, that should help you: http://forum.coppermine-gallery.net/index.php/topic,77958.0.html.

[allvip]

Like Krys said, there is no dbconnect.php.
To change pasword to a database you use MySql databases button (tool) in you host Cpanel.
Once you change the password to coppermine database, you go to /incude/config.inc.php and change the password even there.

[Αndré]

The file include/config.inc.php is generated by the installer. The other file was never used to store the database connection info since I use Coppermine (over 10 years now), if I remember correctly. So you need to enter valid data to include/config.inc.php.

[matheso]

Thanks guys! It's solved now, I created config.ing.php using the code given above. As always, very helpful support! Take care