[Solved]: Mysql

[pygmy]

what should i write or do when it says like this on the installation part...
it doesnt matter what i write in database name. get thesame all the time...

mySQL could not locate a database called '' please check the value entered for this

[Joachim Müller]

you need a mySQL database to install coppermine (see minimum requirements), and you need the connection data for the mySQL database that the installer script asks for. You can't make up things there - those vaules have to exist and be correct. Ask your webhost for the correct data (and no, you can't install mySQL on your own if you're webhosted). If you don't know the mySQL data (or you don't have mySQL at all), you simply can't install coppermine.

GauGau

[Purrsia]

Ok, I have this same problem and have searched on the board for an answer and haven't found one that works anyway. Yes, I do have mysql and yes I know the user name and password it requires - I have installed an run successfully several other databases. So I'm really stumped as to why I'm getting the cannot connect to database error. I can see the database I created for it in my control panel for my site but this script is acting like it doesn't exist. Please help!

[Casper]

please post the exact error message you are getting.

[Purrsia]

It's the same as the original poster's message:


mySQL could not locate a database called '' please check the value entered for this

To clarify, the help the first poster got was useless to me as I've already got the basic/obvious stuff looked at and double checked and it's all good. Thus, my puzzlement. I'm not a n00b when it comes to configuring databases that's why I can't understand what the problem is!

[Joachim Müller]

seems like you haven't supplied a proper database name, since '' means "no name at all" - this is of course impossible. Edit include/config.inc.php and check the settings there, should be something like

Code Select Expand

<?php
// Coppermine configuration file

// MySQL configuration
$CONFIG['dbserver'] = "localhost";        // Your databaseserver
$CONFIG['dbuser'] =   "my_db_username";        // Your mysql username
$CONFIG['dbpass'] =   "my_db_password";                // Your mysql password
$CONFIG['dbname'] =   "my_database_name";        // Your mysql database name


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

GauGau

[Purrsia]

I left the name of the database out on purpose. The database is there, trust me - the script is just not acknowledging it. All my info is correct as well. Like I said, I'm not exactly a n00b at database configuring and that's why this has got me really confused. Nothing seemingly 'obvious' is wrong.

The config file looks fine also. I'm baffled.

[Casper]

and the error message gave the name exactly as you have created it, spelling and case correct?

[Purrsia]

Yep. The name it gives me is the same one - case, format, spelling and all - that is identical to the name of the database as it sits in mysql admin panel. Can't figure this one out for the life of me.

[Casper]

Is the db server 'localhost', or do you have an actual name?  I know most seem to work fine with localhost, but mine doesn't, it need the actual name.

[Purrsia]

Well, localhost is all that was needed for the other databases I currently have successfully running on my site. I'm not sure why this one would be any different. If the localhost field was the problem, wouldn't I be getting a different or additional error message?

[Casper]

Yes you should get other messages, I was just flying a kite, as this doesn't seem to be the norm.

[Purrsia]

Wow, so I'm special!  Figures. Thanks for your help but I'm about ready to give up - I've spent all day on this. I thought the install page would be the easy part...shows what I know!

I really want an image gallery but I get tripped up with safe mode having to be off with most so you can see why I had high hopes for this one. Oh well, back to the drawing board!  :-\\

[Joachim Müller]

paste the contents of you include/config.inc.php together with a link to this thread for reference into a pm directed to me.

GauGau

[Casper]

It has occasionally happened that what looks like a good install has failed, but when re-uploaded and tried again, all goes fine.  This is rare, but why not give it a go.  It'll be worth it, if it works.

[Purrsia]

Ok, I sent the code and heck, I'll try a fresh upload too. At this point, I've nothing to lose!

[Purrsia]

The fresh upload failed to yield new results. Thanks for the idea though - it was worth trying.

[Purrsia]

Success! The problem was on my end afterall. My host changed the IP of where my control panel is located and since I was still ignorantly logging into the old control panel it wasn't working (the dp was being created but it didn't matter as I was creating it in the wrong place). Once support at my host suggested I try logging in with the updated IP, I was greated with a new panel and found that my database I'd created at the old panel indeed didn't exist there. Once I created the dp there, I got past the install page easily!

It was a simple case of an IP switcheroo it seems  Thanks for all the help - hopefully I can get the rest of this configured without bothering you anymore!