eeds of the
> OP
> > as they do for me..
> ..
>
> Unless you have to switch to Mac, which has a strange hybrid way of
> installing MySQL...
>
> It's clear that ssh is the better solution, even if a bit more work to
> setup, sometimes.
>
>
>
> -Thufir
&
he mysqld on my machine B (actually he runs shell scripts
> which do it).
>
> I guess all this very simple arrangements should cover the needs of the OP
> as they do for me..
..
Unless you have to switch to Mac, which has a strange hybrid way of
installing MySQL...
It's clear
- Original Message -
> From: "Thufir"
> Subject: Re: ssh basics
> On Mon, 09 Mar 2015 16:00:08 +0100, Johan De Meersman wrote:
>
>> All in all, you've done the opposite of what I asked - you've told me
>> what you know and tried, but not wha
plan? You know what I am? I'm a dog
chasing cars. I wouldn't know what to do with one if I caught it. You
know, I just... do things.
> Under the assumption that you wanted to use ssh to "magically" have a
> mysql prompt appear on your console:
> * [ssh -t user@ho
- Original Message -
> From: "Lucio Chiappetti"
>
> I may like a way to have a program (namely RSI IDL) to connect (bypassing
> the line mode mysql client) to the mysqld socket and issuing commands to
> it (essentially I want to issue a select into a table, and read back the
> output in a
Am 10.03.2015 um 19:06 schrieb Lucio Chiappetti:
I guess all this very simple arrangements should cover the needs of the
OP as they do for me.
but that won't help as long the OP fires up blindly ssh-tunnel commands
without understanding what a SSH tunnel and a TCP connection is and
On Mon, 9 Mar 2015, Johan De Meersman wrote:
I'm interested in how ssh is used by MySQL.
SSH is not used by MySQL at all :-) SSH is a way of connecting to a
remote machine. MySQL is a database. You can use SSH to do things with
the database, but they're not intrinsically relat
- Original Message -
> From: "Thufir"
> Subject: Re: ssh basics
>
> I was being serious, I always appreciate a reply. I know it was worded
> oddly, but, yes, just take it at face value, please.
Oh, I didn't see anything wrong with wording, but text doesn
ead multiple suggestions to connect with that approach, the -L switch,
none of the blogs/etc I saw explained why. I suppose they assume that
you know why already so don't say. It's possible I overlooked the
context, but I don't think so.
In and of itself, I'm fine with s
- Original Message -
> From: "Thufir"
> Subject: Re: ssh basics
>
> Thank you for explaining that.
I can't quite tell wether you're being sarcastic or not, so I'm going to give
you the benefit of the doubt :-)
Can you explain what you're
- Original Message -
> From: "Emil Oppeln-Bronikowski"
> Subject: Re: ssh basics
> Please, people, do we need that kind of thread?
Most action this list has seen since we had a thread about how little action
this list sees... :-p
--
The idea that Bill Gates appear
Please, people, do we need that kind of thread?
--
vag·a·bond adjective \ˈva-gə-ˌbänd\
a : of, relating to, or characteristic of a wanderer
b : leading an unsettled, irresponsible, or disreputable life
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubs
On Sun, Mar 08, 2015 at 08:03:05PM +, Thufir wrote:
> On Sun, 08 Mar 2015 08:43:41 -0400, Ruben Safir wrote:
>
>
> > gmail sucks
>
>
> You prefer yahoo mail? Just curious.
>
Your not curious.
>
> -Thufir
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.
On Sun, 08 Mar 2015 08:43:41 -0400, Ruben Safir wrote:
> gmail sucks
You prefer yahoo mail? Just curious.
-Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On Sun, 08 Mar 2015 13:41:32 +0100, Reindl Harald wrote:
>> What's the advantage?
>
> that you can have a local application using mysql by -h 127.0.0.1 which
> is a complete different thing than a interactive shell?
Thank you for explaining that.
-Thufir
--
MySQL General Mailing List
For l
On Sun, Mar 08, 2015 at 12:20:10PM +, Thufir wrote:
> On Sun, 08 Mar 2015 10:47:17 +0100, Reindl Harald wrote:
>
>
> > oh my god... https://www.google.at/search?q=ssh+tunnel
>
Yah know ssh and mysql wasn't invented 20 minutes ago. They are basic
tools f
Am 08.03.2015 um 13:20 schrieb Thufir:
On Sun, 08 Mar 2015 10:47:17 +0100, Reindl Harald wrote:
oh my god... https://www.google.at/search?q=ssh+tunnel
hmm, are you thinking that I'm not using ssh? Because I'm using ssh
currently, and it works fine.
no, i am th
On Sun, 08 Mar 2015 10:47:17 +0100, Reindl Harald wrote:
> oh my god... https://www.google.at/search?q=ssh+tunnel
hmm, are you thinking that I'm not using ssh? Because I'm using ssh
currently, and it works fine.
How is ssh -L 3305:localhost:3306 thufir@192.168.1.
Am 08.03.2015 um 02:38 schrieb Thufir:
how is this:
ssh -L 3305:localhost:3306 thufir@192.168.1.3
different from
ssh thufir@192.168.1.3
they seem functionally equivalent, neither gives me a MySQL console right
off the bat. (I'm reading the man page and trying to understand "bin
On Sun, 08 Mar 2015 01:30:46 +0100, Reindl Harald wrote:
> Am 08.03.2015 um 01:20 schrieb Thufir:
>> I want to ssh into Mysql, something like:
>>
>> thufir@doge:~$
>> thufir@doge:~$ ssh -L 3306:localhost:3306 thufir@192.168.1.3 bind:
>> Address already in use
&g
On Sun, 08 Mar 2015 00:20:26 +, Thufir wrote:
> I mean, I can ssh into tleilax and then fire up the MySQL console. Is
> there a better approach?
>
This just hangs:
thufir@doge:~$
thufir@doge:~$ mysql -u cron -h 192.168.1.3 -p
Enter password:
^C
thufir@doge:~$
because, I
Am 08.03.2015 um 01:20 schrieb Thufir:
I want to ssh into Mysql, something like:
thufir@doge:~$
thufir@doge:~$ ssh -L 3306:localhost:3306 thufir@192.168.1.3
bind: Address already in use
that is a pretty clear message
you can't use port 3306 if you have running a mysqld on both mac
I want to ssh into Mysql, something like:
thufir@doge:~$
thufir@doge:~$ ssh -L 3306:localhost:3306 thufir@192.168.1.3
bind: Address already in use
Last login: Sat Mar 7 19:18:20 2015 from 192.168.1.2
Thank you for installing ViciBox Server v.6.0!
This software is available for free download at
Hi Miguel,
I'm confused. Where should I issue those commands?
Yes from the MySQL Administrator.
From what you say it seems that you end up being authenticated as the
''@'localhost' user.
Connect again with the MySQL Administrator and the non-root account and
issue:
mysql> SHOW GRANTS;
mysql administrator I get the username correctly.
Regards and thanks for the promptly answer
Miguel
De: Claudio Nanni
Para: Miguel Gonzalez
CC: Tim Pownall ; mysql.
Enviado: Miércoles 29 de Mayo de 2013 9:24
Asunto: Re: SSH tunnels and non root accounts get
tion from the
> user account that is not working. Under root account I have found a file
> called .my.cnf with a [client] entry as I said.
>
> Regards,
>
> Miguel
>
>
>
>
>
> De: Tim Pownall
> Para: Miguel González
> CC:
entry as I said.
Regards,
Miguel
De: Tim Pownall
Para: Miguel González
CC: mysql.
Enviado: Miércoles 29 de Mayo de 2013 3:29
Asunto: Re: SSH tunnels and non root accounts get "the server service or the
configuration file could not be found"
:05 PM, Miguel González wrote:
> Dear all,
>
> Not sure if this the right mailing list address for asking this.
>
> Server running Centos and MySQL.
>
>Client is a windows xp machine.
>
>I have setup a SSH tunnel with putty and run mysql administrator. It
PM, Miguel González
wrote:
> Dear all,
>
> Not sure if this the right mailing list address for asking this.
>
> Server running Centos and MySQL.
>
>Client is a windows xp machine.
>
>I have setup a SSH tunnel with putty and run mysql administrator. It
> wo
Dear all,
Not sure if this the right mailing list address for asking this.
Server running Centos and MySQL.
Client is a windows xp machine.
I have setup a SSH tunnel with putty and run mysql administrator. It
works fine with the root account.
With a non-root account I get
hi
As the DB server is behind bastion host, each time I have to connect to this
host and then connect the DB server
In order to connect the server from my pc windows, I use PuTTY to create a
tunnel SSH,
mapping 'remotserver:port' to 'localhost:6001' thought the ba
Hi all,
Here I am, following up to my own post - available below and at
http://lists.mysql.com/mysql/208343 - with a solution (basically, a
"workaround").
To summarize: I couldn't enter Portuguese accented characters in
"MySQL monitor" (MySQL command line / console c
Hi all,
First of all, sorry for the lengthy subject, but it serves to describe
my problem:
I'm having problems entering Portuguese accented characters (with a
Portuguese keyboard) in "MySQL monitor" (MySQL command line / console
client), when I'm in a SSH (Secure Shell)
Hi Alan and others,
On 8/7/06, Alan Vinh <[EMAIL PROTECTED]> wrote:
I would like to
know how
they got MySql to work with SSL...
:)
Sorry fellows. I should have gone through the docs first. As it
happens, My
Duncan Hill wrote:
mysqldump is a shell command, not a mysql command.
Hi All,
oops, what a blunder. lol. Cheers.
Mark Sargent.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hey,
run mysqldump from your command prompt and not you mysql prompt.
[EMAIL PROTECTED]:~> mysqldump --no-data osc -u admin
-- MySQL dump 10.9
--
-- Host: localhostDatabase: osc
Thanx
Alex
On Fri, 7 Apr 2006, Mark Sargent wrote:
> alexj wrote:
> > try mysqldump --no-data -u
> Hi
mysql> mysqldump --no-data osc -u admin;
ERROR 1064: You have an error in your SQL syntax near 'mysqldump
--no-data osc -u admin' at line 1
You are supposed to execute that from a shell, not from within mysql Client.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
On Friday 07 April 2006 10:30, Mark Sargent wrote:
> alexj wrote:
> > try mysqldump --no-data -u
>
> Hi All,
>
> thanx, but get the following,
>
> mysql> mysqldump --no-data osc -u admin;
> ERROR 1064: You have an error in your SQL syntax near 'mysqldump
> --no-data osc -u admin' at line 1
mysql
alexj wrote:
try mysqldump --no-data -u
Hi All,
thanx, but get the following,
mysql> mysqldump --no-data osc -u admin;
ERROR 1064: You have an error in your SQL syntax near 'mysqldump
--no-data osc -u admin' at line 1
Cheers.
Mark Sargent
--
MySQL General Mailing List
For list archive
try mysqldump --no-data -u
Thanx
Alex
On Fri, 7 Apr 2006, Mark Sargent wrote:
> Hi All,
>
> we have cli access to our MySQL database via ssh in the Admin GUI
> and were wondering how to print the complete structure of a DB. I
> searched the documents on MySQL homepage bu
Hi All,
we have cli access to our MySQL database via ssh in the Admin GUI and
were wondering how to print the complete structure of a DB. I searched
the documents on MySQL homepage but couldn't find anything specific.
Anyone know how to do this? Cheers.
Mark Sargent.
--
MySQL Ge
u how to create a tunnel, I believe the switch you are looking for
is -L. It's not difficult.
=C=
|
| Cal Evans
| http://www.calevans.com
|
Karam Chand wrote:
If you are looking for a client to connect to MySQL
using SSH tunnel, try out SQLyog. It has SSH
Tunneling.
Karam
--- Jerry Swans
If you are looking for a client to connect to MySQL
using SSH tunnel, try out SQLyog. It has SSH
Tunneling.
Karam
--- Jerry Swanson <[EMAIL PROTECTED]> wrote:
> How to create ssh tunnel for Mysql?
> TH
>
__
Do You Yahoo!?
Tired
Jerry Swanson wrote:
Both Linux computers.
This is what I do...
$ more ssh_to_mysql_on_beta
#!/bin/sh
ssh \
-t \
-g \
-L 3306:beta.domain.ac.uk:3306 \
[EMAIL PROTECTED] \
"./bin/sleep.plx mysql"
That last line is a trick to prevent the terminal from 'timeing out
-and-ssh.html
>
>
>
> Jerry Swanson wrote:
>
>
>
> >How to create ssh tunnel for Mysql?
>
> >TH
>
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.NET http://www.ensita.net/
>
Hello.
You have not specified what operating system you're using. MySQL manual
has some notes for Windows:
http://dev.mysql.com/doc/refman/5.0/en/windows-and-ssh.html
Jerry Swanson wrote:
>How to create ssh tunnel for Mysql?
>TH
--
For technical support contracts,
Well, off the top of my head, to achieve a local-forwarding, you'd do
something like:
ssh [EMAIL PROTECTED] -L :localhost:3306 -N &
Remember, "localhost" is resolved after the tunnel is established, so
refers, actually, to the remote machine :) (The -N option simply
o
I use PuTTY (and WinSCP3) to attach my Windows machine to the Linux server
holding my MySQL database. PuTTY is used to get the command line and WinSCP3
is the GUI I can use to do file transfers between the two machines.
In PuTTY, there is a place where you can create SSH tunnels; it is located
Are you connecting from a Windows based machine? Are
you using a graphical interface?
I just helped a coworker do this with Navicat. You
just set it up to log into the computer hosting mysql
via ssh, this creates the tunnel. Then, you configure
navicat to use localhost port 3306 to connect
How to create ssh tunnel for Mysql?
TH
Gleb Paharenko wrote:
Hello.
Can you connect using the mysql command line client program?
"leegold" <[EMAIL PROTECTED]> wrote:
ssh connecting with a mysql client gui I get: ERROR 2013 Lost
connection to MySQL server during query
I'm using mysqlyog and tryin
Hello.
Can you connect using the mysql command line client program?
"leegold" <[EMAIL PROTECTED]> wrote:
> ssh connecting with a mysql client gui I get: ERROR 2013 Lost
> connection to MySQL server during query
>
> I'm using mysqlyog and trying
ssh connecting with a mysql client gui I get: ERROR 2013 Lost
connection to MySQL server during query
I'm using mysqlyog and trying connect via the ssh tunnel. I can connect
with out the ssh w/mysqljog OK. It's a very nice client and would like
to get this working. I have googled it b
> > I am trying to connect to my mysql server through an SSH tunnel.
> > On the server, I have a local instance of mysql running, but one of the
> > hosted domains needs to access another remote mysql server. For security,
> > I want to connect to the remote server via
On Wednesday 02 February 2005 15:39, Richard Curtis wrote:
> I am trying to connect to my mysql server through an SSH tunnel.
> On the server, I have a local instance of mysql running, but one of the
> hosted domains needs to access another remote mysql server. For security,
> I wan
> I am trying to connect to my mysql server through an SSH tunnel.
> On the server, I have a local instance of mysql running, but
> one of the hosted
> domains needs to access another remote mysql server. For
> security, I want to
> connect to the remote server via an
Richard Curtis wrote:
I am trying to connect to my mysql server through an SSH tunnel.
On the server, I have a local instance of mysql running, but one of the hosted
domains needs to access another remote mysql server. For security, I want to
connect to the remote server via an ssh tunnel.
I am
I am trying to connect to my mysql server through an SSH tunnel.
On the server, I have a local instance of mysql running, but one of the hosted
domains needs to access another remote mysql server. For security, I want to
connect to the remote server via an ssh tunnel.
I am creating the tunnel
I'm remotely administering a fedora 2 snort box via ssh.
running snort with
snort -c /etc.snort/snort.conf is fine - that is everything is logged
to tables and shows in acid.
But if i leave it running for over about a minute it buggers up. I
lose my ssh and acid/apache service. I then have t
> -Original Message-
> From: Karam Chand [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 10, 2004 2:17 PM
> To: Adams, Pat 006; [EMAIL PROTECTED]
> Subject: RE: Lost connection during query when using SSH tunneling
>
> I am not sure of Putty as I am using plink.e
I am not sure of Putty as I am using plink.exe that is
the SSH tunneler for tunnel.
The thing is that I call up plink.exe from my app to
create an ssh tunnel and then set the correct values
for mysql_real_connect() in my app.
What I am doing is that I am bundling plink.exe with
my app and then
> -Original Message-
> From: Karam Chand [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 10, 2004 12:08 PM
> To: [EMAIL PROTECTED]
> Subject: Lost connection during query when using SSH tunneling
>
> So I use Putty to create the SSH tunneler and then connecting
- Original Message -
From: "Karam Chand" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 10, 2004 1:08 PM
Subject: Lost connection during query when using SSH tunneling
> Hello,
>
> I have a MySQL database hosted with my ISP. They
>
Hello,
I have a MySQL database hosted with my ISP. They
provide direction as well as thru SSH tunneling. I can
very well connect to it diredctly from any app but I
prefer to use SSH tunneling.
So I use Putty to create the SSH tunneler and then
connecting to the local port.
Now the problem, is
n you telnet to localhost:3306?
Seth
On Sun, 10 Oct 2004 17:33:18 -0500, Carl Karsten <[EMAIL PROTECTED]> wrote:
> I am trying to connect to MySql with an SSH tunnel that terminates on the same
> box MySqld is running on. I would expect that I do L3306:localhost:3306 and
> gr
I am trying to connect to MySql with an SSH tunnel that terminates on the same
box MySqld is running on. I would expect that I do L3306:localhost:3306 and
grant access to [EMAIL PROTECTED] This doesn't seem to work. I got this to work on
a test box: L3306:my.sql.IP:3306 grant access to [
7.0.0.1 localhost.localdomain localhost
(two entries)
> Yes, add 'localhost.localdomain' to mysql.user
Got it.
> another option, Why not just SSH to 'daisy' and issue:
>
> shell> mysql -u root -p
>
> and let it default to localhost.
Well, I did get that
connecting via TCP/IP.
Since I don't have physical access to the box (well, I'm just too lazy to walk
down to the basement), I SSH into the box from a second machine (the name of
the box that 'www.example.com' is running on is called 'daisy'):
shell> ssh www.exam
What does your '/etc/hosts' file contain? Sounds like
it may have the following entry:
127.0.0.1 localhost.localdomain
change it to:
127.0.01localhost
or
Yes, add 'localhost.localdomain' to mysql.user
another option, Why not just SSH to 'daisy' and i
Hi folks,
Now that I can connect to my MySQL server using the Unix sockets (e.g.
[EMAIL PROTECTED] ~] mysql -u root
I'm moving on to the next step - connecting via TCP/IP.
Since I don't have physical access to the box (well, I'm just too lazy to walk
down to the basement), I S
That is a pretty fair take on network traffic. SSH has strong enough encryption
to make the decryption effort not worth it to all but those with
supercomputers. As for the internal mail, I think we can agree that some mail
would be critical enough to warrant encryption even on an internal
Think of your information like a letter in the mail. Well, for this example,
think of it even more as a post-card. Your message is written on the outside
where the anyone that touches it can read it.
This post-card is going through the post office. It is going through mail
centers, hubs, etc. Wha
known?
Andrew
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Sent: 27 October 2003 15:39
>To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
>Subject: Ann: New Article on SSH Port Forwarding of MyODBC
>
>
>Hi Everyone;
>
>I have published a
Hi Everyone;
I have published a new article covering SSH port forwarding of MySQL sessions,
which can be viewed at http://www.vbmysql.com/articles/sshtunnel.html
The article covers connecting a Windows client to a *NIX based server.
Anyone with previous experience will probably find the
I think I need a MySQL code guru...
I am using the 4.0.12 client library on a Win2k host to
connect to a 4.0.13 linux server.
If I connect directly to the server using mysql_real_connect, everything
runs fine.
However, I want to use SSH tunneling.
So I set up a SSHv2 tunneling connection from
I think I need a MySQL code guru...
I am using the 4.0.12 client library on a Win2k host to
connect to a 4.0.13 linux server.
If I connect directly to the server using mysql_real_connect, everything
runs fine.
However, I want to use SSH tunneling.
So I set up a SSHv2 tunneling connection from
omended way
> to do it,
> port forwarding over SSH, or using SSL. I'm leaning towards using SSH,
> since I have already gotten that to work and it provides a secure
> channel for the data transfer (which is all I need, really).
It doesn't make any difference from MySQL'
I'm planning to set up an MySQL database on a server, and connect to it
over the internet (no connection to a website or anything, just a
private db server). Just wondering what is the recomended way to do it,
port forwarding over SSH, or using SSL. I'm leaning towards using SSH,
si
t are you using?
Try running your tunnel with ssh -ddd for extra debugging output on tunnel creation
--
Michael T. Babcock
CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc)
http://www.fibrespeed.net/~mbabcock/
--
MySQL General Mailing List
For list archives: http://lis
rary, which is what
bit us. You specify a port in the DBI->connect() routine as something
like ';host=localhost;port=2000' and it's silently ignored there too.
Well, sure. Options just map onto arguments to the mysql_real_connect()
C library call, and the ambiguity of inte
on 3/10/03 1:55 PM, Pete Harlan at [EMAIL PROTECTED] wrote:
> So your db is on foo.bar.com, and that's the machine you're sshing
> into? If so, then you might try
>
> ssh -n -N -L 3307:127.0.0.1:3306 foo.bar.com
>
> Since, once on the new host, it's the loc
On Mon, 2003-03-10 at 22:01, Pete Harlan wrote:
> On Mon, Mar 10, 2003 at 11:32:06AM -0600, Paul DuBois wrote:
> > Whether it's a feature or not, it's not always so easy to figure out
> > what to do. If you specify -h localhost, it can be argued that you
> > really want the socket even if you spec
on 3/10/03 9:24 AM, Pete Harlan at [EMAIL PROTECTED] wrote:
> If you want to connect to localhost via TCP/IP, you have to specify
> the host by IP address (127.0.0.1), not as "localhost".
Tried that, it doesn't work. In my case, I call ssh like this:
ssh -n -N -L
ich is what
bit us. You specify a port in the DBI->connect() routine as something
like ';host=localhost;port=2000' and it's silently ignored there too.
I'm very glad that ssh no longer (as of three years ago!) forwards
externally-connected-to ports by default.
--Pete
--
27;s potentially dangerous and not completely obvious
> side-effect of tunneling SSH ports.
"man ssh" says :
-g Allows remote hosts to connect to local forwarded ports.
as long as you don't use the -g switch you should be perfectly save. not to
mention even more save when you prote
At 11:24 -0600 3/10/03, Pete Harlan wrote:
On Fri, Mar 07, 2003 at 05:43:29PM -0800, Jeremy Zawodny wrote:
On Fri, Mar 07, 2003 at 05:37:38PM -0800, LZ Orders wrote:
> Hi. I wanted to connect from a client machine to a MySQL server using
> ssh. I execute the following on the local machin
On Fri, Mar 07, 2003 at 05:43:29PM -0800, Jeremy Zawodny wrote:
> On Fri, Mar 07, 2003 at 05:37:38PM -0800, LZ Orders wrote:
> > Hi. I wanted to connect from a client machine to a MySQL server using
> > ssh. I execute the following on the local machine (the server is
What does it really matter is whether you have create mySQL user that allow
access the database from the SSH server.
Please note that localhost, 127.0.0.1 or the machine ip address will be
treated as different entries by mySQL.
--
Yours,
KH Chiu
C&A Computer Consultants Ltd.
Tel: 3104 2070
On Fri, Mar 07, 2003 at 05:37:38PM -0800, LZ Orders wrote:
> Hi. I wanted to connect from a client machine to a MySQL server using
> ssh. I execute the following on the local machine (the server is
> foo.bar.com):
>
> % ssh -n -N -L 3307:foo.bar.com:3306 foo.bar.com
>
>
Hi. I wanted to connect from a client machine to a MySQL server using
ssh. I execute the following on the local machine (the server is
foo.bar.com):
% ssh -n -N -L 3307:foo.bar.com:3306 foo.bar.com
I then try to connect from the local machine with:
% mysql -h localhost -p 3307 --user=me
Insanely Great wrote:
Greetings
I am writing a C app wherein I have to connect to MySQL server whcih is on
SSH connection.
How can I connect to the server using mysql_real_connect ()
Just use SSH to create a local tunnel then connect to localhost ...
--
Michael T. Babcock
C.T.O
Greetings
I am writing a C app wherein I have to connect to MySQL server whcih is on
SSH connection.
How can I connect to the server using mysql_real_connect ()
Any ideas ? Its urgent
Rgds
insane
-
Before posting, please
Melvyn Sopacua wrote:
->>>>
>Does MySQL have any facility for using SSH to tunnel ports for use in
>replication? Has anyone implemented anything like this?
>We can't just assume if we create an SSH tunnel manually that the
>connection will stay up.
Th
Hi Mark,
At 11:14 5/31/2002 -0400, [EMAIL PROTECTED] wrote:
>Does MySQL have any facility for using SSH to tunnel ports for use in
>replication? Has anyone implemented anything like this?
>We can't just assume if we create an SSH tunnel manually that the
>connection will stay
Does MySQL have any facility for using SSH to tunnel ports for use in
replication? Has anyone implemented anything like this?
We can't just assume if we create an SSH tunnel manually that the
connection will stay up.
Thanks,
Mark R. Andrachek, Jr.
Analyst I
Federal Reserve Bank of Ric
bear with me-
my host disabled network so I can only connect thru SSH telnet via
localhost. i'd like to use mySQL-FRONT to utilize mySQL.
I am using PuTTY to establish SSH, and what I did was create local port
forwarding. L3306 forwards to localhost:3306 I then run mySQL-FRONT, using
loca
At 18:20 -0800 2/26/02, David M. Goodstein wrote:
>I've set up an ssh tunnel between my local machine and a remote host
>("Fred") as follows:
>ssh daveg@fred -L 3306:localhost:3306
>in an effort to access a remote mysql database running on fred. I've
>ver
I've set up an ssh tunnel between my local machine and a remote host
("Fred") as follows:
ssh daveg@fred -L 3306:localhost:3306
in an effort to access a remote mysql database running on fred. I've
verified that the tunnel is working by telnetting into fred 3306 and
seei
On Sun, Jan 20, 2002 at 01:08:04PM +0100, Henning Sprang wrote:
> >
> > Try using "localhost" instead of "my".local.hostname". Since you
> > didn't use the `-g' option for SSH, I wouldn't expect what you're
> > doing to work.
Jeremy Zawodny wrote:
> On Sun, Jan 20, 2002 at 12:01:29AM +0100, Henning Sprang wrote:
>> [...]
>>so fra , so good. Then doing
>>
>># ssh [EMAIL PROTECTED] -L 8:localhost:3306
>>
>>
>>and connecting to port 8 on my machine with teln
1 - 100 of 133 matches
Mail list logo