Drop a user

sql

DROP USER IF EXISTS 'old_user'@'%';

Explanation

Use with care because dropping a user removes its login access immediately.

Learn the surrounding workflow

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

Same sheet · prioritizing user management

Create an account identified by user name and host.

Open In sheetsqlsame section

Rotate credentials for an existing account.

Open In sheetsqlsame section

Inspect who MySQL believes you are.

Open In sheetsqlsame section

Display existing accounts.

Open In sheetsqlsame section

Allow an app account to use one schema.

Give broad schema-level rights.