Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Again... Access denied for user '2morrow'@'localhost' (using password: YES).....


Snade

Recommended Posts

My problem is slightly different.

I payed to webdesign company to make oscomerce web site becouse I have basic knowedge in "computers"(if you understand me) but they want additional money to put some add-ons. SO i want to try by myself. Becouse I already paid 700$ for the web site and I don't want to fuck it, they gave it to me zipped to do what I want on my computer and then upload the final version.

 

To run the site I had to download Mysql and Apache... and I found Xampp - program that has all in it and I only have to run it to have apache and mysql working.So the program is working the site is loading but whit this error - Warning: mysql_connect() [function.mysql-connect]: Access denied for user '2morrow'@'localhost' (using password: YES) in D:\Programs\xampp\xampp\htdocs\includes\functions\database.php on line 19

Unable to connect to database server!

 

I think that the problem is in the msql settings, becouse the "server" is different, and I tried to change username and password in mysql/scripts/msqlaccess.conf file whit the same from both includes/config files in oscommerce.Also i changed the localhost to 127.0.0.1 in the config files.

 

Nothing helped at all. What I'm missing ?

 

The site is working on their server but on my local machine not.What I have to do to get it working ?

 

if it's possible how can I change this -> using password to NO only for trying to add some addons. Also where I can see the right username and password for accesing the database.

I have both, the server and the web site, so somewhere in the files I have to have same username and password, but in which files...

 

Please, if someone help me, when you say what to change, tell me in which file I have to chage it.Don't forget that I have basic knowledge and I'm not so familiar whit oscommerce.

 

10x alot in advance and sorry for the long and borring topic :)

 

Have a nice day :)

Link to comment
Share on other sites

Are you sure the login is '2morrow'@'localhost' and not 2morrow or localhost_2morrow?

 

The error indicates incorrect login or password, so mess around with those.

Link to comment
Share on other sites

Are you sure the login is '2morrow'@'localhost' and not 2morrow or localhost_2morrow?

 

The error indicates incorrect login or password, so mess around with those.

 

I am having similar problems as I just updated my passwords in cpanel and also ticked the: Change my domain database password - option... Apparently my domain database password is not correct at the moment. How do I change this? I cannot go to the cpanel and change it back, because my service provicer has put in more restrictions to the new passwords than in the previous one :( Is there another way to do it than in the cpanel?

 

I get this while trying to access my web page:

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'xxxxx'@'xxxxx.com' (using password: YES) in /home3/xxxxx/xxxxx-www/catalog/includes/functions/database.php on line 19

Unable to connect to database server!

Link to comment
Share on other sites

I am having similar problems as I just updated my passwords in cpanel and also ticked the: Change my domain database password - option... Apparently my domain database password is not correct at the moment. How do I change this? I cannot go to the cpanel and change it back, because my service provicer has put in more restrictions to the new passwords than in the previous one :( Is there another way to do it than in the cpanel?

 

I get this while trying to access my web page:

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'xxxxx'@'xxxxx.com' (using password: YES) in /home3/xxxxx/xxxxx-www/catalog/includes/functions/database.php on line 19

Unable to connect to database server!

 

If your host uses cpanel or similar login into it, then choose `Site Tools` then `Database Manager` then next to your database click `admin` then click `Password`

 

The current user name password should be displayed something like this:

user1232143:pass321j

 

make sure these are the ones in your configuration files (ie. catalog/includes/configure.php and catalog/admin/includes/configure.php)

 

 

~~~Tapuahk

Link to comment
Share on other sites

I am having similar problems as I just updated my passwords in cpanel and also ticked the: Change my domain database password - option... Apparently my domain database password is not correct at the moment. How do I change this? I cannot go to the cpanel and change it back, because my service provicer has put in more restrictions to the new passwords than in the previous one :( Is there another way to do it than in the cpanel?

 

I get this while trying to access my web page:

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'xxxxx'@'xxxxx.com' (using password: YES) in /home3/xxxxx/xxxxx-www/catalog/includes/functions/database.php on line 19

Unable to connect to database server!

 

Got this working by changing the two configure files to match the new password set to the database. Back online with the website...

 

Snade, you could try to go to the CPANEL (login to your domain) and see if you can change the database password from there. You can also look if you have a Database Manager on you CPANEL at your domain and look at the usernames... My database username was the same as the Domain user name.

 

p

 

http://www.oscommerce.info/kb/osCommerce/G...mon_Problems/69

Link to comment
Share on other sites

Got this working by changing the two configure files to match the new password set to the database. Back online with the website...

 

Snade, you could try to go to the CPANEL (login to your domain) and see if you can change the database password from there. You can also look if you have a Database Manager on you CPANEL at your domain and look at the usernames... My database username was the same as the Domain user name.

 

p

 

http://www.oscommerce.info/kb/osCommerce/G...mon_Problems/69

 

 

 

Got it working, thanks for the tip ~~~Tapuahk

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...