How to retrieve Mysql users list?

Hi. I want to retrieve Mysql users list. How to retrieve it? And where these users are stored?Please tell me.Thanks in advance.

 

select * from mysql.user;

Code (markup):

or just the name,

select User from mysql.user;

Code (markup):

 

and how to drop any user from the database?

 

delete from mysql.user WHERE User='name';

replace name with the name of the user

 

Msg 156, Level 15, State 1, Line 1Incorrect syntax near the keyword 'user'.could any please guid me.

 

possibilities: you didn't put the username in ' ' OR database with name 'mysql' doesn't exists OR forgot one ' or " or } or ] sign. It can be anything. echo your exact query and you'll know more.
Before the mysql_query()! In other case you'll get Resource id#n message.