From owner-freebsd-questions@FreeBSD.ORG  Tue Jul 10 12:03:28 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 9382616A477
	for <freebsd-questions@FreeBSD.ORG>;
	Tue, 10 Jul 2007 12:03:28 +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 6765B13C4BE
	for <freebsd-questions@FreeBSD.ORG>;
	Tue, 10 Jul 2007 12:03:28 +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 086036D455
	for <freebsd-questions@FreeBSD.ORG>;
	Tue, 10 Jul 2007 12:01:29 +0000 (UTC)
Date: Tue, 10 Jul 2007 12:01:28 +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: <NBECLJEKGLBKHHFFANMBOELGCEAA.fbsd@a1poweruser.com>
Message-ID: <20070710115624.K27424@duane.dbq.yournetplus.com>
References: <NBECLJEKGLBKHHFFANMBOELGCEAA.fbsd@a1poweruser.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:03:28 -0000

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

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