Virtual Private Networks VPN MYSQL

Bookmark this page:  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
VPN MYSQL Michael Beecken 03-28-06
  `--> Re: VPN MYSQL Michael Beecken03-28-06
Posted by Michael Beecken on March 28, 2006, 3:04 am
Please log in for more thread options
Hi everyone,

I have installed OpenVPN to access a server through the internet. This
works fine. I see the shares. I can run programs etc.

I´m running mysql on the same server. I can access the database localy
and over the internet.

BUT:
If I try to access the database through VPN I can´t connect.

Does anyone know why?

Thanks for any help.

Michael

Posted by Adam KOSA on March 28, 2006, 5:11 am
Please log in for more thread options
On Tue, 28 Mar 2006, Michael Beecken wrote:

: If I try to access the database through VPN I can=B4t connect.
:
: Does anyone know why?
:

perhaps you should attach the mysql error message. try looking in the
mysql tablespace, and check that you user is also allowed from the vpn ip
address.

Not knowning the mysql error, i don't consider this to be a vpn problem.

Best Regards
Adam

Posted by Michael Beecken on March 28, 2006, 5:41 am
Please log in for more thread options
Adam KOSA wrote:
> On Tue, 28 Mar 2006, Michael Beecken wrote:
>
> : If I try to access the database through VPN I can´t connect.
> :
> : Does anyone know why?
> :
>
> perhaps you should attach the mysql error message. try looking in the
> mysql tablespace, and check that you user is also allowed from the vpn ip
> address.
>
> Not knowning the mysql error, i don't consider this to be a vpn problem.
>
> Best Regards
> Adam

Hi Adam,
thanks for your help.
my VPN adress is 192.168.13.1
the error is:
ERROR 2003 (HY000); Can´t connect to MySQL server on '192.168.13.1' (10060)

The user I use has permission to access from everywhere (%) and is only
once in the userlist.

When I´m working on the server I can access the DB through 192.168.13.1

as I told VPN works but from my home computer

"C:\Programme\MySQL\MySQL Server 4.1\bin\mysql.exe" -h 192.168.13.1 -u
michaelbeecken -p

does not work. As well I tried other users, that are in the userlist.

Strange isn´t it?

Thanks again


Similar ThreadsPosted
VPN MYSQL March 28, 2006, 3:04 am