Connecting to Mysql (remote) database

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

Post Reply
User avatar
zolysoftsolutions
Posts: 106
Joined: Wed Feb 29, 2012 3:33 am
Location: Gyulakuta, Erdélyország
Contact:

Connecting to Mysql (remote) database

Post by zolysoftsolutions » Fri Mar 16, 2018 6:20 am

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.
_______________________________
Open eyes for you!

User avatar
dragancesu
Posts: 569
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 14 times
Been thanked: 101 times

Post by dragancesu » Fri Mar 16, 2018 7:30 am

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

User avatar
Rathinagiri
Posts: 5243
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 162 times
Been thanked: 161 times
Contact:

Post by Rathinagiri » Sat Mar 17, 2018 11:35 am

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.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
serge_girard
Posts: 2120
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Has thanked: 437 times
Been thanked: 95 times
Contact:

Post by serge_girard » Sat Mar 17, 2018 2:15 pm

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

User avatar
Rathinagiri
Posts: 5243
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 162 times
Been thanked: 161 times
Contact:

Post by Rathinagiri » Sun Mar 18, 2018 9:53 am

Serge, yes, it is possible. But not advisable for security reasons.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
serge_girard
Posts: 2120
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Has thanked: 437 times
Been thanked: 95 times
Contact:

Post by serge_girard » Sun Mar 18, 2018 4:09 pm

Rathi, can you explain why not and how you do the PHP piece?

Thx, Serge

Post Reply