Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1046 - No database selected


Debrun

Recommended Posts

hi,

 

I had an issue

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'steven_osc1'@'localhost' (using password: YES) in /home/steven/public_html/includes/functions/database.php on line 19

Unable to connect to database server!

 

resolved this by resetting database password to password in configure.php in includes and admin/includes

 

Now get new message when I try to access site.

 

1046 - No database selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

there is only one user for database and the password is same as password in configure.php files. I can access database and browse tables - just seems to have lost link to OSC. Database name and user name are same and configure.php files reflect this.

 

Can anyone give me some clues?

Link to comment
Share on other sites

  • 2 weeks later...

Hi - did you manage to resolve this?

 

I'm trying to configure my site to run on my laptop so I can modify it offline using dreamweaver, however i've got the same problem:

 

1046 - No database selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

Link to comment
Share on other sites

Hi - did you manage to resolve this?

 

I'm trying to configure my site to run on my laptop so I can modify it offline using dreamweaver, however i've got the same problem:

 

1046 - No database selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

 

Still not resolved - still looking for help

Link to comment
Share on other sites

Still not resolved - still looking for help

 

Sorry, I managed to resolve this!

 

Basically, you need to add the user you have registered, as having access to the database.

 

I was receiving the error because the user didn't have authorisation to connect to the database.

 

I logged into my host, went to the MySQL administration pages, and found the databases and there was an 'Add User' option with a drop down box. I clicked add user, the page reloaded saying user added and hey presto the problem was resolved.

 

Let me know if this works for you, PM me if you want (you might get a quicker response :rolleyes: )

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...