I have created four different users with specific privileges.
But when I run the below command I am seeing only root user. I am not seeing any other user other than root.
select * from information_schema.users.
show grants only shows the grants for the user that runs it.