Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MySQL Connection Failed: Access denied


Aqua121

Recommended Posts

I just installed 2.2MS1

during the installation when tested database, it was fine.

Now when going to the Admin, it gives me this error: :shocked:

 

 

Warning: Access denied for user: 'mysql@localhost' (Using password: NO) in /home/user/catalog/admin/includes/functions/database.php on line 19

 

Warning: MySQL Connection Failed: Access denied for user: 'mysql@localhost' (Using password: NO) in /home/user/catalog/admin/includes/functions/database.php on line 19

Unable to connect to database server!

 

 

I'm puzzled...

does any1 have a clue what's happening here?

Cheers,

Susan

 

* * * * *

Find a way, or make one!

Link to comment
Share on other sites

For some reason the configuration for MySQL in admin/includes/configuration.php is incorrect - edit that file by hand and fill in the correct database details....

 

  define('DB_SERVER', 'localhost');

 define('DB_SERVER_USERNAME', 'your_username');

 define('DB_SERVER_PASSWORD', 'your_password');

 define('DB_DATABASE', 'your_database');

 

The error shows that the current username is 'mysql' and no password set...

Link to comment
Share on other sites

thanx DJ,

 

I made the changes and got the following error: :dontgetit:

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

 

where / how do i do that? :?

Cheers,

Susan

 

* * * * *

Find a way, or make one!

Link to comment
Share on other sites

yeah, I did that :sarcasm:

 

I also have the db all set up, with all tables etc.

and yes, used the db's name, too in the config.php as you suggested :)

 

but I'm clueless at this point :sigh:

Cheers,

Susan

 

* * * * *

Find a way, or make one!

Link to comment
Share on other sites

BTW, there's a bunch of other missing stuff in the configure.php

and fixing that up still won't help my issue... :(

 

in case any1 else need some guidance with both of the configure.php, here's a Linda's:

 

http://www.oscommerce.com/forums/viewtopic.php...ht=install+v2+2

 

 

I'm still searching....

and would appreciate any suggestion

Cheers,

Susan

 

* * * * *

Find a way, or make one!

Link to comment
Share on other sites

ALL RIGHT!

 

everything's cool! :D

 

I went through the db settings again, I guess I forgot to reload mysql after giving the user his privileges ;o)

Cheers,

Susan

 

* * * * *

Find a way, or make one!

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...