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.
Connecting to Mysql (remote) database
Moderator: Rathinagiri
- zolysoftsolutions
- Posts: 139
- Joined: Wed Feb 29, 2012 3:33 am
- Location: Gyulakuta, Erdélyország
- Contact:
Connecting to Mysql (remote) database
_______________________________
Open eyes for you!
Open eyes for you!
- dragancesu
- Posts: 921
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
Re: Connecting to Mysql (remote) database
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
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
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: Connecting to Mysql (remote) database
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.
South or North HMG is worth.
...the possibilities are endless.
- serge_girard
- Posts: 3166
- Joined: Sun Nov 25, 2012 2:44 pm
- DBs Used: 1 MySQL - MariaDB
2 DBF - Location: Belgium
- Contact:
Re: Connecting to Mysql (remote) database
Not always necessarily! I use it only with HMG!You need a PHP script to connect and access MySQL database.
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
There's nothing you can do that can't be done...
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: Connecting to Mysql (remote) database
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.
South or North HMG is worth.
...the possibilities are endless.
- serge_girard
- Posts: 3166
- Joined: Sun Nov 25, 2012 2:44 pm
- DBs Used: 1 MySQL - MariaDB
2 DBF - Location: Belgium
- Contact:
Re: Connecting to Mysql (remote) database
Rathi, can you explain why not and how you do the PHP piece?
Thx, Serge
Thx, Serge
There's nothing you can do that can't be done...