Extern access to database?

J

Jirendi

New member
Joined
Sep 30, 2008
Messages
2
Hey is it possible to fix so i can instead of localhost use like mysql.mydomain.tld instead and connect to a database from another server? if its possible how? And also would it be possible to fix so if you go to mysql.mydomain.tld and phpmyadmin will be shown there?

Hope you understand what i mean. Im using a vps with directadmin.
 
Yes. You'll have to open the required port in your firewalls, bidirectional, on both sides, and create rights in the database to allow it as well. It's been discussed on these forums before.

Jeff
 
Hello,

Im making a project on school.
But i cant change anything in the firewalls.
Is it possible to do this another way??

greetings Dennis.
 
First you have to check your logs to make sure the firewall is the problem. If it's not, you can add to each database the rights for external access. (Read a mysql manual for that; I'm not an expert at mysql. The information may very well be found on these forums.)

If it is the firewall, then if you're the server admin you can set up a proxy to run on a port your school allows, and connect to the database. In fact you can do this rather than give access to the database(s) for remote access if that's what you want to do.

Jeff
 
On my server it's in the /var/log/messages log; your server may differ.

Jeff
 
You must log in or register to reply here.
Back
Top