On Wed, 13 Jun 2001, Benjamin Pflugmann wrote:
> Hello.
>
> Only a minor correction:
>
> On Tue, Jun 12, 2001 at 09:35:19PM -0230, [EMAIL PROTECTED] wrote:
> [...]
> > GRANT ALL ON 'database'.'table' TO 'user'@'host' IDENTIFIED BY 'password'
> >
> > - the PRIVILEGES keyword is redundant.
> > - database can be * for all databases.
> > - table can be * for all tables
> > - user is the user to pass to mysql after the -u option when connecting
> > - host is the host to pss to mysql after the -h option if the database is
> > on a different computer than the one on which you run mysql
>
> host is the host the user should be able to connect from later. It is
> not specified as option when connecting.
host is the host the user should be able to connect _to_ later.
that is, host is the computer on which mysqld will be running.
the mysql client knows what host it is running on so you don't need to
tell it this. I have connected to remote mysqld hosts like this many
times.
Neil
---------------------------------------------------------------------
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
