└─$ mysql -h 10.10.226.198 -u root -p
Enter password:
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
Use the following command. The Singel quotes around the user name was necessary.
mysql -h 10.10.226.198 -u 'root' -p --skip-ssl
Enumeration Basic
SELECT VERSION();
SELECT USER();
SELECT CURRENT_USER();
SELECT DATABASE();
SHOW VARIABLES LIKE 'version%';
SHOW VARIABLES LIKE 'datadir%';
SHOW VARIABLES LIKE 'hostname%';
Users & Privileges
SELECT user, host FROM mysql.user;
SELECT user, host, authentication_string FROM mysql.user;
SELECT user, host, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Grant_priv, Super_priv, Create_user_priv, File_priv FROM mysql.user;
SHOW GRANTS FOR CURRENT_USER();
SHOW GRANTS FOR 'username'@'hostname';
Database and Tables
SHOW DATABASES;
USE database_name;
SHOW TABLES;
DESCRIBE table_name;
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='database_name';