Re: question about mysql.user table?

[Paul DuBois]

At 7:27 PM -0600 2000-04-23, sqlmy wrote:
>hi,
>    when i query with "select user,password from mysql.user where 
>user='root'",and the result is there are 2 root user in the table.So 
>why there are 2 root user?
>    thanx.

MySQL validations users based on host + user combinations.  Change
your query to select host,user,password and you'll probably see that
the two rows in question have different host values.

See Chapter 6 of the MySQL Reference Manual for more details.

-- 
Paul DuBois, paul@stripped