1046 - No Database Selected.. HEEEELP!

[ashlyn]

I have a bit of a problem with the database connection. My client has the server name "user-nam" and when I added a database, it created it as usernam_store instead of user-nam_store. Now I can't connect to the database, got a "denied" on install and manually changing the congiguration.php files doesnt' work either. I have uploaded the .sql file and that seems ok, just nothing working in the cart or admin. I get this message only..

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

When I created the user for the database, it put the - in, so user is user-nam_user, but I'm still denied access.

 

Is there somewhere else that I can set the database?

 

The config looks like this..

 

// define our database connection

define('DB_SERVER', 'localhost'); // eg, localhost - should not be NULL for productive servers

define('DB_SERVER_USERNAME', 'user-nam_user');

define('DB_SERVER_PASSWORD', 'XXXXXX');

define('DB_DATABASE', 'user-nam_store'); (DATABASE IS ACTUALLY usernam_store)

define('USE_PCONNECT', 'true'); // use persistent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

[♥monte22]

You need to configuration file to match your database. So if your database name "is usernam_store", you have to have that in your configure file instead of "user-nam_store".

 

Hope this helps

[ashlyn]

I've tried it both ways with the same result. No luck.. :cry: