> you can do this: > > mysql> set password for newsletter@localhost=PASSWORD("testPass"); > > or > > mysql> update user Set Password=Password("testPass") > -> where user="newsletter"; Don't forget the "flush privileges" thing after the update command.
> __ > / \\ @ __ __ @ Adolfo Bello <[EMAIL PROTECTED]> > / // // /\ / \\ // \ // Bello Ingenieria S.A, Presidente > / \\ // / \\/ // // / // cel: +58 416 609-6213 > /___//// / <_/\__\\//__/ // fax: +58 212 952-6797 > www.bisapi.com // pager: www.tun-tun.com (# 609-6213) --------------------------------------------------------------------- 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