MySQL: Create a Shop Database

The e-commerce team needs a product database and a read-only user for the website.

Tasks

  1. Create a database named shop.
  2. Create table shop.products (id, name, price) and insert at least 2 products.
  3. Create user app@localhost with SELECT access on shop.