{"id":107090,"date":"2020-05-28T23:44:02","date_gmt":"2020-05-28T15:44:02","guid":{"rendered":"http:\/\/4563.org\/?p=107090"},"modified":"2020-05-30T10:44:15","modified_gmt":"2020-05-30T02:44:15","slug":"%e5%a5%bd%e6%83%a8%e5%95%8a","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=107090","title":{"rendered":"\u597d\u60e8\u554a~~~~"},"content":{"rendered":"
\n
\n
\n

\u597d\u60e8\u554a~~~~ <\/h1>\n

<\/p>\n

\n
\u8cc7\u6df1\u5927\u4f6c : q1104408991 <\/span> <\/i> 4<\/span> <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
<\/p>\n

\u4eca\u5929\u65e9\u4e0a\u6765\u516c\u53f8\u53d1\u73b0 mysql \u88ab\u5220\u4e86…\u53ea\u7559\u4e0b\u4e86\u6bd4\u7279\u5e01\u5730\u5740\u548c\u90ae\u7bb1.\u641c\u5730\u5740\u548c\u6570\u636e\u5e93\u5173\u952e\u8bcd\u53d1\u73b0\u8fd9\u51e0\u5929\u6709\u597d\u591a\u4eba\u4e2d\u62db….\u73b0\u5728\u6062\u590d\u4e86\u8868….\u505a\u4e86\u81ea\u52a8\u5feb\u7167,\u5b9d\u5854\u540e\u53f0\u4e5f\u5f00\u901a\u4e86\u7f51\u7ad9\u9632\u706b\u5899,\u4fee\u6539\u4e86\u6570\u636e\u5e93\u5bc6\u7801,\u9650\u5236\u4e86\u6307\u5b9a ip \u767b\u5f55…..\u4e0d\u77e5\u9053\u6709\u6ca1\u6709\u7528,\u6709\u5927\u4f6c\u6709\u7c7b\u4f3c\u7684\u7ecf\u9a8c\u4e48,\u8fd9\u79cd\u4f1a\u4e0d\u4f1a\u6765\u7b2c\u4e8c\u6b21<\/p>\n<\/p><\/div>\n

\u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (34<\/span>) <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n
    \n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : kop1989 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u73b0\u5728\u7684\u75c5\u6bd2\u4e00\u70b9\u7075\u9b42\u90fd\u6ca1\u6709\uff0c\u5c31\u77e5\u9053\u6253\u94b1\u2026\u2026 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : mccreefei <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u662f\u4e0d\u662f mysql \u5141\u8bb8\u5916\u7f51\u8bbf\u95ee\u4e86 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : q1104408991 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @mccreefei \u662f….\u5f00\u653e\u4e86\u5168\u90e8 ip \u8bbf\u95ee,\u73b0\u5728\u5df2\u7ecf\u5173\u95ed\u4e86 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : gabezhao <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u8981\u5728\u4f60\u7684\u817f\u4e0a\u5199\u4e00\u4e2a\u5927\u5927\u7684\u60e8\u5b57 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : chairuosen <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6570\u636e\u5e93\u6562\u5f00\u5916\u7f51\u3002\u3002\u3002NB <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : alienx717 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u7559\u4e86\u4e2a email \u4e48 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : q1104408991 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @alienx717 \u7559\u4e86\u4e00\u4e2a\u6bd4\u7279\u5e01\u5730\u5740,\u8fd8\u6709\u4e00\u4e2a\u90ae\u7bb1 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : pengjay <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6d4b\u8bd5\u670d\u66fe\u7ecf\u4e2d\u8fc7\u62db\u3002\u3002\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : fixend <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u670d\u52a1\u5668\u4ec0\u4e48\u7248\u672c\uff1f mysql \u7248\u672c\u5462\uff1f\u8fd9\u4e2a\u662f mysql \u6f0f\u6d1e\u5bfc\u81f4\u7684\u5417\uff1f <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : lbmjsls1 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    php? <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : fenrao <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u540c\u60e8\u554a\uff0c\u4e5f\u662f\u6700\u8fd1\u51e0\u5929\u4e2d\u62db\u4e86\uff0c\u4e0d\u8fc7\u6211\u7684\u662f\u6d4b\u8bd5\u670d\u52a1\u5668\uff0c\u6211\u4e2a\u4eba\u7528\u6765\u6d4b\u8bd5\u7684\uff0c\u5927\u610f\u4e86\uff0c\u4eca\u5929\u60f3\u7528\u7684\u65f6\u5019\u53d1\u73b0\u6570\u636e\u5e93\u8868\u90fd\u6ca1\u4e86\uff0c\u4e5f\u662f\u53ea\u7559\u6bd4\u7279\u5e01\u548c\u4ed8\u6b3e\u7f51\u7ad9 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : mccreefei <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u81ea\u5df1\u670d\u52a1\u5668\u5f00\u8fc7\u5916\u7f51\u8bbf\u95ee\u4e5f\u4e2d\u8fc7\uff0c\u5173\u95ed\u5916\u7f51\u8bbf\u95ee\u4e00\u822c\u5c31\u6ca1\u4e8b\u4e86
    https:\/\/imgur.com\/wFckoTY <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : fanyingmao <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6700\u540e\u4ed8\u4e0d\u4ed8\u5462\uff1f\u8bdd\u8bf4\u4ee5\u524d\u4e5f\u8fdb\u8fc7\u522b\u4eba\u6570\u636e\u5e93 \u4e5f\u60f3\u5230\u53ef\u4ee5\u8fd9\u4e48\u5e72\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : ZSeptember <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u592a\u60e8\u4e86\u5427\uff0c\uff0c\uff0c\u4ee5\u524d\u7684\u516c\u53f8\u4e5f\u7ecf\u5386\u8fc7\uff0cmongo \u3002
    \u5b89\u5168\u65e0\u5c0f\u4e8b\u554a\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : q1104408991 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @fanyingmao \u4e0d\u4ed8,\u56e0\u4e3a\u6211\u67e5\u770b log \u7684\u65f6\u5019\u53d1\u73b0\u4ed6\u6267\u884c\u7684\u662f drop \u64cd\u4f5c….\u5b8c\u5168\u5c31\u662f\u4e3a\u4e86\u9a97\u94b1 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : q1104408991 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @fixend \u670d\u52a1\u5668\u662f\u963f\u91cc\u4e91\u7684 win10 2016 \u6570\u636e\u7248 mysql \u662f 5.5 \u5e94\u8be5\u4e0d\u662f\u6f0f\u6d1e\u5bfc\u81f4\u7684 \u5b8c\u5168\u662f\u6211\u50bb….\u5f00\u653e\u4e86\u6240\u6709 ip \u8bbf\u95ee <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : wtks1 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5f00\u653e\u5916\u7f51\u8bbf\u95ee\uff0c\u597d\u6b79\u7528\u9632\u706b\u5899\u9650\u5b9a\u4e00\u4e0b IP \u554a <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : q1104408991 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @mccreefei \u4e70\u4e86\u5b9d\u5854\u7684\u7f51\u7ad9\u9632\u706b\u5899\u670d\u52a1.\u5e0c\u671b\u6ca1\u6709\u7b2c\u4e8c\u6b21\u4e86 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : q1104408991 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @ZSeptember \u55ef\u55ef,\u6570\u636e\u5e93\u7279\u522b\u8981\u6ce8\u610f\u4e00\u4e0b <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : ilaipi <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5e94\u8be5\u662f\u5f00\u653e ip + \u9ed8\u8ba4\u7aef\u53e3 + \u7b80\u5355\u5bc6\u7801\u5427\uff1f \"\u597d\u60e8\u554a~~~~\" \"\u597d\u60e8\u554a~~~~\" <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : revalue <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5413\u5f97\u6211\u90fd\u4e0d\u6562\u7528 mysql \u4e86 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : revalue <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u7eaf\u5c5e\u65e0\u77e5 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : 5G <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u53d1\u4e2a\u90ae\u4ef6\uff1a\u4e0b\u6b21\u8bb0\u5f97 Truncate <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : Hellert <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5413\u5f97\u6211\u8d76\u7d27\u628a MySQL \u7684\u5916\u7f51\u8bbf\u95ee\u5173\u4e86 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : hst001 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @fanyingmao #13 \u6bd4\u7279\u5e01\u52d2\u7d22\u7684\u90fd\u662f\u76f4\u63a5\u5220\u6570\u636e\uff0c\u4f60\u5f53\u771f\u653b\u51fb\u8005\u771f\u7684\u4f1a\u4e70\u786c\u76d8\u7ed9\u4f60\u5907\u4efd\u6570\u636e\u5417\uff1f\u4ed8\u4e86\u94b1\u5c31\u518d\u635f\u5931\u4e00\u7b14\u94b1\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : whasyt <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @ZSeptember \u53ef\u4ee5\u8bf4\u8bf4 mongo \u88ab\u5220\u65f6 \uff0c\u670d\u52a1\u5668\u8bbe\u7f6e\u662f\u4ec0\u4e48\u60c5\u666f\u5417\uff1f <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : kisshere <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u501f\u4e2a\u95ee\u4e00\u53e5\uff0c\u600e\u4e48\u67e5\u770b MySQL \u662f\u5426\u5f00\u542f\u4e86\u5916\u7f51\u8bbf\u95ee\u6743\u9650\uff1f <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : respect11 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u7528\u5b9d\u5854\u4e2d\u8fc7\u62db\u3002\u5c31\u5f88\u5947\u602a\uff0c\u6362\u5176\u4ed6\u96c6\u6210\u73af\u5883\u4e00\u70b9\u4e8b\u6ca1\u6709\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : dieser <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @kisshere
    \u5148\u5230\u6570\u636e\u5e93\u4e0a\u770b\u4e0b\uff0c
    use mysql \uff1b
    select user,host from user;
    \u770b\u662f\u4e0d\u662f\u5141\u8bb8\u6240\u6709\u4e3b\u673a\u90fd\u53ef\u4ee5\u8bbf\u95ee
    \u518d\u5230\u8def\u7531\u5668\u90a3\u8fb9\u770b\u4e0b\uff0c\u6709\u6ca1\u6709\u8bbe\u7f6e NAT\uff0c\u5185\u7f51\u670d\u52a1\u5668\u7aef\u53e3\u6620\u5c04\u5230\u516c\u7f51 IP \u7684\u67d0\u4e2a\u7aef\u53e3\u4e0a
    \u6bd4\u5982 mysql \u7684\u670d\u52a1\u5668 IP 192.168.0.100 \u7aef\u53e3 3306 \u516c\u7f51 IP1.1.1.1 \u8def\u7531\u5668\u4e0a NAT1.1.1.1:3306 <->192.168.0.100:3306
    \u522b\u4eba\u5c31\u53ef\u4ee5\u901a\u8fc7\u516c\u7f51 IP \u52a0\u7aef\u53e3\uff0c\u8bbf\u95ee\u4f60\u5185\u7f51\u7684\u6570\u636e\u5e93\u4e86<\/p>\n

    \u4e3b\u7684\u60c5\u51b5\u5e94\u8be5\u662f\u5f00\u653e\u4e86 22 \u7aef\u53e3\u52a0\u5f31\u5bc6\u7801\uff0c\u88ab\u4eba\u66b4\u529b\u7834\u89e3\u4e86\u5427\u3002 <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : opengps <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8fd9\u65f6\u5019\u5f97\u5938\u4e00\u5938 windows \u7684\u72ec\u5360\u673a\u5236\uff0c\u524d\u4e1c\u5bb6\u7684\u5783\u573e\u8fd0\u7ef4\uff0c\u8fde\u7aef\u53e3\u9632\u5fa1\u90fd\u6ca1\u505a\u5355\u4f4d\uff0c\u6570\u636e\u5e93\u673a\u5668\u4e2d\u75c5\u6bd2\u4e86\uff0c\u4f46\u662f\u56e0\u4e3a windows \u7684\u6570\u636e\u5e93\u670d\u52a1\u4e00\u76f4\u6ca1\u505c\uff0c\u6240\u4ee5\u6570\u636e\u5e93\u6587\u4ef6\u8eb2\u8fc7\u4e86\u88ab\u52a0\u5bc6\uff0c\u901a\u8fc7\u5c40\u57df\u7f51\u5b9e\u73b0\u4e86\u6570\u636e\u6551\u56de <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : mostkia <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u7528 SQLite \u7684\u65e0\u6240\u754f\u60e7[\u72d7\u5934] <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : cumt21g <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @kisshere \u4f60 mysql \u662f\u4e0d\u662f\u76d1\u542c 0.0.0.0?mysql \u6240\u5728\u7684\u673a\u5668\u662f\u4e0d\u662f\u53ef\u4ee5\u8bbf\u95ee\u5916\u7f51? <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : yukiloh <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u987a\u4fbf\u95ee\u4e0b,\u6211\u662f\u7528 maria10,\u8fd0\u8425\u5546\u90a3\u513f\u5173\u95ed 3306,\u7136\u540e\u53ea\u5141\u8bb8 localhost+ssh,ssh \u7981\u6b62\u5bc6\u7801\u767b\u5f55,\u5e73\u65f6\u5c31\u8fdc\u7a0b ssh \u4e0a\u53bb\u770b\u6570\u636e
    \u8fd9\u6837\u5b50\u7b97\u7b26\u5408\u57fa\u672c\u8981\u6c42\u5417 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : ZSeptember <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @whasyt 17 \u5e74\u7684\u65f6\u5019\uff0c\u90a3\u6bb5\u65f6\u95f4\u5e94\u8be5\u5f88\u591a mongo \u90fd\u4e2d\u62db\u4e86\u3002\u6ca1\u4ec0\u4e48\u5177\u4f53\u8bbe\u7f6e\uff0c\u5c31\u662f\u7aef\u53e3\u5f00\u653e\u5916\u7f51\u8bbf\u95ee\u4e86\uff0c\u88ab\u522b\u4eba\u626b\u5230\u4e86\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n","protected":false},"excerpt":{"rendered":"

    \u597d\u60e8\u554a~~~~ \u8cc7\u6df1\u5927\u4f6c : q1…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/107090"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=107090"}],"version-history":[{"count":1,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/107090\/revisions"}],"predecessor-version":[{"id":107092,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/107090\/revisions\/107092"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=107090"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=107090"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=107090"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}