MySQL Basic Commands
Install MariaDB: sudo apt install mariadb-server Connect to MariaDB: sudo mysql Show databases available: show databases; Select ‘mysql’ database: use mysql; Show tables in a database: show tables; Retrieve everything: SELECT * FROM user; Retrieve only some columns: SELECT host, user, password FROM … Read More