Sequel writeup

10.129.42.195

Task 1 – During our scan, which port do we find serving MySQL?

Scanned the machine with nmap.

A: 3306

Task 2 – What community-developed MySQL version is the target running?

A: MariaDB

Task 3 – When using the MySQL command line client, what switch do we need to use in order to specify a login username?

I had previous notes “”Mysql -u {username} -h {hostname} -p””.

A: -u

Task 4 – Which username allows us to log into this MariaDB instance without providing a password?

Googled this.

A: root

Task 5 – In SQL, what symbol can we use to specify within the query that we want to display everything inside a table?

A: *

Task 6 – In SQL, what symbol do we need to end each query with?

Both questions are pretty common knowledge.

A: ;

Task 7 – There are three databases in this MySQL instance that are common across all MySQL instances. What is the name of the fourth that’s unique to this host?

A: htb

Submit Flag:

Moved into the database using “”USE htb””. Then listed the tables using “”SHOW TABLES;””. You can see I missed the ; at the end but it went to the next line and let me use it. I listed everything found in users. As there wasn’t any use to move forward with the back with that information I checked out the table config and we found it.

A: 7b4bec00d1a39e3dd4e021ec3d915da8

GG

Leave a comment