Help with MySQL for coopermine‏

[manda789]

I'm not sure if this is the right spot to post this.

While I was installing the media section I couldnt remember my password for the one user so I made another one. I just figured Id delete the first one and now my gallery is gone. This is what it says when you go R-mendes.net/photos

Coppermine critical error:
Unable to connect to database !

MySQL said: Access denied for user 'rmendes_Manda'@'localhost' (using password: YES)

Can someone please help me?

[Jeff Bailey]

http://documentation.coppermine-gallery.net/en/install.htm#what
http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#install_what

If you should change your mysql database details later (i.e. if you change the password of your mysql user account or if you migrate your gallery to another server), you will need to edit include/config.inc.php manually to reflect the changes.

[manda789]

Thank you!
Now im just a little lost on how to do that

[Jeff Bailey]

Navigate to http://r-mendes.net/photos/include/config.inc.php with your FTP application.
Download the file and edit it with a plain-text editor like notepad or notepad++.
Upload it back into http://r-mendes.net/photos/include/ with your ftp application.

[manda789]

This is what it says. What should I add, the username and password?

<?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'] =                'cpg14x_';
?>

[Jeff Bailey]

Yes, make sure it is in the quotes and don't forget the database name.

Code Select Expand

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


// MySQL TABLE NAMES PREFIX
$CONFIG['TABLE_PREFIX'] =                'cpg14x_';
?>

[manda789]

It worked! Thank you so much!

[Jeff Bailey]

No problem.
Please resolve your thread. http://forum.coppermine-gallery.net/index.php/topic,55415.msg270631.html#msg270631