{"id":144,"date":"2019-02-10T18:10:29","date_gmt":"2019-02-10T10:10:29","guid":{"rendered":"http:\/\/b.yesiyu.top\/?p=144"},"modified":"2019-02-10T18:10:29","modified_gmt":"2019-02-10T10:10:29","slug":"mysql%e6%9c%8d%e5%8a%a1%e5%99%a8%e9%97%ae%e9%a2%98","status":"publish","type":"post","link":"https:\/\/b.yesiyu.top\/?p=144","title":{"rendered":"MySQL\u670d\u52a1\u5668\u95ee\u9898"},"content":{"rendered":"

\u542f\u52a8MySQL\u670d\u52a1\u5668\u7a0b\u5e8f\uff0c\u786e\u8ba4\u72b6\u6001<\/p>\n

1\uff09\u542f\u52a8MySQL\u670d\u52a1\u7a0b\u5e8f<\/p>\n

\u542f\u52a8\u670d\u52a1\u5e76\u67e5\u770b\u72b6\u6001\uff1a<\/p>\n

[<\/span>root@dbsvr1 pub<\/span>]#<\/span> service mysql start\r\n<\/span>Starting<\/span> MySQL<\/span>...<\/span>                                     [\u786e\u5b9a]<\/span>\r\n[<\/span>root@dbsvr1 pub<\/span>]#<\/span> service mysql status\r\n<\/span>MySQL<\/span> running <\/span>(<\/span>31724<\/span>)<\/span>                                 [\u786e\u5b9a]<\/span><\/pre>\n
\u670d\u52a1\u5668\u8fdb\u7a0b\u4e3amysqld\uff0c\u76d1\u542c\u7684\u9ed8\u8ba4\u7aef\u53e3\u4e3aTCP 3306\uff1a<\/p>\n
[<\/span>root@dbsvr1 pub<\/span>]#<\/span> netstat <\/span>-<\/span>anpt <\/span>|<\/span> grep mysql\r\ntcp        <\/span>0<\/span>      0<\/span> :::<\/span>3306<\/span>        :::*<\/span>       LISTEN      <\/span>31724<\/span>\/<\/span>mysqld<\/span><\/pre>\n
2\uff09\u67e5\u770bMySQL\u670d\u52a1\u5668\u8fdb\u7a0b\u3001\u8fd0\u884c\u7528\u6237<\/p>\n
\u63d0\u4f9b\u8fde\u63a5\u670d\u52a1\u7684\u8fdb\u7a0b\u4e3amysqld\uff0c\u7531\u5176\u7236\u8fdb\u7a0bmysqld_safe\u542f\u52a8\u3002<\/p>\n
[<\/span>root@dbsvr1 pub<\/span>]#<\/span> ps <\/span>-<\/span>elf <\/span>|<\/span> grep mysqld\r\n\r\n<\/span>4<\/span> S root     <\/span>31619<\/span>     1<\/span>  0<\/span>  80<\/span>   0<\/span> -<\/span>  2834<\/span> wait   <\/span>15<\/span>:<\/span>14<\/span> pts<\/span>\/<\/span>0<\/span>    00<\/span>:<\/span>00<\/span>:<\/span>00<\/span> \/<\/span>bin<\/span>\/<\/span>sh <\/span>\/<\/span>usr<\/span>\/<\/span>bin<\/span>\/<\/span>mysqld_safe <\/span>--<\/span>datadir<\/span>=<\/span>\/var\/<\/span>lib<\/span>\/<\/span>mysql <\/span>--<\/span>pid file<\/span>=<\/span>\/var\/<\/span>lib<\/span>\/<\/span>mysql<\/span>\/<\/span>dbsvr1<\/span>.<\/span>tarena<\/span>.<\/span>com<\/span>.<\/span>pid\r\n\r\n<\/span>4<\/span> S mysql    <\/span>31724<\/span> 31619<\/span>  0<\/span>  80<\/span>   0<\/span> -<\/span> 252496<\/span> poll_s <\/span>15<\/span>:<\/span>14<\/span> pts<\/span>\/<\/span>0<\/span>   00<\/span>:<\/span>00<\/span>:<\/span>01<\/span> \/<\/span>usr<\/span>\/<\/span>sbin<\/span>\/<\/span>mysqld <\/span>--<\/span>basedir<\/span>=<\/span>\/usr --datadir=\/<\/span>var<\/span>\/<\/span>lib<\/span>\/<\/span>mysql <\/span>--<\/span>plugin<\/span>-<\/span>dir<\/span>=<\/span>\/usr\/<\/span>lib64<\/span>\/<\/span>mysql<\/span>\/<\/span>plugin <\/span>--<\/span>user<\/span>=<\/span>mysql <\/span>--<\/span>log<\/span>-<\/span>error<\/span>=<\/span>\/var\/<\/span>lib<\/span>\/<\/span>mysql<\/span>\/<\/span>dbsvr1<\/span>.<\/span>tarena<\/span>.<\/span>com<\/span>.<\/span>err <\/span>--<\/span>pid<\/span>-<\/span>file<\/span>=<\/span>\/var\/<\/span>lib<\/span>\/<\/span>mysql<\/span>\/<\/span>dbsvr1<\/span>.<\/span>tarena<\/span>.<\/span>com<\/span>.<\/span>pid<\/span><\/pre>\n
\u6570\u636e\u5e93\u7684\u9ed8\u8ba4\u5b58\u653e\u4f4d\u7f6e\u4e3a \/var\/lib\/mysql\uff1a<\/p>\n
[<\/span>root@dbsvr1 pub<\/span>]#<\/span> ls <\/span>\/<\/span>var<\/span>\/<\/span>lib<\/span>\/<\/span>mysql<\/span>\/<\/span>\r\nauto<\/span>.<\/span>cnf               ibdata1      mysql               RPM_UPGRADE_HISTORY\r\ndbsvr1<\/span>.<\/span>tarena<\/span>.<\/span>com<\/span>.<\/span>err  ib_logfile0  mysql<\/span>.<\/span>sock          RPM_UPGRADE_MARKER<\/span>-<\/span>LAST\r\ndbsvr1<\/span>.<\/span>tarena<\/span>.<\/span>com<\/span>.<\/span>pid  ib_logfile1  performance_schema  test<\/span><\/pre>\n","protected":false},"excerpt":{"rendered":"
\u542f\u52a8MySQL\u670d\u52a1\u5668\u7a0b\u5e8f\uff0c\u786e\u8ba4\u72b6\u6001 1\uff09\u542f\u52a8MySQL\u670d\u52a1\u7a0b\u5e8f \u542f\u52a8\u670d\u52a1\u5e76\u67e5\u770b\u72b6\u6001\uff1a [root@dbsvr1 … <\/p>\n
\u7ee7\u7eed\u9605\u8bfb\u201cMySQL\u670d\u52a1\u5668\u95ee\u9898\u201d<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-144","post","type-post","status-publish","format-standard","hentry","category-liunx-"],"_links":{"self":[{"href":"https:\/\/b.yesiyu.top\/index.php?rest_route=\/wp\/v2\/posts\/144","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/b.yesiyu.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/b.yesiyu.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/b.yesiyu.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/b.yesiyu.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=144"}],"version-history":[{"count":1,"href":"https:\/\/b.yesiyu.top\/index.php?rest_route=\/wp\/v2\/posts\/144\/revisions"}],"predecessor-version":[{"id":145,"href":"https:\/\/b.yesiyu.top\/index.php?rest_route=\/wp\/v2\/posts\/144\/revisions\/145"}],"wp:attachment":[{"href":"https:\/\/b.yesiyu.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=144"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/b.yesiyu.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=144"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/b.yesiyu.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}