Remote Connection to MySQL [Archive]

View Full Version : Remote Connection to MySQL

CrazyaZnBoii

January 10th, 2006, 19:37

I have MySQL 4.1 running on Linux, I don't know how to enable remote access. Can someone teach me please.

Thank you,
CrazyaZnBoii

stuffradio

January 10th, 2006, 20:54

Do you want people to be able to see a virtual desktop, command line like SSH or something like phpMyAdmin?

kabatak

January 10th, 2006, 21:19

If you have cpanel, there is an option at the database settings "Access hosts"

Decker

January 10th, 2006, 22:09

Lot more needed - and you will have to ensure an open port dependant on your connection method (LAN, ADSL, dial-up, etc.)

CrazyaZnBoii

January 11th, 2006, 21:52

It's just an MySQL server hosted at my house. So I don't have Cpanel but I have phpMyAdmin running on apache 2. My port (3306) is open.

Regards,
CrazyaZnBoii

stuffradio

January 12th, 2006, 00:19

So what's the question than? Do you know how to access your webserver from outside of your localhost? You should be able to go to http://www.showmyip.com than what ever the ip shows at that site is your IP people can use to access it, so it'd be http://youriphere and you can also go to http://dyndns.org and register for a name there and point it to your ip address, than people can go to http://yourname.dyndns.org.

CrazyaZnBoii

January 12th, 2006, 19:38

Nahhh, I know how thing works but I use to host on windows so it work fine and then when I switched to linux I couldnt do remote access anymore =/ I dont know why.

Tree

January 12th, 2006, 20:15

Something's up with your configuration on something. Do you allow connections on port 3306 after the OS change?

What version of Linux are you using?

CrazyaZnBoii

January 17th, 2006, 18:36

I have Linux Ubuntu.

Tree

January 17th, 2006, 19:44

Ubuntu? I've never heard of it, so I can't really help you. Does it come with a GUI like GNOME or KDE? If so, just look around in the network part and make sure the MySQL port is open.

Brandon

January 17th, 2006, 20:45

Ubuntu? I've never heard of it, so I can't really help you. Does it come with a GUI like GNOME or KDE? If so, just look around in the network part and make sure the MySQL port is open.
Depends on the Ubuntu version...from my knowledge there is GNOME ubuntu and KDE kubuntu....

DirDir

January 18th, 2006, 15:16

Nahhh, I know how thing works but I use to host on windows so it work fine and then when I switched to linux I couldnt do remote access anymore =/ I dont know why.

You should try installing Webmin, it's a local administration software like Cpanel. Although I am using Fedora, when you first install Ubuntu, it might be activating the firewall and closing the MySql port. I suggest you first check if firewall is on and if it's then check the rules.

Decker

January 18th, 2006, 15:47

Or just get used to remote access through linux - bit to complex to get into here but look up 'linux remote control' or 'vnc - which comes as part of most Linux distros' on google - you'll find VNC.

Download and install is easy and a real ease to use too.

Then you can be actually be at the machine, rather than just remote services.

So really no need to install on the server if it was a typical install and any remote system would require about 2 minutes.

DirDir

January 18th, 2006, 15:53