Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

moved to new host, database help needed


dapaintballer3313

Recommended Posts

Posted

I used to host 2.2 ms2 on my computer, but im now using a paid host.

 

I exported the db, and imported it into the new hosting mysql database. I need to use my original 2.2 MS2 files from my computer because it is modded. I need to change database settings in the files so it works with the new mysql username, password, and database name from the new hosting. What files do I edit besides includes>configure.php. If you go to gamerssoft.com/store/ you can see what is going on. When it was on my computer there was no password for mysql. Now there is so I put that in includes>configure.php, and the error is now

 

Warning: mysql_connect(): Access denied for user: 'gamersso_@localhost' (Using password: YES) in /home/gamersso/public_html/store/includes/functions/database.php on line 19
Unable to connect to database server!

and not

Warning: mysql_connect(): Access denied for user: 'root@localhost' (Using password: NO) in /home/gamersso/public_html/store/includes/functions/database.php on line 19
Unable to connect to database server!

 

What else do i need to edit for it to connect properly?

Posted

You need to go into MySQL through you webhosting control panel and add the user/password to your database.

 

Matti

Posted
I used to host 2.2 ms2 on my computer, but im now using a paid host.

 

I exported the db, and imported it into the new hosting mysql database. I need to use my original 2.2 MS2 files from my computer because it is modded. I need  to change database settings in the files so it works with the new mysql username, password, and database name from the new hosting. What files do I edit besides includes>configure.php. If you go to gamerssoft.com/store/ you can see what is going on. When it was on my computer there was no password for mysql. Now there is so I put that in includes>configure.php, and the error is now

 

Warning: mysql_connect(): Access denied for user: 'gamersso_@localhost' (Using password: YES) in /home/gamersso/public_html/store/includes/functions/database.php on line 19
Unable to connect to database server!

and not

Warning: mysql_connect(): Access denied for user: 'root@localhost' (Using password: NO) in /home/gamersso/public_html/store/includes/functions/database.php on line 19
Unable to connect to database server!

 

What else do i need to edit for it to connect properly?

There are two config files one in admin/includes and another in catalog/includes you need to modify the data base connection parameters

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Posted
There are two config files one in admin/includes and another in catalog/includes you need to modify the data base connection parameters

 

My new config file wasn't edited enough, I didn't know the REAL directory of the store until I called my web host. Thanks everyone

Archived

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

×
×
  • Create New...