Youve’ got a uber database servo, quod vos cant’ enable quaero logging… sic quam operor vos animadverto quaero res fungor obviam database?

refero: utor a modified network sniffer ut parse sicco MySQL facis quod pingo lemma. Youllhave’  efficio aliquantulus congero, tamen itll’ exsisto dignitas is. Nota ut is mos non usuallywork  pro locus iunctio, tametsi vos es exspectata experior.

Primoris, vos postulo ut install libpcap-dev, quod est development library ut sino an application ut sniff network facis.

sudo apt- adepto install libpcap-dev

Iam lets’ planto a presul, download radix code quod congero is

mkdir mysqlsniffer

cd mysqlsniffer

wget hackmysql.com/code/mysqlsniffer.tgz

tar xvfz mysqlsniffer.tgz

gcc O2 lpcap o mysqlsniffer mysqlsniffer.c packet_handlers.c misc.c

Procul is cuspis, nos have a crus novus executable nomen mysqlsniffer in nostrum radix presul. Vos can effingo is qua vos amo ( alicubi in semita would exsisto utilis)

Ut run mysqlsniffer, vos postulo ut proprius network interface ut MySQL est audio in. Mihi, suus’ eth0.

sudo semita/ ut/mysqlsniffer eth0

Sarcina of effercio satus volatilis per… lets’ spurcamen is sicco aliquantulus magis sic nos can iustus adepto quaero neque nec totus redundo notitia.

$ sudo semita/ ut/mysqlsniffer – haud-mysql-hdrs eth0 | grep COM_QUERY

192.168.73.1.2622 > servo: COM_QUERY: LEGO @@sql_mode
192.168.73.1.2622 > servo: COM_QUERY: PARO SESSION sql_mode=”
192.168.73.1.2622 > servo: COM_QUERY: PARO NOMEN utf8
192.168.73.1.1636 > servo: COM_QUERY: LEGO @@SQL_MODE
192.168.73.1.1636 > servo: COM_QUERY: OSTENDO PLENUS COLUMNS EX `db2842_howto`.`wp_users`

Proh, iam illic nos es… totus genus of quaero notitia, vacuus having ut sileo MySQL.

Hic arethe  plenus bene pro to order:

ritus mysqlsniffer [ bene] INTERFACE

Bene:
–prodigium N Audio pro MySQL in prodigium numerus N (default 3306)
–verbose Ostendo susicivus facis notitia
–tcp-ctrl Ostendo TCP imperium facis (SYN, FIN, RST, ACK)
–net-hdrs Ostendo major domus IP quod TCP caput capitis pendo
–haud-mysql-hdrs Operor non ostendo MySQL caput capitis ( facis ID quod tractus)
–civitas Ostendo civitas
–v40 MySQL servo est poema poematis 4.0
–dump Dump totus facis in hex
–succurro Procer is

Exemplar radix code quod magis notitia procul:
http:/hackmysql.com/mysqlsniffer/

Si vos es cursor in a development servo, is would exsisto facillimus ut iustusverto in quaero logging.