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.
> - password is what goes after the -p option (-p'password')
> - WITH GRANT OPTION means that this user can create other users with this
> GRANT command.
Bye,
Benjamin.
---------------------------------------------------------------------
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
