> delete from user where Password=''; > Be careful doing this on a fresh install, if you don't set > passwords for root first you will delete all the initial root > accounts too!
That is a good point. I always set the root password first. I just assumed that he would do that firt, but it is good to be clear. Thanks, Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org