Need Help exposing MySQL on the Internet

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

Need Help exposing MySQL on the Internet

Postby Amine E » 25. October 2016 10:29

Hi Friends,

I have MySQL working properly locally on my iMac at home through XAMPP, but since my work requires me to travel a lot, I would like to be able to access it remotely using SequelPro from anywhere from my Macbook.

I usually keep my iMac on all the time at home, but I admit that I'm a bit concerned about how secure that could be, currently I just try to connect to it with the "Back to my Mac" feature on the macOS, but it's quite slow, and resource eating.

Not sure if someone here in the forum has already done it, in which case I would be grateful if he/she could share a "how-to".

Thanks in advance.
Amine E
 
Posts: 2
Joined: 25. October 2016 10:22
XAMPP version: 5.6.12-0
Operating System: macOS sierra

Re: Need Help exposing MySQL on the Internet

Postby Ezekiel-Mghweno » 27. October 2016 09:01

you can connect by either using a Standard connection or a Socket connection
f you cannot directly reach your server (eg. it is behind a firewall), you will have to use a SSH connection.
A standard connection is an unencrypted connection using TCP/IP. Such a connection is usually made over the network or over the internet to a remote server. To specify which server to connect to, you must provide its IP address or DNS resolvable name:

# IP Address
192.168.0.11
66.78.91.2

# DNS resolvable name
Crema.X-Serve.local
intranet.mycompany.com
mysql.webhosting.com

If you use the special address 127.0.0.1, you can connect to a server on your own computer.
Note: Some web hosting companies may give you access to MySQL running on the server that is hosting your website (often by adding your IP address to a whitelist). In this case your web host will provide you with an IP address or a domain name on a server located on the internet that has a port open for you to connect to. If this is unavailable to you, you may need to connect to MySQL via an SSH Tunnel.

Required Fields
Host Enter the host name or IP address of the host.
Username The default username for a mysql install is root
Optional Fields
Name The name you want to give the favourite.
Password The default password for a mysql install is an empty string.
If that's the case, you should change the root password right away.
Database If you enter a database, it will be selected when the connection to
the server is established.
Otherwise you can select one of the databases on the server afterwards.
Port Defaults to port 3306.
Ezekiel-Mghweno
 
Posts: 9
Joined: 10. October 2016 12:23
XAMPP version: 5.6.24
Operating System: windows 10

Re: Need Help exposing MySQL on the Internet

Postby Ezekiel-Mghweno » 27. October 2016 09:18

A Socket connection is a connection to a copy of MySQL running on your local machine. If you are connecting to MySQL that you have installed from a package installer or source, then you won't normally need to enter anything into the socket field.
Required Fields
Username The default username for a mysql install is root
Password The default password for a mysql install is an empty string.
If that's the case, you should change the root password right away.
Optional Fields
Name The name you want to give the favourite.
Database If you enter a database, it will be selected when the connection to
the server is established.
Otherwise you can select one of the databases on the server afterwards.
Socket For non-standard mysql installs (e.g - MAMP) manually set the path. Read more about connecting via sockets to MAMP, XAMPP and other MySQL server setups.
Ezekiel-Mghweno
 
Posts: 9
Joined: 10. October 2016 12:23
XAMPP version: 5.6.24
Operating System: windows 10

Re: Need Help exposing MySQL on the Internet

Postby Amine E » 27. October 2016 09:56

Thanks a lot Ezekiel-Mghwen

I'm gonna try it and let you know. definitely going the SSH route.
Amine E
 
Posts: 2
Joined: 25. October 2016 10:22
XAMPP version: 5.6.12-0
Operating System: macOS sierra


Return to XAMPP for macOS

Who is online

Users browsing this forum: No registered users and 16 guests