Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Access denied for user: 'ODBC@localhost' (Using password: NO)


kshitij_ahuja

Recommended Posts

Posted

hi guys

just this stupid error is troubling me...

i am using easy php which has apache installed....

when i try to register with my server name, i get this error..

 

Access denied for user: 'ODBC@localhost' (Using password: NO)

 

kindly let me know what shall enter in the dbase server field....

tried lot of things but failed...

 

thanks

  • 3 weeks later...
Posted

Ive had some problems like this.

 

I think my solution was that every sql database needs a user assigned to it before you can access it.

 

In /catalog/includes/configure.php at the bottom it says

 

// define our database connection

define('DB_SERVER', 'localhost');

define('DB_SERVER_USERNAME', 'triplex_osc1');

define('DB_SERVER_PASSWORD', '!!not telling!!');

define('DB_DATABASE', 'triplex_osc1');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', 'mysql');

?>

 

(it says the same in /catalog/admin/includes/configure.php

 

You will have to make a user , in my case, named osc1 (the triplex_ automatically puts itself there) and use the password !!not telling!!

 

Make sure your database is named correctly too, to be honest I dont know how important it is but I did and it sorted my problem.

 

Also, when I restored like this it took a while ( only 5 mins or so) for the database to become usable. Up untill then I got the error you are getting.

 

Hope I havent totally confused you, Im not too competant with OSC but I fixed this one! I had to, it would be a weeks work binned otherwise!

Posted
hi guys

just this stupid error is troubling me...

i am using easy php which has apache installed....

when i try to register with my server name, i get this error..

 

Access denied for user: 'ODBC@localhost' (Using password: NO)

 

kindly let me know what shall enter in the dbase server field....

tried lot of things but failed...

 

thanks

 

This isnt the correct place to ask support questions... there is a section called general support where this should be asked.

Posted

For Easyphp working locally, just use 'localhost' as the database server, 'root' as the user and leave the password field blank.

 

Your web address will be: http://localhost/catalog/

 

Matti

Archived

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

×
×
  • Create New...