ref: https://www.cyberciti.biz/faq/howto-linux-unix-creating-database-and-table/ https://www.cyberciti.biz/faq/howto-linux-unix-creating-database-and-table/ https://www.cyberciti.biz/faq/howto-linux-unix-creating-database-and-table/ Procedure for creating a database and a sample table Login as the mysql root user to create database: $ mysql -u root -p Sample outputs: mysql> Add a database called books, enter: mysql> CREATE DATABASE books; Now, database is created. Use a database with use command, type: mysql> USE books; Next, create a table called authors with name, email and id as fields: mysql> CREATE TABLE authors (id INT, name VARCHAR(20), email VARCHAR(20)); To display your tables in books database, enter: mysql> SHOW TABLES; Sample outputs: +-----------------+ | Tables_in_books | +-----------------+ | authors | +-----------------+ 1 row in set (0.00 sec) Finally, add a data i.e. row to table books using INSERT statement, run: mysql> INSERT INTO...