# MySQL

`sudo nmap 10.129.14.128 -sV -sC -p3306 --script mysql*`

| `mysql -u <user> -p<password> -h <IP address>`       | Connect to the MySQL server. There should **not** be a space between the '-p' flag, and the password. |
| ---------------------------------------------------- | ----------------------------------------------------------------------------------------------------- |
| `show databases;`                                    | Show all databases.                                                                                   |
| `use <database>;`                                    | Select one of the existing databases.                                                                 |
| `show tables;`                                       | Show all available tables in the selected database.                                                   |
| `show columns from <table>;`                         | Show all columns in the selected database.                                                            |
| `select * from <table>;`                             | Show everything in the desired table.                                                                 |
| `select * from <table> where <column> = "<string>";` | Search for needed `string` in the desired table.                                                      |

|                                                |         |
| ---------------------------------------------- | ------- |
| `select version();`                            | Version |
| `use mysql;`                                   |         |
| `show tables;`                                 |         |
| `select host, unique_users from host_summary;` |         |