Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Database Config


hollywooood

Recommended Posts

Where is the file to manually change $user and $password in OSC? I am not sure where to go from database.php. My remote server adds the username_ before my databases and I cannot connect this way. Thanks in advance for any help.

 

Will

 

P.S.

 

Unless there is another way to handle:

 

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

Unable to connect to database server!

Link to comment
Share on other sites

You need to look at the mysql database, probably the best way is using phpmyadmin.

 

Check out the database names that are set up and the users and their priveliges they have to your db.

 

Your ISP helpdesk will be able to direct you to how to use phpmyadmin.

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

You need to look at the mysql database, probably the best way is using phpmyadmin.

 

Check out the database names that are set up and the users and their priveliges they have to your db.

 

Your ISP helpdesk will be able to direct you to how to use phpmyadmin.

 

MySQL adds the user name and an underscore before whatever database name I create even if I don't want it this way. Are you saying there is a way to change the way the database name is stored? My thinking was that I could go to the db connect file (wherever that is) in OSC and add the USERNAME_ before the DB name. Is this a possibility?

Link to comment
Share on other sites

You can create a db in phpmy admin with any name you want.

 

Then copy the structure and data over and set the priviliges.

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

You can create a db in phpmy admin with any name you want.

 

Then copy the structure and data over and set the priviliges.

 

 

I get you however, the server automatically ads, whatever the user name for the admin is, in front of the database name I create. I created mycart as a database name. What MySQL comes up with is mpower_mycart. It's done autmatic. Do you know where I can change the $user and $password in the OSC files?

Link to comment
Share on other sites

I get you however, the server automatically ads, whatever the user name for the admin is, in front of the database name I create. I created mycart as a database name. What MySQL comes up with is mpower_mycart. It's done autmatic. Do you know where I can change the $user and $password in the OSC files?

In the two configure.php files, in catalog/includes/ and admin/includes/

 

check also if you have extra config.php files in a includes/local/ directory in both admin and catalog. Not always installed, so if theye are not there, they are not needed.

Link to comment
Share on other sites

In the two configure.php files, in catalog/includes/ and admin/includes/

 

check also if you have extra config.php files in a includes/local/ directory in both admin and catalog. Not always installed, so if theye are not there, they are not needed.

 

Fantastic! Appreciate the help on this one Coopco!

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...