List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 24 2000 11:46am
Subject:Re: question about mysql.user table?
View as plain text  
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
Thread
question about mysql.user table?sqlmy23 Apr
  • Re: question about mysql.user table?Tonu Samuel23 Apr
  • Re: question about mysql.user table?Paul DuBois24 Apr