Ciro Santilli @cirosantilli  40

sudo mysql

sudo mysql -e "CREATE USER $USER"

mysql -e 'SHOW DATABASES'

sudo mysql -e 'CREATE USER user0 IDENTIFIED WITH mysql_native_password BY "a"'
sudo mysql -e 'GRANT ALL PRIVILEGES ON database_name.* TO "user0"'

mysql -u user0 -p

mysql -u user0 -pmypassword

sudo mysql -e 'SELECT * FROM mysql.user'

sudo mysql -e 'SELECT * FROM mysql.db'

sudo mysql -e 'SHOW DATABASES'

sudo mysql -e 'CREATE DATABASE mydb0'

sudo mysql -e 'DROP DATABASE mydb0'

sudo mysql -e 'SHOW TABLES' mydb0

sudo mysql -e 'SHOW TABLES FROM mydb0'

sqlite3 db.sqlite3 "
CREATE TABLE 'IntegerNames' (int0 INT, char0 CHAR(16));
INSERT INTO 'IntegerNames' (int0, char0) VALUES (2, 'two'), (3, 'three'), (5, 'five'), (7, 'seven');
"

sqlite3 db.sqlite3 '.tables'

IntegerNames

sqlite3 db.sqlite3 '.schema IntegerNames'

CREATE TABLE IF NOT EXISTS 'IntegerNames' (int0 INT, char0 CHAR(16));

sqlite3 db.sqlite3 'SELECT * FROM IntegerNames'

2|two
3|three
5|five
7|seven