Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Help with MySQL for coopermine‏  (Read 4807 times)

0 Members and 1 Guest are viewing this topic.

manda789

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Help with MySQL for coopermine‏
« 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?
Logged

Jeff Bailey

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1322
  • Fishing relaxes me.
    • Bailey Family Co.
Re: Help with MySQL for coopermine‏
« Reply #1 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.
« Last Edit: October 15, 2010, 03:59:58 am by Jeff Bailey »
Logged
Thinking is the hardest work there is, which is probably the reason why so few engage in it. - Henry Ford

manda789

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Help with MySQL for coopermine‏
« Reply #2 on: October 15, 2010, 03:52:24 am »

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

Jeff Bailey

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1322
  • Fishing relaxes me.
    • Bailey Family Co.
Re: Help with MySQL for coopermine‏
« Reply #3 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.
Logged
Thinking is the hardest work there is, which is probably the reason why so few engage in it. - Henry Ford

manda789

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Help with MySQL for coopermine‏
« Reply #4 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_';
?>
Logged

Jeff Bailey

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1322
  • Fishing relaxes me.
    • Bailey Family Co.
Re: Help with MySQL for coopermine‏
« Reply #5 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_';
?>
Logged
Thinking is the hardest work there is, which is probably the reason why so few engage in it. - Henry Ford

manda789

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Help with MySQL for coopermine‏
« Reply #6 on: October 15, 2010, 04:13:31 am »

It worked! Thank you so much!
Logged

Jeff Bailey

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1322
  • Fishing relaxes me.
    • Bailey Family Co.
Re: Help with MySQL for coopermine‏
« Reply #7 on: October 15, 2010, 04:16:42 am »

Logged
Thinking is the hardest work there is, which is probably the reason why so few engage in it. - Henry Ford
Pages: [1]   Go Up
 

Page created in 0.032 seconds with 20 queries.