My SQL help

[mattpage]

I had copermine installed, and everything was great.
But I tried to install some other software, and reset the mySQL password, and now coppermine doesnt work.

I went into the cong.inc.php and changed the settings (including the password) but its still not working.
I think maybe the db name is wrong, or something else? I am not sure exacly what.

Is there a way i can revert back to my old config, and just change the password field rather than everything?

[Nibbler]

You can't revert unless you made a backup copy yourself. You'll just have to enter the correct information or create a new db user for Coppermine to use.

[mattpage]

In the config.inc.php file what should the TABLE PREFIX be set to?
I have no idea what that means.

I have double checked the password, name and localhost bits. I cant see where I am going wrong.

When I try and go to coppermine I get this error:

Notice: Undefined index: dbname in /var/www/html/coppermine/include/functions.inc.php on line 65
Coppermine critical error:
Unable to connect to database !

MySQL said: No Database Selected


I've got lost of stuff there which I really don't want to loose, so I hope I can get it sorted.

[Tranz]

You need to peek into the database and look for the coppermine tables. They likely start with cpg. You need to enter something like cpg13_ for prefix, depending on what you see in the database.

[mattpage]

when I go into the admin tools for mysql it says I don't have a database    :'(

[mattpage]

Delving a little deeper, when I go to the process list it has one entry

Kill       96080       bikeshed       localhost       None       Query       0       ---       SHOW PROCESSLIST 



Does that mean its been deleted?
I'm confused.

[Nibbler]

Ignore that. The error message tells me you probably edited the wrong bits in the file. Post what you have here, use ***** to hide the user/pass. TABLE_PREFIX must match what you chose during installation but that is not the problem.

[mattpage]

<?php
// Coppermine configuration file

// MySQL configuration
$CONFIG['localhost'] =                         'localhost';        // Your databaseserver
$CONFIG['*****'] =                         'root';        // Your mysql username
$CONFIG['******'] =                         '';                // Your mysql password
$CONFIG['bikeshed_biz_-_bsdb'] =                         'coppermine';        // Your mysql database name


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

Is that what you wanted me to post?

[Nibbler]

Yup, should look like this.

Code Select Expand


<?php
// Coppermine configuration file

// MySQL configuration
$CONFIG['dbserver'] =                         'localhost';        // Your databaseserver
$CONFIG['dbuser'] =                         '******';        // Your mysql username
$CONFIG['dbpass'] =                         '******';                // Your mysql password
$CONFIG['dbname'] =                         'bikeshed_biz_-_bsdb';        // Your mysql database name


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


[mattpage]

ahhhh! I see

Thank you!
I am still having problems mind. Access denied this time.
So I am guessing its a username or password issue.