hollywooood Posted May 9, 2008 Posted May 9, 2008 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!
♥geoffreywalton Posted May 9, 2008 Posted May 9, 2008 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 ======>>>>>.
hollywooood Posted May 9, 2008 Author Posted May 9, 2008 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?
♥geoffreywalton Posted May 9, 2008 Posted May 9, 2008 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 ======>>>>>.
hollywooood Posted May 9, 2008 Author Posted May 9, 2008 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?
Guest Posted May 9, 2008 Posted May 9, 2008 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.
hollywooood Posted May 9, 2008 Author Posted May 9, 2008 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!
Recommended Posts
Archived
This topic is now archived and is closed to further replies.