accessing mysql server remotely

Duane Hill d.hill at yournetplus.com
Tue Jul 10 12:03:28 UTC 2007


On Mon, 9 Jul 2007 at 23:33 -0400, fbsd at 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

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


More information about the freebsd-questions mailing list