1433, 3306 - SQL

MariaDB / MySQL

lexi@moderators:/opt/site.new$ mysql -u wordpressuser -p
Enter password: wordpresspassword123!!
MariaDB [(none)]> show databases;
MariaDB [(none)]> use wordpress;
MariaDB [wordpress]> show tables;
MariaDB [wordpress]> select * from wp_users;

Change password

The site useotools.com can be used to encode passwords and will return both the hash and also the SQL Query needed to update the table.

MariaDB [wordpress]> UPDATE `wp_users` SET `user_pass` = '$P$Butw21NZp/bVFKSgE6gbBKtLjkl3tQ/' WHERE user_login = 'admin';
Query OK, 1 row affected (0.002 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MariaDB [wordpress]> select * from wp_users;
[... snip ...]
|  1 | admin      | $P$Butw21NZp/bVFKSgE6gbBKtLjkl3tQ/ 

MSSQL

lab ➜ sqsh -S 10.0.50.46 -U sa -P Passw0rd! -D Voting
## List databases
1> SELECT name FROM master..sysdatabases
2> go
...
[*] flag 

## Change to db "flag" and list tables
1> use flag
2> go
1> SELECT name from sys.tables
2> go
...
 flags

## Dump content from table "flag"
1> SELECT * from flags
2> go

Last updated