{"id":1514,"date":"2020-03-14T18:48:40","date_gmt":"2020-03-14T09:48:40","guid":{"rendered":"https:\/\/oboki.net\/?p=1514"},"modified":"2020-05-12T11:43:46","modified_gmt":"2020-05-12T02:43:46","slug":"%eb%9d%bc%ec%a6%88%eb%b2%a0%eb%a6%ac-%ed%8c%8c%ec%9d%b4-4-apm-%ed%99%88%ec%84%9c%eb%b2%84-%ea%b5%ac%ec%b6%95%ed%95%98%ea%b8%b0-4","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/data-engineering\/database\/mysql\/%eb%9d%bc%ec%a6%88%eb%b2%a0%eb%a6%ac-%ed%8c%8c%ec%9d%b4-4-apm-%ed%99%88%ec%84%9c%eb%b2%84-%ea%b5%ac%ec%b6%95%ed%95%98%ea%b8%b0-4\/","title":{"rendered":"\ub77c\uc988\ubca0\ub9ac \ud30c\uc774 4 * APM \ud648\uc11c\ubc84 \uad6c\ucd95\ud558\uae30 4 &#8211; mysql \uc18c\uc2a4 \uc124\uce58"},"content":{"rendered":"<p>\uc131\uacf5\ud55c \ucf00\uc774\uc2a4\ub97c \uadf8\ub300\ub85c \uc801\uc73c\uba74 \uc9e7\uc740 \ub0b4\uc6a9\uc774\uc9c0\ub9cc \ud639\uc2dc\ub098 \ub098\uc911\uc5d0 \ub2e4\uc2dc \uc4f8\ubaa8\uac00 \uc788\uc744\uc9c0\ub3c4 \ubaa8\ub974\ub294 \uc0bd\uc9c8 \uacfc\uc815\uc744 \uae30\ub85d\ud558\uae30 \uc704\ud574\uc11c mysql \uc124\uce58 \uacfc\uc815\ub9cc \ubcc4\ub3c4\ub85c \uc815\ub9ac\ud55c\ub2e4.<\/p>\n<blockquote>\n<p>cannot execute binary file: Exec format error<\/p>\n<\/blockquote>\n<p>\uc77c\ub2e8, \uae30\uc874\uc5d0 x86 \ud658\uacbd\uc5d0\uc11c \uc815\ub9ac\ud574\ub193\uc740 \uc2a4\ud06c\ub9bd\ud2b8\ub85c mysql \ubc14\uc774\ub108\ub9ac\ub97c \uadf8\ub0e5 \ub2e4\uc6b4 \ubc1b\uc544 \uc2e4\ud589\ud588\ub294\ub370 \uc704 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud574\uc11c \uc7a0\uae50 \ub3d9\uc548 \uace0\ubbfc\uc5d0 \ube60\uc84c\uc5c8\ub2e4. \uba87\ubc88\uc774\uace0 \uadf8\ub0e5 \uc2e4\ud589\ud574\ubcf4\ub2e4\uac00 \ubcf4\ub2c8 \ubc14\uc774\ub108\ub9ac(<code>mysql-8.0.18-linux-glibc2.12-x86_64.tar.xz<\/code>)\uc5d0 x86_64 \ub77c\uace0 \uc801\ud78c\uac8c \uac11\uc790\uae30 \ub208\uc5d0 \ub4e4\uc5b4\uc654\uace0 \uadf8\uc81c\uc11c\uc57c \ub0b4\uac00 \ub77c\uc988\ubca0\ub9ac \ud30c\uc774 arm64 \uc5d0\uc11c \uc791\uc5c5\ud558\uace0 \uc788\ub2e4\ub294 \uc0ac\uc2e4\uc744 \uc54c\uc544\ucc28\ub838\ub2e4. \uc5b4\uca0b\ub4e0 mysql.com \uc5d0\uc11c \uc81c\uacf5\ud558\ub294 x86 \ubc14\uc774\ub108\ub9ac\ub294 \uc544\ud0a4\ud14d\ucc98\uac00 \ub2ec\ub77c\uc11c \uadf8\ub0e5 \uac00\uc838\ub2e4\uac00 \uc4f8 \uc218\uac00 \uc5c6\ub294\ub370, mysql 8.0 \ubc84\uc804\uc740 apt \ub85c \ubc14\ub85c \uc124\uce58\ud560 \uc218 \uc788\ub294 \ub808\ud3ec\ub3c4 \uc5c6\ub294 \uac83 \uac19\uc544\uc11c<del>(5.7\uc740 apt\ub85c \ubc1b\uc744 \uc218 \uc788\ub2e4)<\/del> \uc9c1\uc811 \ube4c\ub4dc\ud574\uc11c \uc4f0\uae30\ub85c \uacb0\uc815\ud558\uac8c \ub418\uc5c8\ub294\ub370 \uc774 \uc798\ubabb\ub41c \ud310\ub2e8\uc73c\ub85c \uc0bd\uc9c8\uc758 \ub2aa\uc5d0 \ube60\uc9c0\uac8c \ub418\uc5c8\ub2e4.<\/p>\n<h2>mysql \uc18c\uc2a4 \uc124\uce58<\/h2>\n<p>\uc77c\ub2e8 \ucef4\ud30c\uc77c \ub3c4\uad6c\uc778 <code>cmake<\/code>\ub97c \uba3c\uc800 \uc124\uce58\ud55c \ub4a4<\/p>\n<pre><code class=\"language-bash\">apt install cmake<\/code><\/pre>\n<p>mysql.com \uc5d0\uc11c \uc18c\uc2a4 \ucf54\ub4dc\ub97c \ub2e4\uc6b4\ubc1b\uc73c\uba74 \ub418\ub294\ub370, \ub2e4\uc74c\uacfc \uac19\uc774 boost \ud5e4\ub354\uac00 \ud3ec\ud568\ub41c \uac83\uc73c\ub85c \ubc1b\ub294\ub2e4. <del>\uc18c\uc2a4\ucf54\ub4dc\ub9cc 200\uba54\uac00\ubc14\uc774\ud2b8 \uac00\uae4c\uc774 \ub41c\ub2e4 \u3137\u3137<\/del><\/p>\n<blockquote>\n<p>Generic Linux (Architecture Independent), Compressed TAR Archive<br \/>\nIncludes Boost Headers<\/p>\n<\/blockquote>\n<pre><code class=\"language-bash\">curl https:\/\/cdn.mysql.com\/archives\/mysql-8.0\/mysql-boost-8.0.18.tar.gz\n | tar -xz &amp;&amp; cd mysql-8.0.18<\/code><\/pre>\n<p>\uc774 \uc0c1\ud0dc\uc5d0\uc11c \uc6d0\ub798\ub77c\uba74 \uba87\uac00\uc9c0 \uc635\uc158\ub9cc \uc124\uc815\ud55c \ub4a4 \ubc14\ub85c \ube4c\ub4dc\ud558\uba74 \ub410\uc744\ud150\ub370, 8.0.18 \ubc84\uc804\uc5d0\uc11c \ubb38\uc81c\uac00 \ub418\ub294 \uac83\uc778\uc9c0 arm64 \uc774\uc5b4\uc11c \ubb38\uc81c\uac00 \ub418\ub294 \uac83\uc778\uc9c0\ub294 \ubaa8\ub974\uaca0\uc9c0\ub9cc client \ucabd\uc5d0\uc11c \ub2e4\uc74c\uacfc \uac19\uc774 seg fault \uac00 \ubc1c\uc0dd\ud588\ub2e4.<\/p>\n<pre><code class=\"language-c\">mysql\n\nCopyright (c) 2000, 2019, Oracle and\/or its affiliates. All rights reserved.\n\nOracle is a registered trademark of Oracle Corporation and\/or its\naffiliates. Other names may be trademarks of their respective\nowners.\n\nSegmentation fault (core dumped)<\/code><\/pre>\n<p>gdb \ub85c \ubcf4\ub2c8 \ub2e4\uc74c\uacfc \uac19\uc740 \uc704\uce58\uc5d0\uc11c \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud588\ub294\ub370<\/p>\n<pre><code class=\"language-c\">Program received signal SIGSEGV, Segmentation fault.\n0x0000aaaaaab99a44 in terminal_alloc (el=el@entry=0xaaaaab1fd910, t=t@entry=0xaaaaaaea6820 &lt;tstr&gt;, \n    cap=0xffffffffffffe7f8 &lt;error: Cannot access memory at address 0xffffffffffffe7f8&gt;)\n    at \/app\/src\/mysql-8.0.18\/extra\/libedit\/terminal.c:334\n334     if (cap == NULL || *cap == &#039;\\0&#039;) {\n(gdb) <\/code><\/pre>\n<p>stackexchange \uc5d0\uc11c \ube44\uc2b7\ud55c \uacbd\uc6b0\uac00 \uc788\uc5b4 \ub530\ub77c\ud588\ub354\ub2c8 \ud574\uacb0 \ub410\ub2e4. <del>\ud639\uc2dc \uadf8\ub0e5 \ube4c\ub4dc \ud574\ubcf4\uace0 \uc704\uc640 \uac19\uc740 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0 \ub611\uac19\uc774 \ud574\ubcf4\uba74 \uc88b\uc744 \uac83 \uac19\uc740\ub370 \ube4c\ub4dc\ud558\ub294\ub370 \uc2dc\uac04\uc774 \uc5c4\uccad \ub4e4\uae30 \ub54c\ubb38\uc5d0 \ubbf8\ub9ac \uc124\uc815\ud558\ub294 \uac83\ub3c4 ..<\/del><\/p>\n<p><code>.\/mysql-8.0.18\/extra\/libedit\/terminal.c<\/code> \uc5d0\uc11c <code>termcap.h<\/code> \ub77c\uc774\ube0c\ub7ec\ub9ac\uac00 \uc6d0\ub798\ub294 <code>HAVE_TERMCAP_H<\/code> \ub9e4\ud06c\ub85c \uc548\uc5d0 \ub4e4\uc5b4\uc788\ub294\ub370 \uadf8\ub0e5 \ubb34\uc870\uac74 \ucc38\uc870\ud558\ub3c4\ub85d \ubc16\uc73c\ub85c \ube7c\uc8fc\uc5c8\ub2e4. <del>8.0.18 \ubc84\uc804 \uae30\uc900, 56\ub77c\uc778\uc5d0 \uc788\ub2e4.<\/del><\/p>\n<h4>AS-IS<\/h4>\n<pre><code class=\"language-c\">#if 0 \/* TODO: do we need this *\/\n#ifdef HAVE_TERMCAP_H\n#include &lt;termcap.h&gt;\n#endif<\/code><\/pre>\n<h4>TO-BE<\/h4>\n<pre><code class=\"language-c\">#include &lt;termcap.h&gt;\n#if 0 \/* TODO: do we need this *\/\n#ifdef HAVE_TERMCAP_H\n#include &lt;termcap.h&gt;\n#endif<\/code><\/pre>\n<h3>\ube4c\ub4dc<\/h3>\n<p>\uc5ec\uae30\uae4c\uc9c0 \uc644\ub8cc\ub418\uc5c8\uc73c\uba74 \uc774\uc81c \ubcf8\uaca9\uc801\uc73c\ub85c \ube4c\ub4dc\ub97c \uc9c4\ud589\ud560 \uc218 \uc788\ub2e4. \ub2e4\uc2dc \ub2e4\uc6b4\ubc1b\uc740 \uc18c\uc2a4\ucf54\ub4dc \uacbd\ub85c\ub85c \uc774\ub3d9\ud55c \ub4a4 build \ub514\ub809\ud1a0\ub9ac\ub97c \ub9cc\ub4e4\uace0 \uc791\uc5c5\uc744 \uc9c4\ud589\ud55c\ub2e4.<\/p>\n<pre><code class=\"language-bash\">cd .\/mysql-8.0.18\nmkdir build &amp;&amp; cd build\ncmake ..\/ \\\n-DCMAKE_INSTALL_PREFIX=\/app\/serv\/mysql\/8.0.18 \\\n-DMYSQL_DATADIR=\/app\/data\/mysql \\\n-DSYSCONFDIR=\/etc \\\n-DWITH_MYISAM_STORAGE_ENGINE=1 \\\n-DWITH_INNOBASE_STORAGE_ENGINE=1 \\\n-DWITH_FEDERATED_STORAGE_ENGINE=1 \\\n-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \\\n-DMYSQL_UNIX_ADDR=\/tmp\/mysql.sock \\\n-DENABLED_LOCAL_INFILE=1 \\\n-DENABLE_DOWNLOADS=1 \\\n-DWITH_EXTRA_CHARSETS=all \\\n-DDEFAULT_CHARSET=utf8 \\\n-DDEFAULT_COLLATION=utf8_general_ci \\\n-DWITH_DEBUG=0 \\\n-DMYSQL_MAINTAINER_MODE=0 \\\n-DDOWNLOAD_BOOST=1 \\\n-DWITH_BOOST=..\/boost<\/code><\/pre>\n<p>\ub2e4\uc74c\uacfc \uac19\uc774 \ube4c\ub4dc \ud30c\uc77c\uc774 \ub2e4 \uc0dd\uc131\ub418\uc5c8\uc73c\uba74 <\/p>\n<pre><code class=\"language-txt\">...\n-- CMAKE_EXE_LINKER_FLAGS \n-- CMAKE_MODULE_LINKER_FLAGS \n-- CMAKE_SHARED_LINKER_FLAGS \n-- Configuring done\n-- Generating done\n-- Build files have been written to: \/app\/src\/for-blog\/mysql-8.0.18\/build<\/code><\/pre>\n<p><code>make install<\/code> \uba85\ub839\uc73c\ub85c \ub9c8\ubb34\ub9ac \uc791\uc5c5\uc5d0 \ub4e4\uc5b4\uac00\uba74 \ub418\ub294\ub370 <code>-j<\/code> \uc635\uc158\uc73c\ub85c job \uac1c\uc218\ub97c \ub298\ub824\uc11c \ud558\uba74 \uc880 \ub354 \ube68\ub9ac \ub05d\ub0bc \uc218 \uc788\ub2e4.<\/p>\n<pre><code class=\"language-bash\">make install -j 4<\/code><\/pre>\n<p>\ub300\uc2e0<del>, \ubb34\uc2a8 \uc774\uc720\uc5d0\uc120\uc9c0\ub294 \ubaa8\ub974\uaca0\uc9c0\ub9cc,<\/del> \uc4f0\ub808\ub4dc \uc218\ub97c \ub298\ub9ac\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \ub3c4\uc911\uc5d0 \ube4c\ub4dc \uc2e4\ud328\ud558\ub294 \uacbd\uc6b0\uac00 \uc885\uc885 \uc788\ub294\ub370<\/p>\n<pre><code class=\"language-bash\">[ 87%] Built target sql_main\n[ 87%] Building CXX object sql\/CMakeFiles\/sql_gis.dir\/gis\/difference.cc.o\n[ 87%] Building CXX object sql\/CMakeFiles\/sql_gis.dir\/gis\/distance_sphere.cc.o\n[ 87%] Building CXX object sql\/CMakeFiles\/sql_gis.dir\/gis\/equals.cc.o\n[ 87%] Building CXX object sql\/CMakeFiles\/sql_gis.dir\/gis\/gc_utils.cc.o\n[ 87%] Building CXX object sql\/CMakeFiles\/sql_gis.dir\/gis\/geometries.cc.o\n[ 87%] Building CXX object sql\/CMakeFiles\/sql_gis.dir\/gis\/intersects.cc.o\n[ 87%] Building CXX object sql\/CMakeFiles\/sql_gis.dir\/gis\/is_simple.cc.o\nc++: internal compiler error: Killed (program cc1plus)\nPlease submit a full bug report,\nwith preprocessed source if appropriate.\nSee &lt;file:\/\/\/usr\/share\/doc\/gcc-7\/README.Bugs&gt; for instructions.\nsql\/CMakeFiles\/sql_gis.dir\/build.make:158: recipe for target &#039;sql\/CMakeFiles\/sql_gis.dir\/gis\/difference.cc.o&#039; failed\nmake[2]: *** [sql\/CMakeFiles\/sql_gis.dir\/gis\/difference.cc.o] Error 4\nmake[2]: *** Waiting for unfinished jobs....\nCMakeFiles\/Makefile2:23637: recipe for target &#039;sql\/CMakeFiles\/sql_gis.dir\/all&#039; failed\nmake[1]: *** [sql\/CMakeFiles\/sql_gis.dir\/all] Error 2\nMakefile:162: recipe for target &#039;all&#039; failed\nmake: *** [all] Error 2<\/code><\/pre>\n<p>job \uc218\ub97c \ud55c \uac1c\ub85c \ub0ae\ucdb0\uc11c, \uc774 \ub9c9\ud614\ub358 \ubd80\ubd84\uc744 \ud1b5\uacfc\ud560\ub54c \uae4c\uc9c0\ub9cc \uc9c4\ud589\ud558\uace0 \ud0ac \ud55c \ub4a4 \ub2e4\uc2dc <code>-j 4<\/code> \uc635\uc158\uc73c\ub85c \uc774\uc5b4\uc11c \uc9c4\ud589\ud558\ub294 \uacfc\uc815\uc744 \ubc18\ubcf5\ud558\uba74 \ube60\ub974\uac8c \ube4c\ub4dc\ud560 \uc218 \uc788\ub2e4.<\/p>\n<p>\uc911\uac04\uc911\uac04 \ud655\uc778\ud558\uae30 \ubc88\uac70\ub86d\uace0 \uc2dc\uac04\uc774 \ub9ce\ub2e4\uba74 \uadf8\ub0e5 \ub9d8 \ud3b8\ud788 <code>-j<\/code> \uc635\uc158 \uc5c6\uc774 \ub3cc\ub824\ub193\uc73c\uba74 \ub41c\ub2e4. \uc790\uae30 \uc9c1\uc804\uc5d0 \uac78\uc5b4\ub193\uace0 \uc790\uace0 \uc77c\uc5b4\ub098\uba74 \ub418\ub294 \uac83 \uac19\ub2e4.<\/p>\n<pre><code class=\"language-bash\">make install<\/code><\/pre>\n<p>\ubc14\uc774\ub108\ub9ac \ube4c\ub4dc\uac00 \ub05d\ub0ac\uc73c\uba74 \ub2e4\ub978 \uac83\ub4e4\uacfc \ub9c8\ucc2c\uac00\uc9c0\ub85c \uc2ec\ubcfc\ub9ad \ub9c1\ud06c\ub97c \uc0dd\uc131\ud574\uc8fc\uace0<\/p>\n<pre><code class=\"language-bash\">cd \/app\/serv\/mysql &amp;&amp; ln -s .\/8.0.18\/* .<\/code><\/pre>\n<p>\uc9c0\uae08\uae4c\uc9c0 \uc124\uce58\ud55c \uc18c\ud504\ud2b8\uc6e8\uc5b4\ub4e4\uc758 \uc18c\uc720\uad8c\ud55c\uc744 root\uc5d0\uc11c \ubcc0\uacbd\ud558\uace0<\/p>\n<pre><code class=\"language-bash\">chown -R ubuntu:ubuntu \/app\nsu - ubuntu\nvim ~\/.profile<\/code><\/pre>\n<p>APM \ubc14\uc774\ub108\ub9ac\uc640 \ub77c\uc774\ube0c\ub7ec\ub9ac \uacbd\ub85c\ub97c \ud658\uacbd\ubcc0\uc218\uc5d0 \ucd94\uac00\ud574\uc8fc\uba74 \uc124\uce58 \ub05d.<\/p>\n<pre><code class=\"language-bash\">PATH=\\\n\/app\/serv\/httpd\/bin:\\\n\/app\/serv\/mysql\/bin:\\\n\/app\/util\/php\/bin:\\\n$PATH\nexport PATH\nLD_LIBRARY_PATH=\\\n\/app\/serv\/httpd\/lib:\\\n\/app\/serv\/mysql\/lib:\\\n\/app\/util\/php\/lib:\\\n$LD_LIBRARY_PATH\nexport LD_LIBRARY_PATH<\/code><\/pre>\n<h2>mysql \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131<\/h2>\n<p>APM \uc124\uce58\ub294 \uc704 \ub2e8\uacc4\uae4c\uc9c0\uac00 \ub05d\uc774\uace0 \uc774\uc81c \uc11c\ube44\uc2a4\ub97c \uc704\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud55c\ub2e4. ubuntu \uacc4\uc815\uc5d0\uc11c <code>vim \/tmp\/my.cnf<\/code> \ud30c\uc77c\uc744 \uc5f4\uc5b4 \ub2e4\uc74c\uacfc \uac19\uc774 \uc801\uc5b4\uc8fc\uace0<\/p>\n<pre><code class=\"language-txt\">[mysqld]\nuser = ubuntu\nport = 3306\nbasedir=\/app\/serv\/mysql\ndatadir=\/app\/data\/mysql\nsocket=\/tmp\/mysql.sock\ninnodb_data_file_path=ibdata1:12M:autoextend\ninnodb_log_files_in_group=3\ninnodb_log_file_size=64M\ninnodb_buffer_pool_size=1024M\ninnodb_io_capacity=4000\ncollation-server = utf8_unicode_ci\ninit-connect = &quot;SET NAMES utf8&quot;\ncharacter-set-server = utf8\n\n[mysqld_safe]\nlog-error=\/app\/logs\/mysql\/mysqld.log\n\n[client]\ndefault-character-set = utf8\n\n[mysql]\ndefault-character-set = utf8<\/code><\/pre>\n<p><code>mysqld --initialize<\/code> \uba85\ub839\uc744 \uc218\ud589\ud558\uba74<\/p>\n<pre><code class=\"language-txt\">2020-03-12T16:26:49.872195Z 0 [System] [MY-013169] [Server] \/app\/serv\/mysql\/8.0.18\/bin\/mysqld (mysqld 8.0.18) initializing of server in progress as process 10158\n2020-03-12T16:26:55.382392Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: A,-Yi-a9rz!h<\/code><\/pre>\n<p>\uc704\uc640 \uac19\uc774 \uae30\ubcf8 \uc2dc\uc2a4\ud15c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc0dd\uc131\ub418\uace0 \ucd08\uae30 \ub85c\uadf8\uc778\uc744 \uc704\ud55c \uc784\uc2dc \ube44\ubc00\ubc88\ud638\ub97c \uc54c\ub824\uc8fc\ub294\ub370<\/p>\n<p><code>mysqld_safe --user=ubuntu &amp;<\/code> \uba85\ub839\uc73c\ub85c \uc11c\ubc84\ub97c \uc2e4\ud589\ud558\uace0<\/p>\n<p><code>mysql -u root -p&quot;A,-Yi-a9rz!h&quot;<\/code> \uc774\ub807\uac8c \uc784\uc2dc \ube44\ubc00\ubc88\ud638\ub85c \ub85c\uadf8\uc778\ud55c \ub4a4 \ub2e4\uc74c SQL\ub85c \ube44\ubc00\ubc88\ud638\ub97c \ubc14\uafd4\uc8fc\uba74 \uc774\ud6c4 \uc815\uc0c1\uc801\uc73c\ub85c DB \ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n<pre><code class=\"language-sql\">ALTER USER &#039;root&#039;@&#039;localhost&#039; IDENTIFIED BY &#039;MyNewPassword&#039;;<\/code><\/pre>\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc774\ud6c4 WordPress\uc640 Nextcloud \uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub3c4\ub85d \ud558\ub098 \uc815\ub3c4\ub294 \ubcc4\ub3c4\ub85c \uc0dd\uc131\ud574\ub450\uc5b4\uc57c \ud558\ub294\ub370, \uc0ac\uc6a9\uc790\ub294 \uc120\ud0dd\uc0ac\ud56d\uc774\uc9c0\ub9cc \ud544\uc694\uc5d0 \ub530\ub77c \ucd94\uac00\ud574\uc11c \uc0ac\uc6a9\ud574\ub3c4 \ub41c\ub2e4.<\/p>\n<pre><code class=\"language-sql\">CREATE USER &#039;newusername&#039;@&#039;localhost&#039; IDENTIFIED BY &#039;MyNewPassword&#039;;\nCREATE DATABASE new_db;\nGRANT ALL PRIVILEGES ON new_db.* TO &#039;newusername&#039;@&#039;localhost&#039;;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\uc131\uacf5\ud55c \ucf00\uc774\uc2a4\ub97c \uadf8\ub300\ub85c \uc801\uc73c\uba74 \uc9e7\uc740 \ub0b4\uc6a9\uc774\uc9c0\ub9cc \ud639\uc2dc\ub098 \ub098\uc911\uc5d0 \ub2e4\uc2dc \uc4f8\ubaa8\uac00 \uc788\uc744\uc9c0\ub3c4 \ubaa8\ub974\ub294 \uc0bd\uc9c8 \uacfc\uc815\uc744 \uae30\ub85d\ud558\uae30 \uc704\ud574\uc11c mysql \uc124\uce58 \uacfc\uc815\ub9cc \ubcc4\ub3c4\ub85c \uc815\ub9ac\ud55c\ub2e4. cannot execute binary file: Exec format error \uc77c\ub2e8, \uae30\uc874\uc5d0 x86 \ud658\uacbd\uc5d0\uc11c \uc815\ub9ac\ud574\ub193\uc740 \uc2a4\ud06c\ub9bd\ud2b8\ub85c mysql \ubc14\uc774\ub108\ub9ac\ub97c \uadf8\ub0e5 \ub2e4\uc6b4 \ubc1b\uc544 \uc2e4\ud589\ud588\ub294\ub370 \uc704 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud574\uc11c \uc7a0\uae50 \ub3d9\uc548 \uace0\ubbfc\uc5d0 \ube60\uc84c\uc5c8\ub2e4. \uba87\ubc88\uc774\uace0 \uadf8\ub0e5 \uc2e4\ud589\ud574\ubcf4\ub2e4\uac00 \ubcf4\ub2c8 \ubc14\uc774\ub108\ub9ac(mysql-8.0.18-linux-glibc2.12-x86_64.tar.xz)\uc5d0 x86_64 \ub77c\uace0 \uc801\ud78c\uac8c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[62,174],"tags":[190,110,175,188,176,191,177],"class_list":["post-1514","post","type-post","status-publish","format-standard","hentry","category-mysql","category-raspberrypi","tag-apm-stack","tag-mysql","tag-raspberrypi","tag-ubuntu-pi","tag-176","tag-191","tag-177"],"_links":{"self":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1514","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/comments?post=1514"}],"version-history":[{"count":0,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1514\/revisions"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=1514"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=1514"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=1514"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}