Upgrade to Pro — share decks privately, control downloads, hide ads and more …

MySQL の接続エラーと8.0.24

MySQL の接続エラーと8.0.24

MySQL の接続エラーと8.0.24

D7e58c3627cba51ea08a554ccdb15d16?s=128

Satoshi MITANI

May 07, 2021
Tweet

Transcript

  1. .Z42-ͷ઀ଓΤϥʔͱ .Z42-ϦϦʔεϊʔτͰΘ͍Θ͍ݴ͏ษڧձ 'SJ !NJUB

  2. .Z42-ͷ઀ଓΤϥʔ w %#΁ͷ઀ଓ͕ԿΒ͔ͷݪҼͰ੾Εͯ͠·ͬͨέʔε w ୅දతͳΤϥʔϝοηʔδʣ 
 &3303 ): .Z42-TFSWFSIBTHPOFBXBZ 


    &3303 ): -PTUDPOOFDUJPOUP.Z42-TFSWFSEVSJOHRVFSZ
  3. ݪҼͷಛఆ͕೉͍͠ʜ w ొ৔ਓ෺͕ଟ͍ w /8εΠονɺ'8ɺϩʔυόϥϯαFUD w Τϥʔϝοηʔδ͕Θ͔Γʹ͍͘

  4. ݪҼͷಛఆ͕೉͍͠ʜ w ొ৔ਓ෺͕ଟ͍ w /8εΠονɺ'8ɺϩʔυόϥϯαFUD w Τϥʔϝοηʔδ͕Θ͔Γʹ͍͘

  5. Τϥʔϝοηʔδ w NZTRME͕མͪͨ w ʢԿͰ͠ΐ͏ʣ w XBJU@UJNFPVUͰλΠϜΞ΢τ w ʢԿͰ͠ΐ͏ʣ w

    NBY@BMMPXFE@QBDLFUͷ੍ݶ౸ୡ w ʢԿͰ͠ΐ͏ʣ
  6. Τϥʔϝοηʔδ w NZTRME͕མͪͨ w &3303 ): .Z42-TFSWFSIBTHPOFBXBZ w XBJU@UJNFPVUͰλΠϜΞ΢τ w

    ʢԿͰ͠ΐ͏ʣ w NBY@BMMPXFE@QBDLFUͷ੍ݶ౸ୡ w ʢԿͰ͠ΐ͏ʣ
  7. Τϥʔϝοηʔδ w NZTRME͕མͪͨ w &3303 ): .Z42-TFSWFSIBTHPOFBXBZ w XBJU@UJNFPVUͰλΠϜΞ΢τ w

    &3303 ): .Z42-TFSWFSIBTHPOFBXBZ w NBY@BMMPXFE@QBDLFUͷ੍ݶ౸ୡ w ʢԿͰ͠ΐ͏ʣ
  8. Τϥʔϝοηʔδ w NZTRME͕མͪͨ w &3303 ): .Z42-TFSWFSIBTHPOFBXBZ w XBJU@UJNFPVUͰλΠϜΞ΢τ w

    &3303 ): .Z42-TFSWFSIBTHPOFBXBZ w NBY@BMMPXFE@QBDLFUͷ੍ݶ౸ୡ w &3303 ): .Z42-TFSWFSIBTHPOFBXBZ
  9. ҟͳΔݪҼͳͷʹಉ͡Τϥʔ ϝοηʔδ͕ฦΔ

  10. ҟͳΔݪҼͳͷʹಉ͡Τϥʔϝοηʔδ͕ฦΔ w +%#$ͳΜͰ΋͔ΜͰ΋ɺDPNNVOJDBUJPOMJOLGBJMVSF w ʢ$POOFDUPS+WFSTJPOͰ͸վળ͞Ε͍ͯΔ͔΋͠Ε·ͤΜʣ w ࢀߟʣ%JWFJOUP.Z42-&SSPS!ZPLV 
 IUUQTTQFBLFSEFDLDPNZPLVEJWFJOUPNZTRMFSSPSZBQDUPLZPCB[JZPO

  11. ಉ͡ݪҼͰҟͳΔΤϥʔ͕ฦΔ w ͖ͬ͞ͱٯύλʔϯ w NBY@BMMPXFE@QBDLFUͷ੍ݶ౸ୡ $ for i in 1

    2 3 4 5; do mysql -ur -h127.0.0.1 malw < ins600.dmp; don e ERROR 2006 (HY000) at line 1: MySQL server has gone awa y ERROR 2006 (HY000) at line 1: MySQL server has gone awa y ERROR 1153 (08S01) at line 1: Got a packet bigger than 'max_allowed_packet' byte s ERROR 2006 (HY000) at line 1: MySQL server has gone awa y ERROR 1153 (08S01) at line 1: Got a packet bigger than 'max_allowed_packet' bytes
  12. ิ଍ w αʔόαΠυͷΤϥʔϩάͱরΒ͠߹ΘͤΕ͹ɺൺֱత੾Γ෼͚͸ͭ͘ w XBJU@UJNFPVU w 5IFXBJU@UJNFPVUQFSJPEXBTFYDFFEFE UIFJEMFUJNFTJODFMBTUDPNNBOEXBTUPPMPOH w NBY@BMMPXFE@QBDLFU

    w "CPSUFEDPOOFDUJPOUPECTCUFTUVTFSTZTCFIPTUMPDBMIPTU 
 (PUBQBDLFUCJHHFSUIBONBY@BMMPXFE@QBDLFUCZUFT 
  13. .Z42-

  14. w XBJU@UJNFPVUͰ੾ΒΕͨ͜ͱ͕Θ͔Δ👏 w XBJU@UJNFPVU w ௕࣌ؒɺԿ΋ϦΫΤετ͠ͳ͍ͱɺαʔό͕ίωΫγϣϯΛ੾Δ ͷվળ mysql> select now()

    ; ERROR 4031 (HY000): The client was disconnected by the server because of inactivity. See wait_timeout and interactive_timeout for configuring this behavior . No connection. Trying to reconnect.. . Connection id: 1 4 Current database: *** NONE ***
  15. ΫϥΠΞϯτ΋ཁ w .Z42-DMJFOU .Z42-TFSWFS w ˠ&3303 ): 5IFDMJFOUXBTEJTDPOOFDUFECZUIFTFSWFSCFDBVTFPGJOBDUJWJUZ w .Z42-DMJFOU

    .Z42-TFSWFS w ˠ&3303 ): -PTUDPOOFDUJPOUP.Z42-TFSWFSEVSJOHRVFSZ w .Z42-DMJFOU .Z42-TFSWFS w ˠ&3303 ): -PTUDPOOFDUJPOUP.Z42-TFSWFSEVSJOHRVFSZ
  16. ·ͱΊ w .Z42-ͰXBJU@UJNFPVUىҼͷ઀ଓΤϥʔ͔Ͳ͏͔ 
 ൑ఆ͠΍͘͢ͳͬͨΑʂ

  17. ͓͠·͍