Table of Contents

1. Challenge

   Log into the MySQL Database

   As the cloud_user, run the following command and enter the password from the instructions (under Additional Information) when prompted:

   # mysql -u root -p

2. Challenge

   Delete the `bad_data` Database from the MySQL Server

   In the mysql prompt, run the following command:

   mysql> DROP DATABASE bad_data;

3. Challenge

   Create a Database Named `customer_info`

   In the mysql prompt, run the following command:

   mysql> CREATE DATABASE customer_info;

4. Challenge

   Delete the Table `payment_info` from the `2004_data` Database

   In the mysql prompt, change the database to 2004_data:

   mysql> USE 2004_data;

   Drop the payment_info table:

   mysql> DROP TABLE payment_info;

5. Challenge

   Create a Table Named `payment_info` in the `customer_info` Database According to the Characteristics Provided in the Instructions

   Change the database to customer_info:

   mysql> USE customer_info;

   Create the payment_info table with the characteristics provided:

   mysql> CREATE TABLE payment_info (cust_id INT AUTO_INCREMENT PRIMARY KEY, user_name VARCHAR(50) UNIQUE, card_number INT, purchase_item VARCHAR(255));

   Verify that the table was created as expected:

   mysql> DESCRIBE payment_info;

   Exit the mysql prompt:

   mysql> exit