Answers for "sql how to check users access"

sql show all users

#show all users and hosts
SELECT User, Host FROM mysql.user;

# show all users with passwords
SELECT User, Host, Password, password_expired FROM mysql.user;

t SQl Checking Your Username

ORIGINAL_LOGIN(), CURRENT_USER
SYSTEM_USER;
SELECT ORIGINAL_LOGIN(), CURRENT_USER, SYSTEM_USER;