accessing mysql server remotely

[Yuri Pankov]

On Mon, Jul 09, 2007 at 11:40:07PM -0400, fbsd2 wrote:
> 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?
> 
> Thanks
> 

Of course, it's possible. It's the same as you would use it locally,
with added hostname parameter:

mysql -h <hostname> -u <username> -p <dbname> < yourfile.sql

(that's basic syntax, check mysql(1) manpage).

HTH,
Yuri
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20070710/af25e690/attachment.pgp