Connecting to MySQL from an external server

[gallot]

Hello,

If I am going to add Access Host under the MySQL in cPanel, what should be the hostname to use when the external server or domain will connect to the MySQL db?

[BrightAdmin]

Hi gallot,

You can add domain name or IP number of the host that you wish to add as the hostname in the Host field.

Regards,

[mass_gencliq]

I added ips like 88.%.%.%, and like 88.229.145.18.
And tried to connect from external site and program, it didn't work.
I added ips to Access Hosts list but again, it didn't work.

What must i do?????

[carlosferns2004]

Hello

Very simple just add % instead of ipaddress






Enjoy

Regards
Carlos

[plexihosting]

Also make sure the user you are using to connect has the appropriate privileges granted for the database you are connecting to. You can create a database user then assign that user privileges using the MySQL portion of cPanel or the GRANT statement as root MySQL user from the MySQL command line client. GRANT syntax is detailed in the MySQL online manuals.

[mass_gencliq]

Hello

Very simple just add % instead of ipaddress






Enjoy

Regards
Carlos

Also make sure the user you are using to connect has the appropriate privileges granted for the database you are connecting to. You can create a database user then assign that user privileges using the MySQL portion of cPanel or the GRANT statement as root MySQL user from the MySQL command line client. GRANT syntax is detailed in the MySQL online manuals.

i did them but again it didn't work

[mass_gencliq]

I looked all settings but there was no wrong setting.
Then i added the same user to the same db, then it worked.

[cpanelkenneth]

In some recent builds, the access is being granted to the database server, but tnot to any specific databases. Check your the db table in the mysql database. Make certain your user can access the database from your specified host. A query like the following should work:

SELECT User FROM db WHERE Host ='put your host name here';

In the output look for a match to your user name.

[Stefaans]

In some recent builds, the access is being granted to the database server, but not to any specific databases.

I noticed this, an found I had to reapply user access to each database to allow a new external IP. Are you saying this change is intentional, or that it is a bug?