Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
mysql over vpn 1
- Thread starter ipi2405
- Start date
-
1
- #2
DonQuichote
Programmer
- Nov 9, 2001
- 980
Yes it is. It may not work out of the box though. That all depends on how you set up the database and users.
First, networking should be switched on (it usually is) and listening to more than one address (on Ubuntu, for example, it is very easy to tie the MySQL server to 127.0.0.1 only). Note that for MySQL, 127.0.0.1 is not the same as localhost. "Localhost" does not use a network connection at all.
Second, your users should be able to authenticate from the VPN tunnel. The "MySQL end" of the tunnel has an IP range. Make sure the GRANTS for the MySQL users you want to connect with cover that network location also. For example:
Will not grant any access from a network by itself.
If added to the previous statement, it will allow network access for the local machine also (very handy for SSH tunnels)
Allows network access from any IP in the range 192.168.0.0 to 192.168.0.255.
If you are not sure what the IP range is, ask your network administrator.
Oh, the VPN tunnel is just a network connection. MySQL itself cannot see the tunnel, so there is no difference in multi-user behaviour on the MySQL server part.
Good luck!
+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)
First, networking should be switched on (it usually is) and listening to more than one address (on Ubuntu, for example, it is very easy to tie the MySQL server to 127.0.0.1 only). Note that for MySQL, 127.0.0.1 is not the same as localhost. "Localhost" does not use a network connection at all.
Second, your users should be able to authenticate from the VPN tunnel. The "MySQL end" of the tunnel has an IP range. Make sure the GRANTS for the MySQL users you want to connect with cover that network location also. For example:
Code:
GRANT SELECT ON SomeDatabase.* TO SomeUser@localhost
Code:
GRANT SELECT ON SomeDatabase.* TO SomeUser@'127.0.0.1'
Code:
GRANT SELECT ON SomeDatabase.* TO SomeUser@'192.168.0.%'If you are not sure what the IP range is, ask your network administrator.
Oh, the VPN tunnel is just a network connection. MySQL itself cannot see the tunnel, so there is no difference in multi-user behaviour on the MySQL server part.
Good luck!
+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)
- Status