Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 19 Apr 2000 19:30:34 +1200
From:      "Dan Langille" <dan@langille.org>
To:        freebsd-security@freebsd.org
Subject:   Re: using mysql over ssh
Message-ID:  <200004190730.TAA21657@ducky.nz.freebsd.org>
In-Reply-To: <Pine.BSF.4.21.0004191550130.17472-100000@ducky.nz.freebsd.org>

next in thread | previous in thread | raw e-mail | index | archive | help
> I want to access a mysql database remotely.  I've had success with 
> the following approach:
> 
>  ssh user@mydomain.org /usr/local/mysql/bin/mysql -uuserid
>            -ppassword dbname < mysql.sql

There is nothing like finding the answer shortly after posting a question.

I found the solution at:

http://www.mysql.com/php/manual.php3?section=Password_security

You create ~/.my.cnf and add this:

[client]
password=your_pass

Then you don't need to specify the password on the command line as 
shown above.

I'd still like feedback about my points 1 and 2 in my original post.

cheers.
--
Dan Langille  [I'm looking for more work]
http://www.langille.org/     |  http://www.unixathome.org/
http://www.racingsystem.com/ |  http://www.freebsddiary.org/


To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-security" in the body of the message




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200004190730.TAA21657>