Syskay Systems Forum

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.

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.)

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.

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

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

Which site is the remote server located?

www.digxi.com

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.

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.

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.

Thanks very much it connected.

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.

You can simply repeat the hostname values that i imputed. That should work fine as long as your internet connection remains starcomms.

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

The hostname is simply the IP address of the computer you are connecting with.

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?

Under "Database", Click on "Remote MySQL".

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.

If you are connecting from another computer, you can enter the appropriate hostname/IP for that host.

Thanks a lot.

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.