mysql -h <IP_TARGET> -u root -p
#Poi inserisci la passwordNel caso ti venisse restituito questo errore: ERROR 2026 (HY000): TLS/SSL error: self-signed certificate in certificate chain
Usa questa sintassi:
mysql -h <IP_TARGET> -u root -p --skip-sslComandi
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 table. |
select * from <table>; | Show everything in the desired table. |
select * from <table> where <column> = "<string>"; | Search for needed string in the desired table. |