mysqllisted

# mysql Use `mysql` to interact with MySQL databases. ## Common Commands ### Connection - Connect: `mysql -h <host> -u <user> -p<password> <database>` - Execute query: `mysql -e "SELECT * FROM table LIMIT 10" <database>` ### Inspection - List databases: `SHOW DATABASES;` - List tables: `SHOW TABLES;` - Describe table: `DESCRIBE <table_name>;` ### Operations - Execute from file: `mysql <database> < migration.sql` - Export: `mysqldump -u <user> -p <database> > backup.sql` - Import: `mysql <database> < backup.sql` ## Notes - Avoid passing password as command-line argument in shared environments - Use `~/.my.cnf` for stored credentials