janggu Posted June 8, 2004 Posted June 8, 2004 Hello, I installed osCommerce on my web server and was able to shop and order a few items. However, when I tried to go to Admin area, I am getting the following error. ------------------------------------- Warning: mysql_connect(): Access denied for user: 'mysql@localhost' (Using password: NO) in /home/www/shopnow/admin/includes/functions/database.php on line 19 Unable to connect to database server! ----------------------------------- It doesn't make any sense to me because if the database was not set up properly, I should have got some kind of error in the front end. I double checked my user name and password and they seem fine. Please help!
241 Posted June 8, 2004 Posted June 8, 2004 Warning: mysql_connect(): Host '******' is not allowed to connect to this MySQL server in *:\******\www\*****\******\includes\functions\database.php on line 19 Unable to connect to database server! This indicates the wrong server DB_SERVER information in the configure.php files Warning: mysql_connect(): Access denied for user: '****@*****' (Using password: *****) in *:\******\www\*****\******\includes\functions\database.php on line 19 Unable to connect to database server! This indicates the wrong username DB_SERVER_USERNAME or password DB_SERVER_PASSWORD information in the configure.php files 1046 - No Database Selected select configuration_key as cfgKey, configuration_value as cfgValue from configuration This indicates that either no database has been created or the wrong database name DB_DATABASE exists in the configure.php files This would make your initial assumption correct, so make sure that you have exactly the same database information in both configure.php files including case sensitivity No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes.
janggu Posted June 8, 2004 Author Posted June 8, 2004 Thanks for your help. Where do I change the following. -------------------------------------------------------- select configuration_key as cfgKey, configuration_value as cfgValue from configuration --------------------------------------------------------
ozcsys Posted June 8, 2004 Posted June 8, 2004 Thanks for your help. Where do I change the following.-------------------------------------------------------- select configuration_key as cfgKey, configuration_value as cfgValue from configuration -------------------------------------------------------- If your front end is working the problem is in your admin/includes/configure.php file You need to look at the database info and make sure it matches what is in your includes/configure.php file The Knowledge Base is a wonderful thing. Do you have a problem? Have you checked out Common Problems? There are many very useful osC Contributions Are you having trouble with a installed contribution? Have you checked out the support thread found Here BACKUP BACKUP BACKUP!!! You did backup, right??
janggu Posted June 8, 2004 Author Posted June 8, 2004 Thanks a lot. I checked "admin/includes/configure.php" and it was not populated. Could I just replace it with "includes/configure.php" or copy over whole thing?
241 Posted June 8, 2004 Posted June 8, 2004 no they are different files, the only part the same is the bottom section with the database information, this part can be copied. No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.