MySql/MariaDb command line cheatsheet

Commands

• Connect

mysql [-h 192.168.1.100] -u USER_NAME -p [DATABASE_NAME]

Will be prompted for password

Once connected, the commanda need to end with ;.

• Common commands ´´´ show tables;

´´´

• Exit Ctrl+C