Error: Lost connection to MySQL server at 'reading initial communication packet', system error: 104

user30424

3/25/23, 10:00 AM

I installed lamp server on 20.04 and it worked. But then suddenly I get Error: Lost connection to MySQL server at 'reading initial communication packet', system error: 104 no more mysql working, not on console nor in phpmyadmin. I tried removing packages but no success.

2021-11-25T09:58:04.279812Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1)  (Ubuntu).
2021-11-25T09:58:05.091914Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 874040
2021-11-25T09:58:05.117200Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-11-25T09:58:05.404299Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-11-25T09:58:05.623981Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-11-25T09:58:05.624100Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-11-25T09:58:05.627393Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-11-25T09:58:05.627554Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-11-25T09:58:05.645792Z 0 [ERROR] [MY-010952] [Server] The privilege system failed to initialize correctly. For complete instructions on how to upgrade MySQL to a new version please see the 'Upgrading MySQL' section from the MySQL manual.
2021-11-25T09:58:05.646358Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-11-25T09:58:07.133840Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1)  (Ubuntu).

176

0 + 0

lamp

mysql

tls

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: Error: Lost connection to MySQL server at 'reading initial communication packet', system error: 104

TH: ข้อผิดพลาด: ขาดการเชื่อมต่อกับเซิร์ฟเวอร์ MySQL ที่ 'การอ่านแพ็คเก็ตการสื่อสารเริ่มต้น' ข้อผิดพลาดของระบบ: 104

RO: Eroare: S-a pierdut conexiunea la serverul MySQL la „citirea pachetului de comunicare inițială”, eroare de sistem: 104

RU: Error: Lost connection to MySQL server at 'reading initial communication packet', system error: 104

VI: Lỗi: Mất kết nối với máy chủ MySQL khi 'đọc gói liên lạc ban đầu', lỗi hệ thống: 104

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.