{"id":3339,"date":"2022-11-27T20:50:03","date_gmt":"2022-11-27T11:50:03","guid":{"rendered":"https:\/\/mightyfriend.net\/?p=3339"},"modified":"2023-06-17T22:05:42","modified_gmt":"2023-06-17T13:05:42","slug":"phpmyadmin-installation","status":"publish","type":"post","link":"https:\/\/mightyfriend.net\/?p=3339","title":{"rendered":"phpmyadmin \uc124\uce58 \ubc0f \uc624\ub958 \ud574\uacb0"},"content":{"rendered":"<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \ub3c4\uad6c\uc778 phpmyadmin \uc124\uce58\ud558\ub294 \ubc29\ubc95\uacfc \uac01\uc885 \uc624\ub958\ub97c \ud574\uacb0\ud558\ub294 \ubc29\ubc95\uc744 \uc815\ub9ac\ud558\uc600\uc2b5\ub2c8\ub2e4. <span style=\"font-size: 1rem;\">\uc624\ub958 \ud574\uacb0\uc744 \uc8fc\ub85c \ub2e4\ub8e8\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">List of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\ubaa9\ucc28 \ud1a0\uae00\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/mightyfriend.net\/?p=3339\/#1_%EC%84%A4%EC%B9%98_%EC%A0%84_%EC%A4%80%EB%B9%84%EC%82%AC%ED%95%AD\" >1. \uc124\uce58 \uc804 \uc900\ube44\uc0ac\ud56d<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/mightyfriend.net\/?p=3339\/#2-1_%EC%84%A4%EC%B9%98\" >2-1. \uc124\uce58<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/mightyfriend.net\/?p=3339\/#2-2_Error_1045_%ED%95%B4%EA%B2%B0_%EB%B0%A9%EB%B2%95\" >2-2. Error 1045 \ud574\uacb0 \ubc29\ubc95<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/mightyfriend.net\/?p=3339\/#2-3_phpmyadmin_%EC%9D%84_%EC%82%AD%EC%A0%9C%ED%95%98%EA%B3%A0_%EC%8B%B6%EC%9D%84_%EB%95%8C\" >2-3. phpmyadmin \uc744 \uc0ad\uc81c\ud558\uace0 \uc2f6\uc744 \ub54c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/mightyfriend.net\/?p=3339\/#3_phpmyadmin_%EC%84%A4%EC%B9%98%EB%8A%94_%EC%9E%98_%EB%90%98%EC%97%88%EC%9C%BC%EB%82%98_http_error_500_%EB%B0%9C%EC%83%9D%ED%95%98%EB%8A%94_%EA%B2%BD%EC%9A%B0\" >3. phpmyadmin \uc124\uce58\ub294 \uc798 \ub418\uc5c8\uc73c\ub098, http error 500 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/mightyfriend.net\/?p=3339\/#4-1_phpmyadmin_%EC%88%98%EB%8F%99%EC%84%A4%EC%B9%98\" >4-1. phpmyadmin \uc218\ub3d9\uc124\uce58<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/mightyfriend.net\/?p=3339\/#4-2_phpmyadmin_%EB%A1%9C%EA%B7%B8%EC%9D%B8_%ED%9B%84_%EA%B2%BD%EA%B3%A0_%ED%91%9C%EC%8B%9C_%ED%95%B4%EA%B2%B0\" >4-2. phpmyadmin \ub85c\uadf8\uc778 \ud6c4 \uacbd\uace0 \ud45c\uc2dc \ud574\uacb0<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_%EC%84%A4%EC%B9%98_%EC%A0%84_%EC%A4%80%EB%B9%84%EC%82%AC%ED%95%AD\"><\/span>1. \uc124\uce58 \uc804 \uc900\ube44\uc0ac\ud56d<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\uc11c\ubc84\uc5d0 apache, php, mariadb \uac00 \uc124\uce58\ub418\uc5b4 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uc774\ubbf8 \uc11c\ubc84\uac00 \uad6c\ub3d9 \uc911\uc774\uace0 mariadb \ub8e8\ud2b8 \uc554\ud638\uac00 \uac78\ub824 \uc788\ub2e4\uba74 \uc911\uac04\uc5d0 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud560 \uac00\ub2a5\uc131\uc774 \uc788\uc2b5\ub2c8\ub2e4. \ubc11\uc5d0\uc11c \ucd94\uac00 \uc815\ub9ac\ud558\uc600\uc2b5\ub2c8\ub2e4.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2-1_%EC%84%A4%EC%B9%98\"><\/span>2-1. \uc124\uce58<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\ub2e4\uc74c\uacfc \uac19\uc774 \uc785\ub825\ud569\ub2c8\ub2e4.<\/p>\n<pre>[pi@localhost ~]# sudo apt-get install phpmyadmin<\/pre>\n<p>phpmyadmin \uc554\ud638\ub97c \uc124\uc815\ud558\uace0 \ub098\uc11c \ubb38\uc81c\uc5c6\uc774 \uc124\uce58\ub418\uc5c8\ub2e4\uba74 \ud648\ud398\uc774\uc9c0 \uc8fc\uc18c\/phpmyadmin \uc73c\ub85c \uc811\uc18d\ud558\uba74 \ub429\ub2c8\ub2e4. \ubb38\uc81c\uc5c6\uc774 \uc798 \ub3d9\uc791\ud55c\ub2e4\uba74 \uc544\ub798 \uae00\uc740 \ub354 \uc548 \ubcf4\uc154\ub3c4 \ub429\ub2c8\ub2e4.<\/p>\n<p>\uadf8\ub7f0\ub370 \ub9cc\uc57d \uc124\uce58 \uc911\uac04\uc5d0 \uc544\ub798\uc640 \uac19\uc740 \ud654\uba74\uc744 \ubd24\ub2e4\uba74 \uc124\uce58\ub97c \uc911\ub2e8(abort) \ud574\uc57c \ub429\ub2c8\ub2e4.<\/p>\n<div id=\"attachment_3342\" style=\"width: 727px\" class=\"wp-caption alignnone\"><img aria-describedby=\"caption-attachment-3342\" loading=\"lazy\" class=\"wp-image-3342 size-full\" src=\"https:\/\/mightyfriend.net\/wp-content\/uploads\/2022\/11\/phpmyadmin_error.png\" alt=\"\" width=\"717\" height=\"421\" srcset=\"https:\/\/mightyfriend.net\/wp-content\/uploads\/2022\/11\/phpmyadmin_error.png 717w, https:\/\/mightyfriend.net\/wp-content\/uploads\/2022\/11\/phpmyadmin_error-300x176.png 300w, https:\/\/mightyfriend.net\/wp-content\/uploads\/2022\/11\/phpmyadmin_error-624x366.png 624w\" sizes=\"(max-width: 717px) 100vw, 717px\" \/><p id=\"caption-attachment-3342\" class=\"wp-caption-text\">mariadb error 1045<\/p><\/div>\n<p>\ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\ub294 \uc6d0\uc778\uc740 mariadb \uc5d0 \uc811\uc18d\ud558\uc5ec phpmyadmin \uc774\ub77c\ub294 database\ub97c \uc0dd\uc131\ud574\uc57c \ud558\ub294\ub370 mariadb\uc5d0 \uc554\ud638\uac00 \uc124\uc815\ub418\uc5b4 \uc788\uc5b4\uc11c \uc811\uc18d\uc744 \ubabb\ud574\uc11c \uc0dd\uae30\ub294 \uc624\ub958 \uc785\ub2c8\ub2e4. \uadf8\ub7fc \ubc14\ub85c \uc804\uc5d0 \uc785\ub825\ud55c \uc554\ud638\ub294 \ubb54\uac00\uc694? \uadf8\uac74 phpmyadmin \uc774\ub77c\ub294 database \ub97c \ub9cc\ub4e4\uace0 \uac70\uae30\uc5d0 \uc124\uc815\ud558\ub294 \uc554\ud638\uc778\ub370 \uadf8 \uc55e\ub2e8\uc5d0\uc11c mariadb \uc811\uc18d \uc790\uccb4\ub97c \uc2e4\ud328\ud55c \uac83\uc785\ub2c8\ub2e4.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2-2_Error_1045_%ED%95%B4%EA%B2%B0_%EB%B0%A9%EB%B2%95\"><\/span>2-2. Error 1045 \ud574\uacb0 \ubc29\ubc95<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>phpMyAdmin installation &#8211; ERROR 1045: Access denied (using: password: NO)\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc784\uc2dc\ub85c mariadb \uc758 \uc554\ud638\ub97c \uc0ad\uc81c\ud558\uace0 phpmyadmin \uc744 \uc124\uce58\ud569\ub2c8\ub2e4. \uc0ad\uc81c\uac00 \uc548\ub418\ub294 \uc624\ub958\uac00 \ubc1c\uc0dd\ud560 \ub54c\ub3c4 \ub3d9\uc77c\ud55c \uc774\uc720\uc785\ub2c8\ub2e4. \uadf8\ub7ec\uae30 \uc704\ud574 mariadb \uc5d0 \uc811\uc18d\ud569\ub2c8\ub2e4.<\/p>\n<pre>[pi@localhost ~]# sudo mysql -uroot -p\r\n\uc554\ud638\uc785\ub825: *********\r\n\r\n\/* \ud604\uc7ac \uc124\uc815\ub418\uc5b4 \uc788\ub294 MariaDB root \uc554\ud638\ub97c \uc81c\uac70\ud558\ub294 \uba85\ub839\uc5b4 \uc785\ub2c8\ub2e4. *\/\r\nMariaDB [(none)] SET PASSWORD FOR root@localhost=PASSWORD('');\r\nMariaDB [(none)] 'Ctrl+D' \ub97c \ub20c\ub7ec\uc11c \ube60\uc838\ub098\uc628\ub2e4.<\/pre>\n<p>\uc774\uc81c phpmyadmin \uc124\uce58\ub97c \uc7ac\uc2dc\ub3c4 \ud569\ub2c8\ub2e4.<\/p>\n<pre>[pi@localhost ~]# sudo apt-get install phpmyadmin<\/pre>\n<p>\uc124\uce58\uac00 \uc644\ub8cc\ub418\uba74 mariadb \uc554\ud638\ub97c \uc6d0\ub798\ub300\ub85c \uc124\uc815\ud574 \uc90d\ub2c8\ub2e4. *\uae30\uc874\uc5d0 mariadb \uc811\uc18d\ud588\ub358 root \uc554\ud638\uc640 \ub3d9\uc77c\ud558\uac8c \uc124\uc815\ud574 \uc904 \uac81\ub2c8\ub2e4.<\/p>\n<pre>[pi@localhost ~]# sudo mysql_secure_installation\r\n\uc554\ud638\uc785\ub825: (\uc554\ud638\ub97c \uc9c0\uc6e0\uc73c\ubbc0\ub85c \uadf8\ub0e5 Enter \ub97c \ub204\ub985\ub2c8\ub2e4.)\r\n\r\nSet root password? Y\r\nNew password: (\uae30\uc874\uc5d0 \uc785\ub825\ud588\ub358 \uc554\ud638\uc640 \ub3d9\uc77c\ud558\uac8c \uc785\ub825)\r\n\r\n...\uc774\ud6c4 \ub098\uba38\uc9c0 4\uac1c \uc9c8\ubb38 Y \uc785\ub825 \ud6c4 \uc885\ub8cc\r\nAll done! Thanks for using MariaDB!\r\n\r\n[pi@localhost ~]# sudo reboot<\/pre>\n<h3><span class=\"ez-toc-section\" id=\"2-3_phpmyadmin_%EC%9D%84_%EC%82%AD%EC%A0%9C%ED%95%98%EA%B3%A0_%EC%8B%B6%EC%9D%84_%EB%95%8C\"><\/span>2-3. phpmyadmin \uc744 \uc0ad\uc81c\ud558\uace0 \uc2f6\uc744 \ub54c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\uc124\uce58\ub3c4\uc911 \ubb54\uac00 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud558\uace0 \ub9ce\uc774 \uaf2c\uc5ec\uc11c \uc9c0\uc6b0\uace0 \ub2e4\uc2dc \uc124\uce58\ud558\ub294 \uacbd\uc6b0\uc5d0\ub3c4 \ub3d9\uc77c\ud55c \uc774\uc720\ub85c \uc0ad\uc81c\uac00 \uc548\ub418\ub294 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4. \ub3d9\uc77c\ud558\uac8c mariadb\uc5d0 \uc554\ud638\uac00 \uc124\uc815\ub418\uc5b4 \uc788\uc5b4\uc11c \uc811\uc18d\uc744 \ubabb\ud574\uc11c \uc0dd\uae30\ub294 \uc624\ub958\uc785\ub2c8\ub2e4. \uc704\uc5d0 \ubc29\ubc95\uacfc \uac19\uc740 \ubc29\ubc95\uc73c\ub85c mariadb \uc758 \uc554\ud638\ub97c \uc0ad\uc81c\ud569\ub2c8\ub2e4.<\/p>\n<pre>[pi@localhost ~]# sudo mysql -uroot -p\r\n\uc554\ud638\uc785\ub825: *********\r\n\r\nMariaDB [(none)] SET PASSWORD FOR root@localhost=PASSWORD('');\r\nMariaDB [(none)] 'Ctrl+D' \ub97c \ub20c\ub7ec\uc11c \ube60\uc838\ub098\uc628\ub2e4.<\/pre>\n<p>\uc774\uc81c phpmyadmin \uc744 \uc0ad\uc81c \ud569\ub2c8\ub2e4.<\/p>\n<pre>[pi@localhost ~]# sudo apt-get purge phpmyadmin\r\n[pi@localhost ~]# sudo apt autoremove<\/pre>\n<h3><span class=\"ez-toc-section\" id=\"3_phpmyadmin_%EC%84%A4%EC%B9%98%EB%8A%94_%EC%9E%98_%EB%90%98%EC%97%88%EC%9C%BC%EB%82%98_http_error_500_%EB%B0%9C%EC%83%9D%ED%95%98%EB%8A%94_%EA%B2%BD%EC%9A%B0\"><\/span>3. phpmyadmin \uc124\uce58\ub294 \uc798 \ub418\uc5c8\uc73c\ub098, http error 500 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\ube0c\ub77c\uc6b0\uc800\uc5d0\uc11c phpmyadmin \uc811\uc18d\uc744 \ud558\uc600\uc73c\ub098 Internal server error (HTTP Error 500) \uac00 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4. apache \ub85c\uadf8\ud30c\uc77c\uc744 \uc870\ud68c\ud574 \ubd05\ub2c8\ub2e4.<\/p>\n<pre>[pi@localhost ~]# sudo tail -f \/var\/log\/apache2\/error.log\r\n...(\uc911\ub7b5)\r\nPHP Fatal error: Array and string offset access syntax with curly braces is no longer\r\nsupported in \/usr\/share\/phpmyadmin\/libraries\/url_generating.lib.php<\/pre>\n<p>\uc704\uc640 \uac19\uc740 \uc624\ub958\uac00 \ubc1c\uc0dd\ud558\uc600\ub294\ub370 \ud574\uacb0\uc774 \uc27d\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc218\ub9ce\uc740 \uac80\uc0c9 \uacb0\uacfc \ub0b4\ub9b0 \uacb0\ub860\uc740 php8.0 \uc774\uc0c1 \ubc84\uc804\uc5d0\uc11c php \uc640 phpmyadmin \ubc84\uc804 \ud638\ud658\uc131 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\uc5ec \ubc1c\uc0dd\ud558\ub294 \uc624\ub958\ub85c \uc774\ud574\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774\ub7ec\ud55c \uacbd\uc6b0 \uc9c0\uae08\uae4c\uc9c0 \uc5f4\uc2ec\ud788 \uc124\uce58\ud55c \ubaa8\ub4e0 phpmyadmin \uc744 \uc0ad\uc81c\ud558\uace0 \uc218\ub3d9\uc73c\ub85c phpmyadmin \uc744 \uc124\uce58\ud569\ub2c8\ub2e4. \uc0ad\uc81c\ub97c \uc704\ud574 2-3 \uae00\uc744 \ub530\ub77c \uc0ad\uc81c \uc808\ucc28\ub97c \uc9c4\ud589\ud569\ub2c8\ub2e4.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4-1_phpmyadmin_%EC%88%98%EB%8F%99%EC%84%A4%EC%B9%98\"><\/span>4-1. phpmyadmin \uc218\ub3d9\uc124\uce58<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\ucd5c\uc2e0 \ubc84\uc804\uc758 phpmyadmin \uc744 \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc2b5\ub2c8\ub2e4.<\/p>\n<p><a href=\"https:\/\/phpmyadmin.net\" target=\"_blank\" rel=\"noopener\">https:\/\/phpmyadmin.net<\/a><\/p>\n<p>\uc624\ub978\ucabd \uc0c1\ub2e8\uc5d0 \ub2e4\uc6b4\ub85c\ub4dc\ud558\uace0 \uc11c\ubc84\ub85c \uc5c5\ub85c\ub4dc \ud6c4\uc5d0 \uc555\ucd95\uc744 \ud489\ub2c8\ub2e4. \uc555\ucd95\uc744 \ud480\uace0 \ud3f4\ub354\uc758 \uc704\uce58\ub294 \ucd5c\uc885\uc801\uc73c\ub85c \/usr\/share \uc5d0 \uc62e\uaca8 \ub193\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774\uc81c \ud3f4\ub354\uba85\uc744 phpmyadmin \uc73c\ub85c \ubcc0\uacbd \ud558\uace0 \uc2ec\ubcfc\ub9ad \ub9c1\ud06c\ub85c \uc5f0\uacb0\ud569\ub2c8\ub2e4.<\/p>\n<pre>[pi@localhost ~]# sudo mv phpMyAdmin-5.2.0-all-languages phpmyadmin\r\n[pi@localhost ~]# sudo ln -s \/usr\/share\/phpmyadmin \/var\/www\/html\/phpmyadmin\r\n[pi@localhost ~]# sudo service apache2 restart<\/pre>\n<p>\uc774\uc81c phpmyadmin \uc5d0 \uc811\uc18d\ud558\uba74 \uc815\uc0c1\uc801\uc73c\ub85c \uc811\uc18d\uc774 \ub420 \uac81\ub2c8\ub2e4.<\/p>\n<p>\uc124\uce58\uac00 \uc644\ub8cc\ub418\uba74 mariadb \uc554\ud638\ub97c \uc6d0\ub798\ub300\ub85c \uc124\uc815\ud574 \uc90d\ub2c8\ub2e4. *\uae30\uc874\uc5d0 mariadb \uc811\uc18d\ud588\ub358 root \uc554\ud638\uc640 \ub3d9\uc77c\ud558\uac8c \uc124\uc815\ud574 \uc904 \uac81\ub2c8\ub2e4. \uc704\uc758 2-2\uc758 \ub0b4\uc6a9\uacfc \ub3d9\uc77c\ud55c \ub0b4\uc6a9\uc785\ub2c8\ub2e4.<\/p>\n<pre>[pi@localhost ~]# sudo mysql_secure_installation\r\n\uc554\ud638\uc785\ub825: (\uc554\ud638\ub97c \uc9c0\uc6e0\uc73c\ubbc0\ub85c \uadf8\ub0e5 Enter \ub97c \ub204\ub985\ub2c8\ub2e4.)\r\n\r\nSet root password? Y\r\nNew password: (\uae30\uc874\uc5d0 \uc785\ub825\ud588\ub358 \uc554\ud638\uc640 \ub3d9\uc77c\ud558\uac8c \uc785\ub825)\r\n\r\n...\uc774\ud6c4 \ub098\uba38\uc9c0 4\uac1c \uc9c8\ubb38 Y \uc785\ub825 \ud6c4 \uc885\ub8cc\r\nAll done! Thanks for using MariaDB!\r\n\r\n[pi@localhost ~]# sudo reboot<\/pre>\n<h3><span class=\"ez-toc-section\" id=\"4-2_phpmyadmin_%EB%A1%9C%EA%B7%B8%EC%9D%B8_%ED%9B%84_%EA%B2%BD%EA%B3%A0_%ED%91%9C%EC%8B%9C_%ED%95%B4%EA%B2%B0\"><\/span>4-2. phpmyadmin \ub85c\uadf8\uc778 \ud6c4 \uacbd\uace0 \ud45c\uc2dc \ud574\uacb0<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>phpmyadmin \uc5d0 \uc811\uc18d\ud558\uba74 phpmyadmin \uc774\ub77c\ub294 database \uc0dd\uc131\uc774 \ud544\uc694\ud558\ub2e4\uace0 \ud569\ub2c8\ub2e4. \ud558\ub2e8\uc5d0 \ub728\ub294 \uacbd\uace0\ub97c \ub530\ub77c \ub20c\ub7ec\uc8fc\uba74 phpmyadmin database\ub294 \uae08\ubc29 \uc0dd\uc131\ub429\ub2c8\ub2e4.<\/p>\n<p>\uc774\uc81c \uccab \ubc88\uc9f8 \uacbd\uace0 \ud45c\uc2dc\ub85c<\/p>\n<p>The $cfg[&#8216;TempDir&#8217;] (\/usr\/share\/phpmyadmin\/tmp\/) is not accessible. phpMyAdmin is not able to cache templates and will be slow because of this.<\/p>\n<p>\ub97c \ud574\uacb0\ud569\ub2c8\ub2e4. \ube44\uad50\uc801 \uac04\ub2e8\ud55c \uac83\uc73c\ub85c \/usr\/share\/phpmyadmin\/tmp \ud3f4\ub354\ub97c \ub9cc\ub4e4\uace0 \uad8c\ud55c\uc744 \uc8fc\uba74 \ub429\ub2c8\ub2e4.<\/p>\n<pre>[pi@localhost ~]# cd \/usr\/share\/phpmyadmin\r\n[pi@localhost ~]# mkdir tmp\r\n[pi@localhost ~]# sudo chown -R www-data: tmp\r\n[pi@localhost ~]# sudo service apache2 restart<\/pre>\n<p>\uc774\uc81c \ub450 \ubc88\uc9f8 \uacbd\uace0 \ud45c\uc2dc\ub85c<\/p>\n<p>The configuration file now needs a secret passphrase (blowfish_secret)<\/p>\n<p>\ub97c \ud574\uacb0\ud569\ub2c8\ub2e4. \/usr\/share\/phpmyadmin \ud3f4\ub354\ub85c \uc774\ub3d9\uc5d0\uc11c config.inc.php (\ub610\ub294 config.sample.inc.php) \ub97c \uc5f4\uc5b4\uc11c \ub0b4\uc6a9\uc744 \uc5c5\ub370\uc774\ud2b8\ud558\uba74 \ub429\ub2c8\ub2e4. <span style=\"color: #0000ff;\">\u203b \ub9cc\uc57d \ud30c\uc77c\uba85\uc774 config.sample.inc.php\ub85c \ub418\uc5b4 \uc788\uc73c\uba74 \ud30c\uc77c\uba85\uc744 \uba3c\uc800 \ubc14\uafd4\uc90d\ub2c8\ub2e4.<\/span> \ud0a4\ub97c \uc5c5\ub370\uc774\ud2b8\ud574\uc8fc\uba74 \ub418\ub294\ub370 \uc544\ub798 \ub9c1\ud06c\ub97c \ucc38\uace0\ud558\uba74 \ub429\ub2c8\ub2e4. \ud0a4\ub97c \uc0dd\uc131\ud574 \uc8fc\ub294 \uc0ac\uc774\ud2b8\uc774\uba70 \uc5b4\ub5bb\uac8c \uc5c5\ub370\uc774\ud2b8\ud558\uba74 \ub418\ub294\uc9c0 \ub098\uc640 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p><a href=\"https:\/\/phpsolved.com\/phpmyadmin-blowfish-secret-generator\" target=\"_blank\" rel=\"noopener\">https:\/\/phpsolved.com\/phpmyadmin-blowfish-secret-generator<\/a><\/p>\n<p>You\u2019ll see this error after every installation of phpmyadmin.<br \/>\nTo resolve this issue, just open config.inc.php ( or rename config.sample.inc.php to config.inc.php if you haven\u2019t done so yet ) and change this line<\/p>\n<pre>$cfg['blowfish_secret'] = ''; \/* YOU MUST FILL IN THIS FOR COOKIE AUTH! *\/<\/pre>\n<p>to<\/p>\n<pre>$cfg['blowfish_secret'] = '<span style=\"color: #0000ff;\">9WWjl;jPN5AQsyxV9NY5ndyfC87XwxAt<\/span>';<\/pre>\n<p>* \ucc38\uace0\ub85c \uc704\uc758 \ud30c\ub780\uc0c9 \ub0b4\uc6a9\uc744 \uadf8\ub300\ub85c \ubd99\uc774\ub294 \uac83\uc774 \uc544\ub2c8\ub77c site \uc5d0\uc11c \uc0dd\uc131\ud55c \uac83\uc73c\ub85c \ubd99\uc5ec\uc57c \ud569\ub2c8\ub2e4. \uc704\uc758 \ud0a4\ub294 \uc81c\uac00 \uc784\uc758\uc758 \uc870\ud569\uc744 \uc801\uc5b4\ub193\uc740 \uc810\uc744 \ucc38\uc870\ud558\uc138\uc694. \uc0dd\uc131\ub41c \ud0a4\ub97c \ubd99\uc5ec\ub123\uae30 \ud574\uc8fc\uba74 \ub429\ub2c8\ub2e4.<\/p>\n<p>\ud0a4\ub97c \uc5c5\ub370\uc774\ud2b8 \ud588\uc74c\uc5d0\ub3c4 \uc624\ub958\uac00 \uacc4\uc18d \ub098\uc628\ub2e4\uba74 \ud30c\uc77c\uba85\uc744 \ubcc0\uacbd\ud588\ub294\uc9c0 \ub2e4\uc2dc \ud55c\ubc88 \ud655\uc778\ud574 \ubd05\uc2dc\ub2e4.<\/p>\n<pre>[pi@localhost ~]# sudo mv config.sample.inc.php config.inc.php<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \ub3c4\uad6c\uc778 phpmyadmin \uc124\uce58\ud558\ub294 \ubc29\ubc95\uacfc \uac01\uc885 \uc624\ub958\ub97c \ud574\uacb0\ud558\ub294 \ubc29\ubc95\uc744 \uc815\ub9ac\ud558\uc600\uc2b5\ub2c8\ub2e4. \uc624\ub958 \ud574\uacb0\uc744 \uc8fc\ub85c \ub2e4\ub8e8\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_sitemap_exclude":false,"_sitemap_priority":"","_sitemap_frequency":""},"categories":[3],"tags":[232,233,237,231,234,235,236],"_links":{"self":[{"href":"https:\/\/mightyfriend.net\/index.php?rest_route=\/wp\/v2\/posts\/3339"}],"collection":[{"href":"https:\/\/mightyfriend.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mightyfriend.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mightyfriend.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mightyfriend.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3339"}],"version-history":[{"count":25,"href":"https:\/\/mightyfriend.net\/index.php?rest_route=\/wp\/v2\/posts\/3339\/revisions"}],"predecessor-version":[{"id":4869,"href":"https:\/\/mightyfriend.net\/index.php?rest_route=\/wp\/v2\/posts\/3339\/revisions\/4869"}],"wp:attachment":[{"href":"https:\/\/mightyfriend.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3339"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mightyfriend.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3339"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mightyfriend.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3339"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}