Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 10 Jul 2007 12:01:28 +0000 (UTC)
From:      Duane Hill <d.hill@yournetplus.com>
To:        freebsd-questions@FreeBSD.ORG
Subject:   Re: accessing mysql server remotely
Message-ID:  <20070710115624.K27424@duane.dbq.yournetplus.com>
In-Reply-To: <NBECLJEKGLBKHHFFANMBOELGCEAA.fbsd@a1poweruser.com>
References:  <NBECLJEKGLBKHHFFANMBOELGCEAA.fbsd@a1poweruser.com>

next in thread | previous in thread | raw e-mail | index | archive | help
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

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



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