\uc774 \uc2a4\ud06c\ub9bd\ud2b8\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \ubcf4\uc548 \uc124\uc815\uc744 \ub3c4\uc640\uc90d\ub2c8\ub2e4:<\/p>\n
\n- \n
root \uc0ac\uc6a9\uc790\uc758 \ube44\ubc00\ubc88\ud638 \uc124\uc815<\/p>\n<\/li>\n
- \n
\uc775\uba85 \uc0ac\uc6a9\uc790 \uc81c\uac70<\/p>\n<\/li>\n
- \n
root \uc0ac\uc6a9\uc790\uc758 \uc6d0\uaca9 \ub85c\uadf8\uc778 \ube44\ud65c\uc131\ud654<\/p>\n<\/li>\n
- \n
\ud14c\uc2a4\ud2b8 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc81c\uac70<\/p>\n<\/li>\n
- \n
\uad8c\ud55c \ud14c\uc774\ube14 \ub2e4\uc2dc \ub85c\ub4dc<\/p>\n<\/li>\n<\/ol>\n
\uac01 \uc9c8\ubb38\uc5d0 \uc801\uc808\ud788 \ub2f5\ubcc0\ud558\uc5ec \ubcf4\uc548 \uc124\uc815\uc744 \uc644\ub8cc\ud569\ub2c8\ub2e4:<\/p>\n
\n- \n
“Enter current password for root”: \ucd08\uae30 \uc124\uce58 \uc2dc\uc5d0\ub294 \ube44\ubc00\ubc88\ud638\uac00 \uc5c6\uc73c\ubbc0\ub85c Enter \ud0a4\ub97c \ub204\ub985\ub2c8\ub2e4.<\/p>\n<\/li>\n
- \n
“Switch to unix_socket authentication”:\u00a0N<\/code>\u00a0\uc785\ub825 \ud6c4 Enter<\/p>\n<\/li>\n- \n
“Change the root password”:\u00a0Y<\/code>\u00a0\uc785\ub825 \ud6c4 Enter, \uadf8\ub9ac\uace0 \uac15\ub825\ud55c \ube44\ubc00\ubc88\ud638 \uc124\uc815<\/p>\n<\/li>\n- \n
“Remove anonymous users”:\u00a0Y<\/code>\u00a0\uc785\ub825 \ud6c4 Enter<\/p>\n<\/li>\n- \n
“Disallow root login remotely”:\u00a0Y<\/code>\u00a0\uc785\ub825 \ud6c4 Enter<\/p>\n<\/li>\n- \n
“Remove test database”:\u00a0Y<\/code>\u00a0\uc785\ub825 \ud6c4 Enter<\/p>\n<\/li>\n- \n
“Reload privilege tables now”:\u00a0Y<\/code>\u00a0\uc785\ub825 \ud6c4 Enter<\/p>\n<\/li>\n<\/ul>\n<\/h2>\n4. \uc6cc\ub4dc\ud504\ub808\uc2a4\ub97c \uc704\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc0f \uc0ac\uc6a9\uc790 \uc0dd\uc131<\/h2>\n
\uc774\uc81c \uc6cc\ub4dc\ud504\ub808\uc2a4 \uc804\uc6a9 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc0ac\uc6a9\uc790\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4:<\/p>\n
\n
\n
\n
\n
bash<\/span><\/div>\n<\/div>\n<\/div>\n\n
sudo<\/span> mysql -u root -p
\n<\/code><\/div>\n<\/div>\n<\/div>\n<\/div>\nroot \ube44\ubc00\ubc88\ud638\ub97c \uc785\ub825\ud55c \ud6c4, MySQL \uc258\uc5d0\uc11c \ub2e4\uc74c \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud569\ub2c8\ub2e4:<\/p>\n
\n
\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
\n
\n
sql<\/div>\n<\/div>\n
\u00a0CREATE<\/span> DATABASE<\/span> wordpress_db;<\/span>
\n\u00a0CREATE<\/span> USER<\/span> 'wordpress_user'<\/span>@'localhost'<\/span> IDENTIFIED BY<\/span> 'your_strong_password'<\/span>;<\/span>
\n\u00a0GRANT<\/span> ALL<\/span> PRIVILEGES<\/span> ON<\/span> wordpress_db.<\/span>*<\/span> TO<\/span> 'wordpress_user'<\/span>@'localhost'<\/span>;<\/span>
\nFLUSH PRIVILEGES<\/span>;<\/span>
\n\u00a0EXIT<\/span>;<\/span>
\n<\/code><\/div>\n<\/div>\n<\/div>\n<\/div>\n <\/p>\n
\uc704 \uba85\ub839\uc5b4\uc5d0\uc11c:<\/p>\n
\n- \n
wordpress_db<\/code>: \uc6cc\ub4dc\ud504\ub808\uc2a4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984 (\uc6d0\ud558\ub294 \uc774\ub984\uc73c\ub85c \ubcc0\uacbd \uac00\ub2a5)<\/p>\n<\/li>\n- \n
wordpress_user<\/code>: \uc6cc\ub4dc\ud504\ub808\uc2a4\uc6a9 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790 \uc774\ub984 (\uc6d0\ud558\ub294 \uc774\ub984\uc73c\ub85c \ubcc0\uacbd \uac00\ub2a5)<\/p>\n<\/li>\n- \n
your_strong_password<\/code>: \uac15\ub825\ud55c \ube44\ubc00\ubc88\ud638\ub85c \ubcc0\uacbd (\ud2b9\uc218\ubb38\uc790, \uc22b\uc790, \ub300\uc18c\ubb38\uc790 \uc870\ud569 \uad8c\uc7a5)<\/p>\n<\/li>\n<\/ul>\n\uc774 \uc815\ubcf4\ub294 \uc6cc\ub4dc\ud504\ub808\uc2a4 \uc124\uce58 \uacfc\uc815\uc5d0\uc11c \ud544\uc694\ud558\ubbc0\ub85c \uae30\uc5b5\ud574\ub450\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
<\/h2>\n5. MariaDB \uc131\ub2a5 \ucd5c\uc801\ud654<\/h2>\n
\uc6cc\ub4dc\ud504\ub808\uc2a4\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\uae30 \uc704\ud574 MariaDB \uc124\uc815\uc744 \ucd5c\uc801\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n
\n
\n
\n
\n
bash<\/span><\/div>\n<\/div>\n<\/div>\n\n
sudo<\/span> nano<\/span> \/etc\/mysql\/mariadb.conf.d\/50-server.cnf
\n<\/code><\/div>\n<\/div>\n<\/div>\n<\/div>\n[mysqld]<\/code>\u00a0\uc139\uc158\uc5d0 \ub2e4\uc74c \uc124\uc815\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4:<\/p>\n\n
\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
\n
# \uae30\ubcf8 \uce90\uc2dc \ubc0f \ubc84\ud37c \uc124\uc815
\ninnodb_buffer_pool_size = 256M
\ninnodb_log_file_size = 64M
\ninnodb_flush_log_at_trx_commit = 2
\ninnodb_flush_method = O_DIRECT<\/code><\/code><\/div>\n<\/div>\n
\n
# \ucffc\ub9ac \uce90\uc2dc \uc124\uc815
\nquery_cache_type = 1
\nquery_cache_size = 32M
\nquery_cache_limit = 1M<\/p>\n
<\/code><\/code><\/code># \uc5f0\uacb0 \uc124\uc815
\nmax_connections = 100<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\uc774 \uc124\uc815\uc740 4GB \uba54\ubaa8\ub9ac\uac00 \uc788\ub294 \uc11c\ubc84\uc5d0 \uc801\ud569\ud569\ub2c8\ub2e4.
\n\uc11c\ubc84 \uc0ac\uc591\uc5d0 \ub530\ub77c \uac12\uc744 \uc870\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n\uc124\uc815\uc744 \uc800\uc7a5\ud55c \ud6c4 MariaDB\ub97c \uc7ac\uc2dc\uc791\ud569\ub2c8\ub2e4:<\/p>\n
\n
\n
\n
\n
bash<\/span><\/div>\n<\/div>\n<\/div>\n\n
sudo<\/span> systemctl restart mariadb
\n<\/code><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/h2>\n6. phpMyAdmin \uc124\uce58 (\uc120\ud0dd \uc0ac\ud56d)<\/h2>\n
![\"\"](\"https:\/\/bovoid.com\/wp-content\/uploads\/2025\/04\/phpMyAdmin-installation-1024x577.webp\")
<\/p>\n
\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc6f9 \uc778\ud130\ud398\uc774\uc2a4\ub85c \uad00\ub9ac\ud558\uace0 \uc2f6\ub2e4\uba74 phpMyAdmin\uc744 \uc124\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n
\n
\n
\n
\n
bash<\/span><\/div>\n<\/div>\n<\/div>\n\n
sudo<\/span> apt<\/span> install<\/span> phpmyadmin -y
\n<\/code><\/div>\n<\/div>\n<\/div>\n<\/div>\n <\/p>\n
\uc124\uce58 \uacfc\uc815\uc5d0\uc11c:<\/p>\n
\n- \n
“Web server to reconfigure automatically”: \uc6f9 \uc11c\ubc84 \uc120\ud0dd \ud654\uba74\uc5d0\uc11c \uc544\ubb34\uac83\ub3c4 \uc120\ud0dd\ud558\uc9c0 \uc54a\uace0 Tab \ud0a4\ub97c \ub20c\ub7ec OK\ub85c \uc774\ub3d9 \ud6c4 Enter<\/p>\n<\/li>\n
- \n
“Configure database for phpmyadmin with dbconfig-common”:\u00a0Yes<\/code>\u00a0\uc120\ud0dd<\/p>\n<\/li>\n- \n
“MySQL application password for phpmyadmin”: phpMyAdmin\uc6a9 \ube44\ubc00\ubc88\ud638 \uc124\uc815<\/p>\n<\/li>\n<\/ul>\n
\uc124\uce58 \ud6c4 Nginx\uc640 \uc5f0\ub3d9\ud558\uae30 \uc704\ud574 \uc124\uc815 \ud30c\uc77c\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4:<\/p>\n
\n
\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
\n
\n
bash<\/div>\n<\/div>\n
sudo<\/span> ln<\/span> -s \/usr\/share\/phpmyadmin \/var\/www\/html\/phpmyadmin
\nsudo<\/span> chown<\/span> -R www-data:www-data \/usr\/share\/phpmyadmin
\nsudo<\/span> chown<\/span> -R www-data:www-data \/var\/lib\/phpmyadmin
\n<\/code><\/div>\n<\/div>\n<\/div>\n<\/div>\nNginx \uc124\uc815\uc744 \ubcc0\uacbd\ud569\ub2c8\ub2e4:<\/p>\n
\n
\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
\n
\n
bash<\/div>\n<\/div>\n
sudo<\/span> nano<\/span> \/etc\/nginx\/sites-available\/wordpress
\n<\/code><\/div>\n<\/div>\n<\/div>\n<\/div>\nserver<\/code>\u00a0\ube14\ub85d \ub0b4\uc5d0 \ub2e4\uc74c \ub0b4\uc6a9\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4:<\/p>\n\n
\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
\n
location \/phpmyadmin {
\nroot \/var\/www\/html;
\nindex index.php index.html index.htm;
\nlocation ~ ^\/phpmyadmin\/(.+\\.php)$ {
\ntry_files $uri =404;
\nroot \/var\/www\/html;
\nfastcgi_pass unix:\/run\/php\/php-fpm.sock; # PHP \ubc84\uc804\uc5d0 \ub9de\uac8c \uc218\uc815
\nfastcgi_index index.php;
\nfastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
\ninclude fastcgi_params;
\n}
\nlocation ~* ^\/phpmyadmin\/(.+\\.(jpg|jpeg|gif|css|png|js|ico|html|xml|txt))$ {
\nroot \/var\/www\/html;
\n}
\n}
\n<\/code><\/div>\n<\/div>\n<\/div>\n<\/div>\nPHP-FPM \uc18c\ucf13 \uacbd\ub85c\ub294 PHP \ubc84\uc804\uc5d0 \ub530\ub77c \ub2ec\ub77c\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc815\ud655\ud55c \uacbd\ub85c\ub85c \uc218\uc815\ud574\uc8fc\uc138\uc694.<\/p>\n
\ubcc0\uacbd \ud6c4 Nginx\ub97c \uc7ac\uc2dc\uc791\ud569\ub2c8\ub2e4:<\/p>\n
\n
\n
\n
\n
bash<\/span><\/div>\n<\/div>\n<\/div>\n\n
sudo<\/span> nginx -t # \uc124\uc815 \ubb38\ubc95 \uac80\uc0ac<\/span>
\nsudo<\/span> systemctl restart nginx
\n<\/code><\/div>\n<\/div>\n<\/div>\n<\/div>\n\uc774\uc81c \uc6f9 \ube0c\ub77c\uc6b0\uc800\uc5d0\uc11c\u00a0http:\/\/[\uc778\uc2a4\ud134\uc2a4_\uacf5\uac1cIP]\/phpmyadmin<\/code>\uc5d0 \uc811\uc18d\ud558\uc5ec phpMyAdmin\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/h2>\n7. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc31\uc5c5 \uc124\uc815<\/h2>\n
\uc6cc\ub4dc\ud504\ub808\uc2a4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc815\uae30\uc801\uc73c\ub85c \ubc31\uc5c5\ud558\ub294 \uac83\uc740 \ub9e4\uc6b0 \uc911\uc694\ud569\ub2c8\ub2e4. \uac04\ub2e8\ud55c \ubc31\uc5c5 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc0dd\uc131\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4:<\/p>\n
\n
\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
\n
\n
bash<\/div>\n<\/div>\n
sudo<\/span> nano<\/span> \/usr\/local\/bin\/backup-wordpress-db.sh
\n<\/code><\/div>\n<\/div>\n<\/div>\n<\/div>\n\ub2e4\uc74c \ub0b4\uc6a9\uc744 \uc785\ub825\ud569\ub2c8\ub2e4:<\/p>\n
![\"\"](\"https:\/\/bovoid.com\/wp-content\/uploads\/2025\/04\/MariaDB-vs-MySQL-logo-1024x397.webp\"){kind=logo}
<\/h2>\n![\"\"](\"https:\/\/bovoid.com\/wp-content\/uploads\/2025\/04\/mariadb-install-in-linux-1024x162.webp\")
<\/div>\n<\/div>\n<\/div>\n![\"\"](\"https:\/\/bovoid.com\/wp-content\/uploads\/2025\/04\/mysql-secure-installation-on-linux-1024x320.webp\")
<\/div>\n