mysql抓包_mysql 协议抓包

为了时区

服务器抓包：tcpdump -i eth0 tcp and port 3306  -s 0 -w mysql.pcap

数据源：1ee

public class JdbcUtilTcp {

private static final String URL_NO_TIMEZONE="jdbc:mysql://49.235.75.155:3306/mytest?useUnicode=true&characterEncoding=utf-8&useSSL=false";

private static final String USER="root";

private static final String PASSWORD="Sunyumin";

public static void main(String []f) {

select();

}

public static List> select() {

Connection conn = null;

ResultSet rs = null;

List> list = new ArrayList<>();

try{

conn = DriverManager.getConnection(URL_NO_TIMEZONE, USER, PASSWORD);

conn.setAutoCommit(false);

PreparedStatement pstmt = conn.prepareStatement("select * from mytest where id = 1");

rs = pstmt.executeQuery();

ResultSetMetaData md = rs.getMetaData();

int columnCount = md.getColumnCount();

while (rs.next()) {

Map rowData = new HashMap();

for (int i = 1; i <= columnCount; i++) {

rowData.put(md.getColumnLabel(i), rs.getObject(i));

}

list.add(rowData);

}

if(!conn.getAutoCommit())

conn.commit();

System.out.println(list);

} catch (Exception e){

e.printStackTrace();

try {

if(!conn.getAutoCommit())

conn.rollback();

} catch (SQLException e1) {

e1.printStackTrace();

}

}

return list;

}

}

证明了mysql很可能是文本协议，通篇没有找到明显时区信息

注意，tcp包里面sql是明文的，容易被中间人篡改