MySQL Users, Grants, and Privileges Cheatsheet/Show the current and authenticated user

Inspect who MySQL believes you are.

Section: user management

Show the current and authenticated user

sql
sql
SELECT USER(), CURRENT_USER();
Explanation

These can differ because of authentication and account resolution behavior.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing user management
Create a user
Create an account identified by user name and host.
OpenIn sheetsqlsame section
Change a user's password
Rotate credentials for an existing account.
OpenIn sheetsqlsame section
Drop a user
Remove an account from the server.
OpenIn sheetsqlsame section
List users from mysql.user
Display existing accounts.
OpenIn sheetsqlsame section
Grant privileges on one database
Allow an app account to use one schema.
Grant all privileges on a database
Give broad schema-level rights.