accessing mysql server remotely

Yuri Pankov yuri at
Tue Jul 10 11:57:30 UTC 2007

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).

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url :

More information about the freebsd-questions mailing list