MySQL Forums
Forum List  »  Newbie

what is the first legal packet after auth phase completed?
Posted by: yu shang
Date: July 02, 2025 01:04AM

Hi guys,
I'm writing a lua client for mysql. After auth phase completed, I send a query command but got a packet out of order error, following is the dumping of complete packets, green circle means received from server, organge circle means send to server, the flag means having received the OK packet. After that is a query. The server responsed with packet out of order error. What I've missed. Many thanks!

🟢
49 00 00 00 0A 38 2E 34 I....8.4
2E 33 00 14 00 00 00 75 .3.....u
28 4B 75 79 3C 76 68 00 (Kuy<vh.
FF FF FF 02 00 FF DF 15 ........
00 00 00 00 00 00 00 00 ........
00 00 46 29 03 2E 47 76 ..F)..Gv
56 13 2E 01 43 31 00 63 V...C1.c
61 63 68 69 6E 67 5F 73 aching_s
68 61 32 5F 70 61 73 73 ha2_pass
77 6F 72 64 00 word.
🟠
63 00 00 01 0E 22 28 00 c...."(.
00 00 00 01 FF 00 00 00 ........
00 00 00 00 00 00 00 00 ........
00 00 00 00 00 00 00 00 ........
00 00 00 00 73 61 6C 65 ....sale
73 00 20 87 88 8C 54 96 s. ...T.
3F AB 5B E1 54 6D AE 5F ?.[.Tm._
B4 A6 18 F5 03 14 3C BE ......<.
65 01 28 E8 88 A8 34 AF e.(...4.
C4 CA 3D 73 61 6C 65 73 ..=sales
00 63 61 63 68 69 6E 67 .caching
5F 73 68 61 32 5F 70 61 _sha2_pa
73 73 77 6F 72 64 00 ssword.
🟢
2C 00 00 02 FE 6D 79 73 ,....mys
71 6C 5F 6E 61 74 69 76 ql_nativ
65 5F 70 61 73 73 77 6F e_passwo
72 64 00 75 28 4B 75 79 rd.u(Kuy
3C 76 68 46 29 03 2E 47 <vhF)..G
76 56 13 2E 01 43 31 00 vV...C1.
🟠
14 00 00 03 10 5D 35 88 .....]5.
C2 F8 18 AF 86 91 F2 51 .......Q
A5 89 39 6C E6 3A A7 92 ..9l.:..
🟢
07 00 00 04 00 00 00 02 ........
00 00 00 ...
🚩 0/0 2/0
🟠
15 00 00 05 03 73 65 6C .....sel
65 63 74 20 2A 20 66 72 ect * fr
6F 6D 20 75 73 65 72 73 om users
3B ;
🟢
21 00 00 00 FF 84 04 23 !......#
30 38 53 30 31 47 6F 74 08S01Got
20 70 61 63 6B 65 74 73 packets
20 6F 75 74 20 6F 66 20 out of
6F 72 64 65 72 order

Options: ReplyQuote


Subject
Written By
Posted
what is the first legal packet after auth phase completed?
July 02, 2025 01:04AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.