WRITE SQL CODE

Q.1. System Variables

System variables can be set via the command line. Please write a sequence of statements to:

- Set safe updates to false for the session.

- Do the following at the global level: o Set the maximum number of connections to 45.

o Set the threshold for long running queries to 7 seconds do this at the global level.

o Set logs to expire when they are more than 3 days old

Write the commands to display the value of the four variables you have updated.

Q.2. Managing Users

Write statements that do the following:

- Create users as follows: o Create user daisy with password imadog

o Create user elmo with password imacat

o Create user ap_superuser with password imsuper

o Create user ap_dev with password apdev

o Create user ap_guest with password apuser

- Rename user daisy to have username lazydaisy

- Change password for daisy to be imalazydog

- Drop user elmo