List two ways you can specify the MariaDB password for a user so as to access MariaDB.

Using MariaDB interactively, create a database named dbsam that the user named sam can modify and grant privileges on. Set up Sams password to be porcupine. The MariaDB user named root has the password five22four.

Which commands would you use to set up a table in dbsam (created in exercise 2) named shoplist with the following columns of the specified types: day [DATE], store [CHAR(20)], lettuce [SMALLINT], soupkind [CHAR(20)], soupnum [INTEGER], and misc [VARCHAR(40)]?