Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a MysQL database and call it csit101. Now let's create a table and call it administrators. This table contains three fields: adminlD, email, and

image text in transcribedimage text in transcribedimage text in transcribed

Create a MysQL database and call it csit101. Now let's create a table and call it administrators. This table contains three fields: adminlD, email, and password. The following shows the sql file that generates the database and the required table. It also populates with two users whose email addresses arei2gmail.com and kk@gmail.com. - create and select the database DROP DATABASE IF EXISTS CSIT101; CREATE DATABASE CSIT101; USE CSIT101; CREATE TABLE administrators adminlD email password VARCHAR 255) NOT NULL firstName VARCHAR 255) NOT NULL lastName VARCHAR(255) NOT NULL PRIMARY KEY (admin D) NOT NULL AUTO INCREMENT INT VARCHAR(255) NOT NULL INSERT INTO administrators (adminlD, email, password, firstName, lastName) VALUES 1, ij@gmail.com', sesame', John', Johnson'), 2, 'kk@gmail.com, password', "Karen, "King': -Create a user named super GRANT SELECT, INSERT, UPDATE, DELETE ON TO super@localhost DENTIFIED BY 'super'; The main purpose for creating the user named super is for use in the creating of PDO. Recall that in order to create a PDO we need a user who have the credential to access the required database. Although we don't need to grant full privileges to this user in order to run this lab, but we may use it later for other exercises

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Learning PostgreSQL

Authors: Salahaldin Juba, Achim Vannahme, Andrey Volkov

1st Edition

178398919X, 9781783989195

More Books

Students also viewed these Databases questions

Question

Explain strong and weak atoms with examples.

Answered: 1 week ago

Question

Explain the alkaline nature of aqueous solution of making soda.

Answered: 1 week ago

Question

Comment on the pH value of lattice solutions of salts.

Answered: 1 week ago