accessing mysql server remotely
d.hill at yournetplus.com
Tue Jul 10 12:17:35 UTC 2007
On Tue, 10 Jul 2007 at 12:01 -0000, d.hill at yournetplus.com confabulated:
> 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 <
My bad. The command line parameters should have two hyphens:
mysql --host=ip_or_hostname --user=username --password=password dbname < statements.sql
More information about the freebsd-questions