mysql -u app -p -e 'SHOW DATABASES;'

Category: Databases & SQL

mysql -u app -p -e 'SHOW DATABASES;'

List databases non-interactively

-e executes the statement and returns to the shell, ideal for scripts. SHOW DATABASES lists every database the account can see. Wrap SQL in single quotes so the shell does not interpret it.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.