Forum

Sentora Support Forums › Sentora Forum Archives › Sentora Public Support Forums v1.0.x › General Support Forum v1.0.x v › Remote SQL/Connect programs to database/phpmyadmin

Threaded Mode
Remote SQL/Connect programs to database/phpmyadmin
ickie1593 Offline
Junior Member
**
OS: Ubuntu 14.04
Version: 1.0.3
Server: VPS
Posts: 9
Threads: 6
Joined: Oct 2014
Reputation: 0
Sex: Undisclosed
#1
Remote SQL/Connect programs to database/phpmyadmin
03-02-2017, 03:32 PM
How can I connect my programs into SQL Server of phpmyadmin made by sentora remotely? I want to point the database from my website into my programs that I created. Thanks for helping
Find
Reply
Me.B Offline
Sentora Council
*******
OS: Linux/windows
Version: 1.0.3
Server: Dedicated/VPS/Cloud
Posts: 4 ,008
Threads: 193
Joined: Jul 2014
Reputation: 83
Sex: Undisclosed
#2
RE: Remote SQL/Connect programs to database/phpmyadmin
03-03-2017, 05:54 AM
You need to bind mysql to 0.0.0.0 and ensure firewall allow port 3306 in. We don't don't advice you to do so.

M B
No support using PM (Auto adding to IGNORE list!), use the forum. 
How to ask

200$ free to start your VPS 60 days credit
Find
Reply
aroaminggeek Offline
Junior Member
*
OS: Centos 7 Minimal
Version: 1.0.3
Server: VPS
Posts: 15
Threads: 0
Joined: Jan 2017
Reputation: 0
Sex: Male
#3
RE: Remote SQL/Connect programs to database/phpmyadmin
03-03-2017, 06:07 AM (This post was last modified: 03-03-2017, 06:10 AM by aroaminggeek.)
(03-02-2017, 03:32 PM)ickie1593 Wrote: How can I connect my programs into SQL Server of phpmyadmin made by sentora remotely? I want to point the database from my website into my programs that I created. Thanks for helping

In the database user section ( Database Management > MySQL Users ), you can also try specifying a specific dB user and single IP that can connect (actually safer, IMO). Be sure to specify your computer's external IP (e.g., visit https://www.whatismyip.com to get your computer's public IP address).
I haven't done so, as I learned it's not Best Practice.
Just export your dB and load it locally if you need to work with it. Web databases are web databases for a reason...but that's just my opinion...
Find
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
[split] Can Not Log Into PHPMyAdmin or Webmail after upgrading to PHP 7.1.24 ogika 2 6 ,540 09-14-2021, 06:25 AM
Last Post: sparkrack
MySQL Database user prefix MosleyCale 1 6 ,653 10-17-2020, 09:11 PM
Last Post: Ron-e
Critical Error: [0100] - Unable to connect or authenticate to the Sentora database whatshisface77 1 5 ,439 07-31-2020, 10:58 AM
Last Post: whatshisface77

Forum Jump:


Users browsing this thread: 1 Guest(s)