mysql -u root -p -e "CREATE USER 'app'@'localhost' IDENTIFIED BY 'secret';"

Category: Databases & SQL

mysql -u root -p -e "CREATE USER 'app'@'localhost' IDENTIFIED BY 'secret';"

Create a MySQL user

Creates the app account limited to localhost; @'%' would allow any host. The password is hashed automatically. Grants are separate and must be issued afterwards.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.