Getting Started:

Edited /etc/mysql/mariadb.conf.d/50-server.cnf and uncommented the following:

Then restarted mariadb

Then I entered some data on the website:

Log:

Sent some failed logins:

Log with failed logins:

Using grep:

Using awk:

Now in dbsec.bash:

---

My own script:

Deliverable 3:

I'm not sure why the outputs are so messy since I'm using the exact code with slight modifications to make it so it'll get connect instead of access denied messages but both outputs were messy so I just moved on since all the necessary info is there.