Install script fails to log into mysql server

[bjrafferty]

I filled out the database server name, username, password, and left the persistent connections box blank, and chose database session storage.

When I submitted that, I received the following error message :
**********
A test connection made to the database was NOT successful.

The error message returned is:

Access denied for user: 'aehf@209.217.33.253' (Using password: YES)

***********

I double checked the password, and it failed again.
I was worried that the language specification drop-down box on the mysql.catalog.com homepage was the problem, so I tried using WS_FTP instead of a browser to log into mysql.catalog.com and it works fine.

The page source of the error screen shows the folowing line :
********
<input type="hidden" name="DB_SERVER" value="mysql.catalog.com"><input type="hidden" name="DB_SERVER_USERNAME" value="aehf"><input type="hidden" name="DB_SERVER_PASSWORD" value="******"><input type="hidden" name="DB_DATABASE" value="aehf"><input type="hidden" name="STORE_SESSIONS" value="mysql"><input type="hidden" name="install[]" value="database"><input type="hidden" name="install[]" value="configure">
********

It did have the CORRECT password but I have astrixed it out since this is a public forum.

Anybody have any clues ???

[michael_s]

It is not the install script. You are not specifiying either the correct username/password or database. Plain and simple. Also check that you have access to mysql...

[bjrafferty]

I use the very same username and password to log into mysql.catalog.com and succeed doing it by hand using a browser.

I just now did log in using a browser and verified that the name of the database was correct as well.

What else is there to do to check ?

[michael_s]

All I can tell you is that this error:

A test connection made to the database was NOT successful.

The error message returned is:

Access denied for user: 'aehf@209.217.33.253' (Using password: YES)

Is a mysql login error. It has nothing to do with the installer, other than the fact that the username/dbname/password combo you are using is incorrect, or the script does not have permissions to login. Check the user permissions on the database. Most likely it is something simple though. Extra space at the end of username or password, or something like that...

[peteyg]

I htought you set the db server as localhost or 127.0.0.1 then set your username password and the DB name...

[michael_s]

peteyg, good eyes! I missed that.

bjrafferty, you need to set the DB_SERVER to localhost or 127.0.0.1 . If it is not on the same server as your oscommerce installation, you need to set mysql to accept remote connections. That is the problem.

[dessel]

Hey I was having the same problems. I thought, as the instructions in the installation script say, the DB Host was supposed to be an IP so I was using mine. Turns out I had to delete it and replace it with "localhost".... worked fine.

[michael_s]

dessel, all servers are different, but if the mysql server is on the same machine as the web site, you can almost always use 'localhost' as the DB_SERVER (You shouldn't use your websites IP, unless you are also running the MySQL server on that IP).