> > > REPLACE INTO user ( host, user, password )
> > > VALUES ('localhost','user',password('plaintextpassword'));
> >
> > Is there a functional difference between this and GRANT [privs]?
>
> REPLACE (same as insert except it will delete an older matching entry
> before insertion) is modifying the grant tables directly.
AFAIK, direct modifications to the user table need a mysqladmin reload.
GRANT privs no.
Ciao,
Filippo
--
Please report bugs to [EMAIL PROTECTED]
Please mail [EMAIL PROTECTED] (only) to discuss security issues
Support for registered customers and partners to [EMAIL PROTECTED]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Archives by mail and http://www.mail-archive.com/devinfo%40lists.e-smith.org
