Date: Tue, 10 Jul 2007 12:15:35 +0000 (UTC) From: Duane Hill <d.hill@yournetplus.com> To: freebsd-questions@FreeBSD.ORG Subject: Re: accessing mysql server remotely Message-ID: <20070710121422.S27505@duane.dbq.yournetplus.com> In-Reply-To: <20070710115624.K27424@duane.dbq.yournetplus.com> References: <NBECLJEKGLBKHHFFANMBOELGCEAA.fbsd@a1poweruser.com> <20070710115624.K27424@duane.dbq.yournetplus.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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 ----- _|_ (_| |
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20070710121422.S27505>