Page 1 of 1

Connecting to Mysql (remote) database

Posted: Fri Mar 16, 2018 6:20 am
by zolysoftsolutions
Hello,

I have a domain named "rombazar.com". I have a MySql database on this host.
Can I connect in some way directly to this database from a HMG application?

Thank you.
Zoli B.

Re: Connecting to Mysql (remote) database

Posted: Fri Mar 16, 2018 7:30 am
by dragancesu
If the service provider allows it

The web host is subject to attacks, and therefore administrators do not allow access to the database from the outside, when your presentation works on hosting then the database is local,

MySQL supports to access thru ip address, but this must be allowed

Re: Connecting to Mysql (remote) database

Posted: Sat Mar 17, 2018 11:35 am
by Rathinagiri
You need a PHP script to connect and access MySQL database. That is the normal and easiest way to do. There are many sample scripts available in the net.

Re: Connecting to Mysql (remote) database

Posted: Sat Mar 17, 2018 2:15 pm
by serge_girard
You need a PHP script to connect and access MySQL database.
Not always necessarily! I use it only with HMG!
All my MySQLdatabases are acceessed thru HMG.

Your provider must give access to remote or sometimes you need to mention the IP-addresses that will have access. Depends on hosting-policies>

Serge

Re: Connecting to Mysql (remote) database

Posted: Sun Mar 18, 2018 9:53 am
by Rathinagiri
Serge, yes, it is possible. But not advisable for security reasons.

Re: Connecting to Mysql (remote) database

Posted: Sun Mar 18, 2018 4:09 pm
by serge_girard
Rathi, can you explain why not and how you do the PHP piece?

Thx, Serge