On Sun, Feb 24, 2002 at 04:59:57PM -0500, Dan Brown wrote: > > > From: Damien Curtain [mailto:[EMAIL PROTECTED]] > > > CONNECT mysql; > > > > REPLACE INTO user ( host, user, password ) > > VALUES ('localhost','user',password('plaintextpassword')); > > > > REPLACE INTO db ( host, db, user, select_priv, insert_priv, > > update_priv, delete_priv, create_priv, drop_priv ) > > VALUES ( 'localhost', 'database', 'user', '?', '?', '?', '?', > > '?', '?'); > > 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. -- Damien -- 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
