Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Need help with a SQL error


Toorqs

Recommended Posts

Posted

This is unrelated to OSC, but i hope to get some help afterall.

 

I lost my phpmyadmin password, so i reset it (it also reset my SQL pass)

When i now try to view my site, i get the message Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'kremsykkel.no'@'cnoa05.cliche.no' (using password: YES)

I recon i need to input the new password somewhere, but i dont know where.

Atm my shop is dead, so any quick help is very apreciated.

 

From database.php

if (USE_PCONNECT == 'true') {

$$link = mysql_pconnect($server, $username, $password);

} else {

$$link = mysql_connect($server, $username, $password);

Posted

Magnus,

 

 

Check the database password associated with your OSC site. Ensure the password in the TWO configure.php files are the same as the password used on your database.

 

 

Chris

Posted

This is unrelated to OSC, but i hope to get some help afterall.

 

I lost my phpmyadmin password, so i reset it (it also reset my SQL pass)

When i now try to view my site, i get the message Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'kremsykkel.no'@'cnoa05.cliche.no' (using password: YES)

I recon i need to input the new password somewhere, but i dont know where.

Atm my shop is dead, so any quick help is very apreciated.

 

From database.php

if (USE_PCONNECT == 'true') {

$$link = mysql_pconnect($server, $username, $password);

} else {

$$link = mysql_connect($server, $username, $password);

/catalog/includes/configure.php

 

define('DB_SERVER_PASSWORD', 'PASSWORD_HERE');

Need to change /admin/includes/configure.php also

If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Archived

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

×
×
  • Create New...