There are several weird hybrid ways of installing MySQL on Mac (the native
install as provided by Apple, tar or dmg from Oracle, Darwin Ports, brew
and Fink, if the latter is still around) all of which are utterly mutually
incompatible. But once it is up, it's behaviour is the same as a typical
un
Lucio Chiappetti lambrate.inaf.it> writes:
..
> Conversely, I have some private databases on my machine B. While I
> maintain them locally with full access, I grant select access to an user
> on another machine C. In this case he runs the mysql client on C which
> connects to the mysqld on my m
- 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
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 what you were trying to figure out with
> your original question :-p
>
Do I really look like a guy with a plan? You know what I a
- 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
*that* i
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 related.
True, how
- 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
On Mon, 09 Mar 2015 13:44:51 +0100, Johan De Meersman wrote:
>> 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 trying to accomplish, without referencing
> sites you've
- 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 for GNU users for almost
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 thinking you have
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.3 any better o
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 "bind"
and the -L
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
>
> that is a pretty clear message
>
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 think, I d
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 machines,
so
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"
If you are tunneling port 3306 to your local machine, you need to have
mysql listen on the local port.
what ever port is being used on your local computer to operate the tunnel
to port 3306 remotely is the port you will use for mysql locally.
I hope this makes sense!
On Tue, May 28, 2013 at 7:0
Your windows-based client never sees the files on the linux server.
All the tunnel provides is the ability to treat port 3306 of your
linux box as-if it was a port local to your windows system. It does
not, can not make file access transparent across those systems.
On Tue, May 28, 2013 at 8:05 PM
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
Jerry,
SQLYog is great, I use it all the time. I've been on the BETA team for 3
years now and I buy at least one copy at every company I work for. Well
worth the money if you are a serious MySQL developer.
However, to answer your question, google for putty.exe. The docs explain
to you how to
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 of spam? Yahoo!
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'.
The sleep.plx applic
Both Linux computers.
On 11/21/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
>
> 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:
>
>
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, goto https://ord
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
obviates the need to pe
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 to
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 trying connect via the ssh
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 connect via the ssh tunnel. I can connec
On Monday 02 August 2004 22:34, James Weisensee wrote:
> 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
Actually, it has
127.0.0.1 localhost.localdomain localhost
From mysql's point of view, localhost and 127.0.0.1 are not the same thing.
When you connect with
mysql -h localhost -u root -p
or simply
mysql -u root -p
(localhost is the default), you are connecting via unix socket, so the
user=root, host=localhost entry is used. When you connect with
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 issue:
shell> mysql -u root -p
a
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., FibreSpee
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.
There was an excellent piece in
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 up.
There was an e
Hi~
I have trouble with ssh tunneling.
I run this command as you told.
[wertyu@inos ~]$ ssh -L 12345:localhost:3306 localhost
Secure connection to localhost refused; reverting to insecure method.
Using rsh. WARNING: Connection will not be encrypted.
localhost: Connection refused
what's the pr
localhost, with something like: mysql -h localhost
-P -u otherserverusername otherserverdatabasename.
Ernie Hershey
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 11:56 AM
To: MySQL baby
Cc: [EMAIL PROTECTED]
Subject: Re: SSH
Try mapping your remote mysql to a different local port, then specify that
port number when you connect.
For example:
'ssh -L 3307:hostip:3306 hostname' will map port 3306 on the remote machine
to port 3307 on your local machine. Then, use
'mysql -P 3307 -u x -p etc.' to connect to port 3307
You use a different port # for the tunnel.
MySQL baby wrote:
> If I've got one computer with MySQL client and server on it, running everything
>localhost,
>
> but I want to reach out to another MySQL server, through an SSH tunnel, for some
>things,
>
> does anyone know how to differentiate
Using the -h should do it.
mysql -h 10.129.0.2 -u user -p password yadayadayada
-Original Message-
From: MySQL baby [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 10:28 AM
To: [EMAIL PROTECTED]
Subject: SSH tunnel MySQL traffic: BOTH remote & local?
If I've got one compute
Hi,
I have come accross my problem with the port forwarding... Thanks to the
help I got.
I needed the flag -n (that tells ssh not to listen on stdin).
So doing the following is working... assuming that you have privileges
without passphrase between the server and the client...
ssh -l username
On Wed, 4 Jul 2001, Caroline Leclerc wrote:
> Hi,
>
> Sorry to send this mail to the mailing list but I browsed all the
> archives concerning a secure connection without success.
> I did the following:
> ssh -l username mysqlserver -L 222:mysqlserver:3306 -N
a) Try using port 3306 locally if yo
On Fri, Apr 13, 2001 at 09:35:38AM +0800, Leon Harris wrote:
>
> I believe that the session was idle. It also does it when I give the
> -2 option to ssh ( ssh2 is supposed to not time out, according to
> some usenet posts I have read). The point of the excercise is to
> have an encrypted connect
Hi Jeremy, thanks for your reply.
I believe that the session was idle. It also does it when I give the -2
option to ssh ( ssh2 is supposed to not time out, according to some
usenet
posts I have read).
The point of the excercise is to have an encrypted connection that I can
make DBI calls to the
[EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> database,sql,query
>
> If you just reply to this message, and include
On Thu, Apr 12, 2001 at 02:32:42PM +0800, Leon Harris wrote:
>
> On the client I do a
> ssh -q -n -f -l account -L 3306:mysqlserver.mydomain.com:3306
>
> then mysql -u dbuser --port=3306 -h 127.0.0.1 -p dbname
> and I get an encrypted connection. ( thats what tcpdump shows me) !
> Lovely !
>
>
ssh = Secure Shell
http://www.ssh.org/faq.html
On Thu, 22 Feb 2001, Karl Chen wrote:
> I wonder what is ssh stand for. and what is benifit over telnet
-
Before posting, please check:
http://www.mysql.com/manual.php (the
On Thu, 22 Feb 2001, Karl Chen wrote:
> Date: Thu, 22 Feb 2001 12:30:25 -0800
> From: Karl Chen <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: ssh
>
> Hi everyone :
>
> I wonder what is ssh stand for . and what is benifit over telnet
Secure Shell,
the information is sent en
58 matches
Mail list logo
