Recent Posts

After examining your situation, I discovered that you did not supply any hostname for the connecting database under "Remote Database Access Hosts". I have imputed the appropriate values. Please try again now and let me know the response.

please i am new to cms and i realy must know how to apply them to my web pages to make them easily updatable

It is not a script but a way to connect to a databases using the systems administrative tool. To connect to mysql server you will need to have mysql-odbc-connector installed.

To use this tool you'll, begin from the systems control panel
click Performance and Maintenance
click Administrative Tools
click Data Sources (odbc) shortcut
From the form displayed click add button if mysql connector is not displayed
Double click on the mysql connector in the list
Set the connection parameters to connect to the server then click test button to test the connection
click diagnostics button to view error mesage.

I would be very greatful if you can help resolve this.

Hello,

Kindly give me the location of the scripts that you want to access the database, so i can have a look at it when i am less busy.

www.digxi.com

Which site is the remote server located?

I did that and gave the user all privileges, but it still did not connect

Click on MySQL Databases, under "Current Databases" you will find a table that contains all users. Click on the user to set privileges.

Yes I used the parameters as described e.g I used for example lets say I created a user xxx with password yyy and a database name zzz on my domain with my cpanelName tttco and domain www.ttt.com, the parameter i used was

MySQL Server: www.ttt.com
Username: tttco_xxx
Password: yyy
Database: tttco_zzz

on trying to connect an error like this occurred
[MySQL][ODBC 3.51 Driver]Access denied for user 'tttco_xxx'@'41.219.236.120' (using password: YES)
Could the problem be due to privileges of user to the database? and if it is, how can one address this.
Another question I have is how do one check privileges of users on the mysql database.

Please make sure your parameters are accurate. It should be of this format:

MySQL Server: your-domain.com
Username: cpanelName_mysqlUserName
Password: your-mysql-db-password
Database: cpanelName_mysqlDatabaseName

("cpanelName" is the username you use to log into CPanel.)