At 11:36 AM +0200 1/26/01, Mark Coetser wrote:
>Hi guys
>
>Havent worked much with mysql or any databses for that matter, I have
>created a small database on my unix box and I want to make a query to the
>database from another unix box without telneting in or ssh, I beleive that
>it runs on port 3306.............??? help
You need the mysql client on your computer (check the downloads
section at www.mysql.com; they probably have a client-only download).
Then you can just use the -h parameter:
mysql -u username -h hostname -p databasename
Also, the permissions on the database need to be set up to allow
access from your computer; see the docs on setting up permissions and
the 'GRANT' command.
- steve
> > regards,
>> Mark Coetser
>> support engineer the internet solution
>> telephone (011) 283 5500 / 0860 50 5000 fax (011) 283 5401
> > http://www.is.co.za
--
+--- "They've got a cherry pie there, that'll kill ya" ------------------+
| Steve Edberg University of California, Davis |
| [EMAIL PROTECTED] Computer Consultant |
| http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ |
+-------------------------------------- FBI Special Agent Dale Cooper ---+
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php