I am expecting your reply please

it is still starcomms, but a new laptop and a new data card. the other one was stolen

Good evening.

I had one time connected remotely to my database on my website (www.digxi.com) through your help, but I could no longer do this anymore. I have tried every thing possible, and I keep on getting this error [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'www.digxi.com' (10060). What should I do?

I had earlier connected remotely with your help on a different computer, but i tried the same on another but didn't connect. I was getting this error [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'www.digxi.com' (10060). Please what should I do.

Thanks a lot.

Thanks I saw the settings now. I'll try it on the other sites I manage. And does that means that I can only connect remotely on this my computer.

What I mean is where would I input the IP address? I tried to see it there is any place to input hostname in the system administrative tool that I used to connect, but there was no place for hostname. So am asking how do I get to the place you said I should input the hostname?

Pls, where did you input the hostname and what hostname did you input.

Thanks once again, where and how do I supply hostname for the connecting database under "Remote Database Access Hosts, should incase I need to connect on another domain, as I have another domain with you and would register another next week.

Thanks very much it connected.

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.

www.digxi.com

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

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.

It tried to connect remotely to the database I created on my website using MySQL ODBC 3.51 Driver, but access was denied to my username. What do you think is wrong and how do I connect. I accessed the connector through control panel > performance and maintenance > Administrative Tools > data sources(ODBC) > MySQL ODBC 3.51 > then I filled in the parameters.