From owner-freebsd-questions@FreeBSD.ORG  Tue Jul 10 12:17:35 2007
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@FreeBSD.ORG
Delivered-To: freebsd-questions@FreeBSD.ORG
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id 14A7016A421
	for <freebsd-questions@FreeBSD.ORG>;
	Tue, 10 Jul 2007 12:17:35 +0000 (UTC)
	(envelope-from d.hill@yournetplus.com)
Received: from duane.dbq.yournetplus.com (duane.dbq.yournetplus.com
	[65.124.230.214])
	by mx1.freebsd.org (Postfix) with ESMTP id E5C0813C4D3
	for <freebsd-questions@FreeBSD.ORG>;
	Tue, 10 Jul 2007 12:17:34 +0000 (UTC)
	(envelope-from d.hill@yournetplus.com)
Received: from [192.168.1.10] (unknown [192.168.1.1])
	by duane.dbq.yournetplus.com (Postfix) with ESMTP id 9D3DA6D455
	for <freebsd-questions@FreeBSD.ORG>;
	Tue, 10 Jul 2007 12:15:35 +0000 (UTC)
Date: Tue, 10 Jul 2007 12:15:35 +0000 (UTC)
From: Duane Hill <d.hill@yournetplus.com>
X-X-Sender: d.hill@duane.dbq.yournetplus.com
To: freebsd-questions@FreeBSD.ORG
In-Reply-To: <20070710115624.K27424@duane.dbq.yournetplus.com>
Message-ID: <20070710121422.S27505@duane.dbq.yournetplus.com>
References: <NBECLJEKGLBKHHFFANMBOELGCEAA.fbsd@a1poweruser.com>
	<20070710115624.K27424@duane.dbq.yournetplus.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
Cc: 
Subject: Re: accessing mysql server remotely
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 10 Jul 2007 12:17:35 -0000

On Tue, 10 Jul 2007 at 12:01 -0000, d.hill@yournetplus.com confabulated:

> On Mon, 9 Jul 2007 at 23:33 -0400, fbsd@a1poweruser.com confabulated:
>
>> Just a general question about mysql remote access.
>> 
>> Is it possible to login to my remote mysql server and create a
>> new db & table using a file on the local system which contains
>> the definition statements?
>
> Sure. As long as the account name used to login to MySQL has login access 
> from the remote location.
>
> mysql -host=ip_or_hostname -user=username -password=password dbname < 
> statements.sql

My bad. The command line parameters should have two hyphens:

mysql --host=ip_or_hostname --user=username --password=password dbname < statements.sql

-----
  _|_
(_| |