Forum

This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.
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

Remote SQL/Connect programs to database/phpmyadmin
ickie1593 Offline
Sentora Member
*
OS: Ubuntu 14.04
Version: 1.0.3
Server: VPS
Posts: 9
Threads: 6
Joined: Oct 2014
Reputation: 0
Sex: Undisclosed
Thanks: 0
Given 0 thank(s) in 0 post(s)
#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
Thanks given by:
Me.B Offline
Dev Team
******
OS: Linux/windows
Version: 1.0.3
Server: Dedicated/VPS/Cloud
Posts: 4 ,002
Threads: 193
Joined: Jul 2014
Reputation: 83
Sex: Undisclosed
Thanks: 72
Given 435 thank(s) in 395 post(s)
#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
Thanks given by:
aroaminggeek Offline
Sentora Member
*
OS: Centos 7 Minimal
Version: 1.0.3
Server: VPS
Posts: 15
Threads: 0
Joined: Jan 2017
Reputation: 0
Sex: Male
Thanks: 1
Given 6 thank(s) in 4 post(s)
#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
Thanks given by:


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 5 ,092 09-14-2021, 06:25 AM
Last Post: sparkrack
MySQL Database user prefix MosleyCale 1 5 ,665 10-17-2020, 09:11 PM
Last Post: Ron-e
Critical Error: [0100] - Unable to connect or authenticate to the Sentora database whatshisface77 1 4 ,453 07-31-2020, 10:58 AM
Last Post: whatshisface77

Forum Jump:


Users browsing this thread: 1 Guest(s)