On Wed, Sep 30, 2009 at 8:18 AM, Claudio Nanni <claudio.na...@gmail.com> wrote: > Remove manually (delete) the user from all the privilege tables: > > delete from columns_priv where user='carlos'; > delete from db where user='carlos'; > delete from procs_priv where user='carlos'; > delete from tables_priv where user='carlos'; > delete from user where user='carlos'; > > then a nice FLUSH PRIVILEGES; > > this should fix, let me know!
Worked great!!! mysql> select User, Host, Password from user; +------+-----------+-------------------------------------------+ | User | Host | Password | +------+-----------+-------------------------------------------+ | root | localhost | *FDCCC9BE5FC366E7D9714988DBC7F111A950C428 | +------+-----------+-------------------------------------------+ 1 row in set (0.00 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org