Setting up Database

[Chezmoi]

Hi,

I have trouble setting up a database for .php

The script asks for:

-Database server: 209.xxx.xxx.xxx
- Username: user_name
- Password: xxxxxxx
- Database name: user_data

* * *

And I always get this message:

"A test connection made to the database was NOT successful.

The error message returned is:

Access denied for user: '[email protected]' (Using password: YES)

Please click on the Back button below to review your database server settings.

If you require help with your database server settings, please consult your hosting company."


Could you help me? Thank you!

 

[jmstacey]

If you not connection to the database using localhost or http://127.0.0.1 you will need to add the IP address of the script attempting to access the database.

MySQL Management, then click on the database your tyring to connect to and on the bottom of the page you can add the necassary host to the allowed hosts list.

If the MySQL server is on the same server as your script, then change the database server setting accordingly.

 

[jmstacey]

However from seeing other posts by you on this same issue.
If you are recieving this error from DirectAdmin itself, then you need to sync passwords.

 

[Chezmoi]

My hosting finally referred me to the Installtron program to install oscommerce for me... It worked fine... All I will need to do now is to configure it... and to find a way to put it on my main page (right now it is in the www.site.ext/catalog/ repertory). Would you know how to do this?

Thank you!