That's not two root accounts. What that means is this: The first line defines privileges for root connecting from localhost The second line defines privileges for root connecting from any remote host. Hence the "%". It implies [EMAIL PROTECTED]
Hope this helps. Arjun Subramanian Georgia Tech Station 32003 Atlanta GA 30332 Cell: +404.429.5513 http://www.arjunweb.com -----Original Message----- From: Leo Donahue [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 2:47 PM To: [EMAIL PROTECTED] Subject: mysql database, user table, two root accounts I am less than 24 hours new to MySql. I have executed the following sql scripts: use mysql; delete from user where User=''; delete from db where User=''; flush privileges; select host, user, password from user; The last sql query yields the following: host user password --------------------------------- localhost root hexadecimal values. % root nothing here. Why are there two root accounts? Thanks, ld -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]