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?
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.
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.
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.
when I go into the admin tools for mysql it says I don't have a database ??? :'(
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.
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.
<?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?
Yup, should look like this.
<?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_';
?>
ahhhh! I see ;D
Thank you!
I am still having problems mind. Access denied this time.
So I am guessing its a username or password issue.