forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: manda789 on October 15, 2010, 02:53:46 am

Title: Help with MySQL for coopermine‏
Post by: manda789 on October 15, 2010, 02:53:46 am

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

Quote

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?

Title: Re: Help with MySQL for coopermine‏
Post by: Jeff Bailey on October 15, 2010, 03:44:34 am

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

Quote

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.

Title: Re: Help with MySQL for coopermine‏
Post by: manda789 on October 15, 2010, 03:52:24 am

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

Title: Re: Help with MySQL for coopermine‏
Post by: Jeff Bailey on October 15, 2010, 03:57:53 am

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.

Title: Re: Help with MySQL for coopermine‏
Post by: manda789 on October 15, 2010, 04:01:19 am

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

Quote

<?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_';
?>

Title: Re: Help with MySQL for coopermine‏
Post by: Jeff Bailey on October 15, 2010, 04:04:38 am

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

Code: [Select]

<?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_';
?>

Title: Re: Help with MySQL for coopermine‏
Post by: manda789 on October 15, 2010, 04:13:31 am

It worked! Thank you so much!

Title: Re: Help with MySQL for coopermine‏
Post by: Jeff Bailey on October 15, 2010, 04:16:42 am

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