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...
