Create an account identified by user name and host.

Section: user management

Create a user

sql
sql
CREATE USER 'app_user'@'%' IDENTIFIED BY 'replace-with-strong-password';
Explanation

Host matching matters in MySQL accounts; `%` allows connections from any host.

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
Drop a user
Remove an account from the server.
OpenIn sheetsqlsame section
Change a user's password
Rotate credentials for an existing account.
OpenIn sheetsqlsame section
Show the current and authenticated user
Inspect who MySQL believes you are.
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.