Granting permission to remote machine to access Mysql database.

To view the user accounts in Mysql database,

Use select query on mysql.user as,

select host,user,password from mysql.user;

It will show how many users in mysql database.