need help on USERs of MySQL

[sarma]

dear frens,

Can u tell me the command to know the no. of users created for a single database?

like if i create a user test for database "sample", is there any command to know whether it is created. Show tables will show all the tables in that database, is there any command for users of that kind?????

thank in advance
sarma

[ronverdonk]

Why do you post this question in 2 threads??? The answer won't get any quicker.

Ronald :cool:

[satyasuman]

dear frens,

Can u tell me the command to know the no. of users created for a single database?

like if i create a user test for database "sample", is there any command to know whether it is created. Show tables will show all the tables in that database, is there any command for users of that kind?????

thank in advance
sarma

Is that in SQL server or in ORACLE? you posted a question in sql forums and looks like the question is about oracle. which database is that?

cheers,
satya.

[sarma]

I am using MySQL as my database....... in that i want to know command to know how many users are created on a particular database...


sarma