{"id":5420,"date":"2018-11-15T07:35:54","date_gmt":"2018-11-15T07:35:54","guid":{"rendered":"https:\/\/dbtut.com\/?p=5420"},"modified":"2018-12-06T08:36:27","modified_gmt":"2018-12-06T08:36:27","slug":"how-to-get-the-data-packets-between-mysql-client-and-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/","title":{"rendered":"How to get the network packets between MySQL client and server?"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>Sometimes when we get ERROR messages such as the communication failure, MySQL server not responds your requests, or we want to know what the client sent to MySQL and how MySQL responds? Then we can capture network packets of the client and MySQL server.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: 'arial black', sans-serif; font-size: 14pt;\">Preparing:<\/span><\/p>\n<p><strong>Capturer tool:<\/strong> tcpdump command on Linux<\/p>\n<p><strong>Packets Analyzer:<\/strong> Wireshark\u00a0https:\/\/www.wireshark.org\/<\/p>\n<p><strong>MySQL Version:<\/strong> 8.0.12<\/p>\n<p><strong>MySQL Port:<\/strong> 8001<\/p>\n<p>&nbsp;<\/p>\n<h1>1. Capture packets<\/h1>\n<h2>(1) Start capturing packets<\/h2>\n<pre class=\"lang:default decode:true\">tcpdump -nnei any port 8001 -w tmp.pcap<\/pre>\n<p>This command means that capturing packets of port 8001 and writing result to the tmp.pcap file.<\/p>\n<p>Also you can get more information about tcpdump at\u00a0<a href=\"https:\/\/www.tcpdump.org\/manpages\/tcpdump.1.html\">https:\/\/www.tcpdump.org\/manpages\/tcpdump.1.html<\/a> .<\/p>\n<h2><\/h2>\n<h2>(2) Connect to MySQL Server and execute your queries<\/h2>\n<p>Open a new session for MySQL client.<\/p>\n<pre class=\"lang:default decode:true\">mysql -uroot -pqweasd -P 8001 -h192.168.100.184\r\n\r\nmysql&gt; show databases;\r\n\r\n+--------------------+\r\n\r\n| Database\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n+--------------------+\r\n\r\n| information_schema |\r\n\r\n| mysql\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| performance_schema |\r\n\r\n| sbtest\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| sys\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| testarchive\u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| wstest\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n+--------------------+\r\n\r\nmysql&gt; use wstest\r\n\r\nmysql&gt; show tables;\r\n\r\n+------------------+\r\n\r\n| Tables_in_wstest |\r\n\r\n+------------------+\r\n\r\n| mul_replace\u00a0 \u00a0 \u00a0 |\r\n\r\n| mul_replace_new\u00a0 |\r\n\r\n| t1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| test\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n+------------------+\r\n\r\nmysql&gt; select * from t1;\r\n\r\n+-----+------+-------+\r\n\r\n| a\u00a0 | b\u00a0 \u00a0 | c\u00a0 \u00a0 |\r\n\r\n+-----+------+-------+\r\n\r\n|\u00a0 1 |\u00a0 \u00a0 2 |\u00a0 \u00a0 3 |\r\n\r\n|\u00a0 2 |\u00a0 \u00a0 3 |\u00a0 100 |\r\n\r\n|\u00a0 3 |\u00a0 \u00a0 4 |\u00a0 100 |\r\n\r\n|\u00a0 11 |\u00a0 16 | 30000 |\r\n\r\n| 431 |\u00a0 12 |\u00a0 \u00a0 99 |\r\n\r\n+-----+------+-------+\r\n\r\nmysql&gt; exit<\/pre>\n<p>&nbsp;<\/p>\n<h2>(3)\u00a0Stop capturing<\/h2>\n<p>Just enter <strong>Ctrl+c<\/strong> to stop capturing\u00a0process. Then we can get a file named\u00a0tmp.pcap.<\/p>\n<p>&nbsp;<\/p>\n<h1>2. Analyze packets<\/h1>\n<p>Send the tmp.pcap file to a Windows PC, and using <strong>Wireshark<\/strong> to open it(<strong>Click File&#8211;Open to choose the packet file<\/strong>). After that, Wireshark shows the packets information as below.<\/p>\n<div class=\"image-package\">\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/790.png\" width=\"680\" height=\"362\" \/><\/p>\n<div class=\"image-caption\"><\/div>\n<\/div>\n<p>There are a lot of information,\u00a0and we just check the <strong>Data part of the Packet Details Pane<\/strong> this time.<\/p>\n<p>Then choose one of the TCP stream, &#8216;8001 -&gt; 50615&#8217; and &#8216;50615 -&gt; 8001&#8217; at the Info column mean the source and destination ports, right <strong>click &#8212;-&gt; Follow &#8212;-&gt; TCP Stream<\/strong>, after that, we can get the data details during the capturing time.<\/p>\n<div class=\"image-package\">\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/972.png\" width=\"671\" height=\"312\" \/><\/p>\n<div class=\"image-caption\"><\/div>\n<\/div>\n<p>As the\u00a0TCP Stream\u00a0showing below, we can see what information has been transmitted on the network.<\/p>\n<div class=\"image-package\">\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/395.png\" width=\"666\" height=\"347\" \/><\/p>\n<div class=\"image-caption\"><\/div>\n<\/div>\n<p>And we can choose &#8216;8001 &#8212;-&gt; 50615(send from MySQL server)&#8217; or\u00a0 &#8216;50615\u00a0&#8212;-&gt;8001(send to MySQL server)&#8217;, and if &#8216;choosing\u00a050615\u00a0&#8212;-&gt; 8001&#8217;, then we can get the information we just executed:<\/p>\n<div class=\"image-package\">\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/255.png\" width=\"488\" height=\"310\" \/><\/p>\n<div class=\"image-caption\"><\/div>\n<\/div>\n<p>And we can see some key words like &#8216;<em>caching_sha2_password<\/em>&#8216;(MySQL password encryption method), &#8216;<em>mysql._client_version.8.0.12<\/em>&#8216;(MySQL Client version), &#8216;<em>show databases<\/em>&#8216;, &#8216;<em>show tables<\/em>&#8216;, &#8216;<em>select * from t1<\/em>&#8216;.Also, we can get the information the server responds to these queries:<\/p>\n<div class=\"image-package\">\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/210.png\" width=\"508\" height=\"451\" \/><\/p>\n<div class=\"image-caption\"><\/div>\n<\/div>\n<p>Then we can get the data that server sent to client, such as &#8216;<em>8.0.12<\/em>&#8216;,&#8217;<em>caching_sha2_password<\/em>&#8216;, &#8216;<em>mysql_native_password<\/em>&#8216;, &#8216;<em>MySQL Community Server &#8211; GPL<\/em>&#8216;,&#8217;<em>information_schema, mysql, performance_schema,sys, wstest<\/em>&#8216; and so on. And these information are just what we can get after we execute queries.<\/p>\n<p>In our daily work, we can use this method to find out what information has been sent between the MySQL client and server. Also we can use it for auditing MySQL by analyzing packets, and this way won&#8217;t affect the performance of database instance because the audit log \u00a0is obtained through capturing\u00a0network packets.<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_5420\" class=\"pvc_stats all  \" data-element-id=\"5420\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Sometimes when we get ERROR messages such as the communication failure, MySQL server not responds your requests, or we want to know what the client sent to MySQL and how MySQL responds? Then we can capture network packets of the client and MySQL server. &nbsp; Preparing: Capturer tool: tcpdump command on Linux Packets Analyzer: &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_5420\" class=\"pvc_stats all  \" data-element-id=\"5420\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":50,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[7],"tags":[1556,1301],"class_list":["post-5420","post","type-post","status-publish","format-standard","","category-mysql","tag-capture-packet","tag-mysql"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to get the network packets between MySQL client and server? - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How to get the network packets between MySQL client and server?\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to get the network packets between MySQL client and server? - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How to get the network packets between MySQL client and server?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-15T07:35:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-06T08:36:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/790.png\" \/>\n<meta name=\"author\" content=\"Shuo Wang\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Shuo Wang\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/\"},\"author\":{\"name\":\"Shuo Wang\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/83d7028b846c78bfd03244ec6cd04289\"},\"headline\":\"How to get the network packets between MySQL client and server?\",\"datePublished\":\"2018-11-15T07:35:54+00:00\",\"dateModified\":\"2018-12-06T08:36:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/\"},\"wordCount\":447,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/790.png\",\"keywords\":[\"capture packet\",\"MySQL\"],\"articleSection\":[\"MySQL-MariaDB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/\",\"name\":\"How to get the network packets between MySQL client and server? - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/790.png\",\"datePublished\":\"2018-11-15T07:35:54+00:00\",\"dateModified\":\"2018-12-06T08:36:27+00:00\",\"description\":\"How to get the network packets between MySQL client and server?\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/790.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/790.png\",\"width\":1240,\"height\":660},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to get the network packets between MySQL client and server?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/83d7028b846c78bfd03244ec6cd04289\",\"name\":\"Shuo Wang\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/da30aa3d0157ae5f1f853927f56b868cfb1d801888eb954768c471e5d41cdd87?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/da30aa3d0157ae5f1f853927f56b868cfb1d801888eb954768c471e5d41cdd87?s=96&d=mm&r=g\",\"caption\":\"Shuo Wang\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/shuowang\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to get the network packets between MySQL client and server? - Database Tutorials","description":"How to get the network packets between MySQL client and server?","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/","og_locale":"en_US","og_type":"article","og_title":"How to get the network packets between MySQL client and server? - Database Tutorials","og_description":"How to get the network packets between MySQL client and server?","og_url":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/","og_site_name":"Database Tutorials","article_published_time":"2018-11-15T07:35:54+00:00","article_modified_time":"2018-12-06T08:36:27+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/790.png","type":"","width":"","height":""}],"author":"Shuo Wang","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Shuo Wang","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/"},"author":{"name":"Shuo Wang","@id":"https:\/\/dbtut.com\/#\/schema\/person\/83d7028b846c78bfd03244ec6cd04289"},"headline":"How to get the network packets between MySQL client and server?","datePublished":"2018-11-15T07:35:54+00:00","dateModified":"2018-12-06T08:36:27+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/"},"wordCount":447,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/790.png","keywords":["capture packet","MySQL"],"articleSection":["MySQL-MariaDB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/","url":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/","name":"How to get the network packets between MySQL client and server? - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/790.png","datePublished":"2018-11-15T07:35:54+00:00","dateModified":"2018-12-06T08:36:27+00:00","description":"How to get the network packets between MySQL client and server?","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/790.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/790.png","width":1240,"height":660},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-get-the-data-packets-between-mysql-client-and-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How to get the network packets between MySQL client and server?"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/83d7028b846c78bfd03244ec6cd04289","name":"Shuo Wang","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/da30aa3d0157ae5f1f853927f56b868cfb1d801888eb954768c471e5d41cdd87?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/da30aa3d0157ae5f1f853927f56b868cfb1d801888eb954768c471e5d41cdd87?s=96&d=mm&r=g","caption":"Shuo Wang"},"url":"https:\/\/dbtut.com\/index.php\/author\/shuowang\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/5420","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/50"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=5420"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/5420\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=5420"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=5420"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=5420"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}