{"id":522,"date":"2026-03-29T16:58:27","date_gmt":"2026-03-29T14:58:27","guid":{"rendered":"https:\/\/netcloud24.com\/pl\/blog\/?p=522"},"modified":"2026-03-29T16:58:27","modified_gmt":"2026-03-29T14:58:27","slug":"jak-zainstalowac-phpmyadmin-z-nginx-i-ssl-na-ubuntu-24-04","status":"publish","type":"post","link":"https:\/\/netcloud24.com\/pl\/blog\/jak-zainstalowac-phpmyadmin-z-nginx-i-ssl-na-ubuntu-24-04\/","title":{"rendered":"Jak Zainstalowa\u0107 PhpMyAdmin z Nginx i SSL na Ubuntu 24.04"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<style>\n        * {<br \/>\n            margin: 0;<br \/>\n            padding: 0;<br \/>\n            box-sizing: border-box;<br \/>\n        }<\/p>\n<p>        body {<br \/>\n            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;<br \/>\n            line-height: 1.7;<br \/>\n            color: #333;<br \/>\n            background-color: #f8f9fa;<br \/>\n        }<\/p>\n<p>        .container {<br \/>\n            max-width: 900px;<br \/>\n            margin: 0 auto;<br \/>\n            padding: 20px;<br \/>\n            background-color: white;<br \/>\n        }<\/p>\n<p>        header {<br \/>\n            margin-bottom: 40px;<br \/>\n            border-bottom: 3px solid #667eea;<br \/>\n            padding-bottom: 20px;<br \/>\n        }<\/p>\n<p>        h1 {<br \/>\n            font-size: 2.5em;<br \/>\n            color: #667eea;<br \/>\n            margin-bottom: 15px;<br \/>\n            line-height: 1.3;<br \/>\n        }<\/p>\n<p>        .article-meta {<br \/>\n            font-size: 0.9em;<br \/>\n            color: #666;<br \/>\n            margin-bottom: 20px;<br \/>\n        }<\/p>\n<p>        h2 {<br \/>\n            font-size: 1.8em;<br \/>\n            color: #667eea;<br \/>\n            margin-top: 40px;<br \/>\n            margin-bottom: 20px;<br \/>\n            border-bottom: 2px solid #e0e0e0;<br \/>\n            padding-bottom: 10px;<br \/>\n        }<\/p>\n<p>        h3 {<br \/>\n            font-size: 1.4em;<br \/>\n            color: #333;<br \/>\n            margin-top: 25px;<br \/>\n            margin-bottom: 15px;<br \/>\n        }<\/p>\n<p>        p {<br \/>\n            margin-bottom: 15px;<br \/>\n            text-align: justify;<br \/>\n        }<\/p>\n<p>        ul, ol {<br \/>\n            margin-left: 30px;<br \/>\n            margin-bottom: 15px;<br \/>\n        }<\/p>\n<p>        li {<br \/>\n            margin-bottom: 10px;<br \/>\n        }<\/p>\n<p>        .highlight-box {<br \/>\n            background-color: #fff3cd;<br \/>\n            border-left: 4px solid #ffc107;<br \/>\n            padding: 15px;<br \/>\n            margin: 20px 0;<br \/>\n            border-radius: 4px;<br \/>\n        }<\/p>\n<p>        .cta-button {<br \/>\n            display: inline-block;<br \/>\n            background-color: #667eea;<br \/>\n            color: white;<br \/>\n            padding: 12px 30px;<br \/>\n            text-decoration: none;<br \/>\n            border-radius: 4px;<br \/>\n            margin: 20px 0;<br \/>\n            transition: background-color 0.3s;<br \/>\n            font-weight: bold;<br \/>\n        }<\/p>\n<p>        .cta-button:hover {<br \/>\n            background-color: #5568d3;<br \/>\n        }<\/p>\n<p>        .code-block {<br \/>\n            background-color: #2d2d2d;<br \/>\n            color: #f8f8f2;<br \/>\n            padding: 15px;<br \/>\n            border-radius: 4px;<br \/>\n            overflow-x: auto;<br \/>\n            margin: 20px 0;<br \/>\n            font-family: 'Courier New', monospace;<br \/>\n            font-size: 0.9em;<br \/>\n            line-height: 1.4;<br \/>\n        }<\/p>\n<p>        .info-box {<br \/>\n            background-color: #d1ecf1;<br \/>\n            border-left: 4px solid #17a2b8;<br \/>\n            padding: 15px;<br \/>\n            margin: 20px 0;<br \/>\n            border-radius: 4px;<br \/>\n        }<\/p>\n<p>        .warning-box {<br \/>\n            background-color: #f8d7da;<br \/>\n            border-left: 4px solid #dc3545;<br \/>\n            padding: 15px;<br \/>\n            margin: 20px 0;<br \/>\n            border-radius: 4px;<br \/>\n        }<\/p>\n<p>        .success-box {<br \/>\n            background-color: #d4edda;<br \/>\n            border-left: 4px solid #28a745;<br \/>\n            padding: 15px;<br \/>\n            margin: 20px 0;<br \/>\n            border-radius: 4px;<br \/>\n        }<\/p>\n<p>        .feature-list {<br \/>\n            display: grid;<br \/>\n            grid-template-columns: 1fr 1fr;<br \/>\n            gap: 20px;<br \/>\n            margin: 20px 0;<br \/>\n        }<\/p>\n<p>        .feature-item {<br \/>\n            background-color: #f8f9fa;<br \/>\n            padding: 15px;<br \/>\n            border-radius: 4px;<br \/>\n            border-left: 4px solid #667eea;<br \/>\n        }<\/p>\n<p>        .feature-item h4 {<br \/>\n            color: #667eea;<br \/>\n            margin-bottom: 10px;<br \/>\n        }<\/p>\n<p>        a {<br \/>\n            color: #667eea;<br \/>\n            text-decoration: none;<br \/>\n        }<\/p>\n<p>        a:hover {<br \/>\n            text-decoration: underline;<br \/>\n            color: #5568d3;<br \/>\n        }<\/p>\n<p>        footer {<br \/>\n            margin-top: 50px;<br \/>\n            padding-top: 20px;<br \/>\n            border-top: 2px solid #e0e0e0;<br \/>\n            text-align: center;<br \/>\n            color: #666;<br \/>\n            font-size: 0.9em;<br \/>\n        }<\/p>\n<p>        .table-of-contents {<br \/>\n            background-color: #f0f3ff;<br \/>\n            padding: 20px;<br \/>\n            margin: 30px 0;<br \/>\n            border-left: 4px solid #667eea;<br \/>\n            border-radius: 4px;<br \/>\n        }<\/p>\n<p>        .table-of-contents h2 {<br \/>\n            font-size: 1.3em;<br \/>\n            margin-bottom: 15px;<br \/>\n        }<\/p>\n<p>        .table-of-contents ul {<br \/>\n            list-style: none;<br \/>\n            padding-left: 0;<br \/>\n        }<\/p>\n<p>        .table-of-contents li {<br \/>\n            margin: 8px 0;<br \/>\n        }<\/p>\n<p>        table {<br \/>\n            width: 100%;<br \/>\n            border-collapse: collapse;<br \/>\n            margin: 20px 0;<br \/>\n        }<\/p>\n<p>        th, td {<br \/>\n            border: 1px solid #ddd;<br \/>\n            padding: 12px;<br \/>\n            text-align: left;<br \/>\n        }<\/p>\n<p>        th {<br \/>\n            background-color: #667eea;<br \/>\n            color: white;<br \/>\n        }<\/p>\n<p>        @media (max-width: 768px) {<br \/>\n            h1 {<br \/>\n                font-size: 1.8em;<br \/>\n            }<\/p>\n<p>            h2 {<br \/>\n                font-size: 1.4em;<br \/>\n            }<\/p>\n<p>            .feature-list {<br \/>\n                grid-template-columns: 1fr;<br \/>\n            }<br \/>\n        }<br \/>\n    <\/style>\n<p>&nbsp;<\/p>\n<div class=\"container\"><!-- Header --><\/p>\n<header>\n<h1>\ud83d\uddc4\ufe0f Jak Zainstalowa\u0107 PhpMyAdmin z Nginx i SSL na Ubuntu 24.04<\/h1>\n<div class=\"article-meta\"><strong>Opublikowano:<\/strong> 2024 | <strong>Kategoria:<\/strong> MySQL \/ Nginx | <strong>Autor:<\/strong> NetCloud24<\/div>\n<p style=\"font-size: 1.1em; font-style: italic; color: #555;\">Kompletny poradnik instalacji PhpMyAdmin na Ubuntu 24.04 z Nginx i Let&#8217;s Encrypt SSL. Krok po kroku &#8211; od instalacji pakiet\u00f3w, przez konfiguracj\u0119, do bezpiecze\u0144stwa. Idealne dla <a href=\"https:\/\/netcloud24.com\/\">Linux VPS<\/a> lub <a href=\"https:\/\/netcloud24.com\/\">serwera dedykowanego<\/a>.<\/p>\n<\/header>\n<p><!-- Table of Contents --><\/p>\n<nav class=\"table-of-contents\">\n<h2>Spis tre\u015bci<\/h2>\n<ul>\n<li><a href=\"#czym-jest-phpmyadmin\">1. Czym jest PhpMyAdmin?<\/a><\/li>\n<li><a href=\"#wymagania\">2. Wymagania Systemowe<\/a><\/li>\n<li><a href=\"#aktualizacja-systemu\">3. Aktualizacja Ubuntu 24.04<\/a><\/li>\n<li><a href=\"#instalacja-pakietow\">4. Instalacja Pakiet\u00f3w (PHP, MySQL, Nginx)<\/a><\/li>\n<li><a href=\"#instalacja-phpmyadmin\">5. Pobranie i Instalacja PhpMyAdmin<\/a><\/li>\n<li><a href=\"#konfiguracja-nginx\">6. Konfiguracja Nginx dla PhpMyAdmin<\/a><\/li>\n<li><a href=\"#konfiguracja-php\">7. Konfiguracja PHP dla PhpMyAdmin<\/a><\/li>\n<li><a href=\"#lets-encrypt\">8. Instalacja Let&#8217;s Encrypt SSL<\/a><\/li>\n<li><a href=\"#bezpieczenstwo\">9. Bezpiecze\u0144stwo PhpMyAdmin<\/a><\/li>\n<li><a href=\"#faq\">10. Pytania i Odpowiedzi<\/a><\/li>\n<\/ul>\n<\/nav>\n<p><!-- Main Content --><\/p>\n<p><main><br \/>\n<!-- Section 1 --><\/main><\/p>\n<section id=\"czym-jest-phpmyadmin\">\n<h2>1. Czym jest PhpMyAdmin?<\/h2>\n<p><strong>PhpMyAdmin<\/strong> to graficzny interfejs web do zarz\u0105dzania bazami danych MySQL\/MariaDB. Pozwala na tworzenie baz, tabel, zarz\u0105dzanie u\u017cytkownikami, importowanie\/exportowanie danych &#8211; wszystko bez terminala!<\/p>\n<p>Instalacja <strong>PhpMyAdmin na Ubuntu 24.04<\/strong> jest idealna, je\u015bli posiadasz <a href=\"https:\/\/netcloud24.com\/\">Linux VPS<\/a> lub <a href=\"https:\/\/netcloud24.com\/\">serwer dedykowany<\/a> z MySQL. PhpMyAdmin znacznie u\u0142atwia zarz\u0105dzanie bazami danych!<\/p>\n<h3>G\u0142\u00f3wne Funkcje PhpMyAdmin:<\/h3>\n<ul>\n<li>\ud83d\uddc4\ufe0f Tworzenie i usuwanie baz danych<\/li>\n<li>\ud83d\udccb Zarz\u0105dzanie tabelami<\/li>\n<li>\ud83d\udc65 Zarz\u0105dzanie u\u017cytkownikami MySQL<\/li>\n<li>\ud83d\udce5 Import z CSV, SQL, itp.<\/li>\n<li>\ud83d\udce4 Export baz danych<\/li>\n<li>\ud83d\udd0d SQL query editor<\/li>\n<li>\ud83d\udcca Wizualizacja danych<\/li>\n<li>\ud83d\udd12 Backup\/Restore<\/li>\n<\/ul>\n<div class=\"info-box\"><strong>Por\u00f3wnanie:<\/strong> Je\u015bli masz <a href=\"https:\/\/netcloud24.com\/\">serwer dedykowany windows<\/a>, mo\u017cesz u\u017cy\u0107 SQL Server Management Studio. Na <a href=\"https:\/\/netcloud24.com\/\">Linux VPS<\/a> PhpMyAdmin to standard!<\/div>\n<\/section>\n<p><!-- Section 2 --><\/p>\n<section id=\"wymagania\">\n<h2>2. Wymagania Systemowe<\/h2>\n<p>Przed zainstalowaniem <strong>PhpMyAdmin na Ubuntu 24.04<\/strong>, sprawd\u017a czy Tw\u00f3j <a href=\"https:\/\/netcloud24.com\/\">serwer<\/a> spe\u0142nia wymagania:<\/p>\n<div class=\"feature-list\">\n<div class=\"feature-item\">\n<h4>Minimalne<\/h4>\n<ul style=\"margin-left: 20px; margin-bottom: 0;\">\n<li>CPU: 1 rdze\u0144<\/li>\n<li>RAM: 512 MB<\/li>\n<li>Dysk: 100 MB<\/li>\n<li>MySQL: 5.5+<\/li>\n<li>PHP: 7.2+<\/li>\n<\/ul>\n<\/div>\n<div class=\"feature-item\">\n<h4>Rekomendowane<\/h4>\n<ul style=\"margin-left: 20px; margin-bottom: 0;\">\n<li>CPU: 2+ rdzenie<\/li>\n<li>RAM: 1 GB+<\/li>\n<li>Dysk: 1+ GB<\/li>\n<li>MySQL: 8.0+<\/li>\n<li>PHP: 8.1+<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<p>PhpMyAdmin jest lekki. Dzia\u0142a nawet na <a href=\"https:\/\/netcloud24.com\/\">tanich VPS Linux<\/a>. Je\u015bli masz <a href=\"https:\/\/netcloud24.com\/\">Linux VPS<\/a> z 1GB RAM &#8211; PhpMyAdmin b\u0119dzie dzia\u0142a\u0107 doskonale!<\/p>\n<div class=\"warning-box\"><strong>Uwaga!<\/strong> PhpMyAdmin musi by\u0107 na HTTPS (SSL) &#8211; nigdy HTTP! Has\u0142a MySQL b\u0119d\u0105 szyfrowane.<\/div>\n<\/section>\n<p><!-- Section 3 --><\/p>\n<section id=\"aktualizacja-systemu\">\n<h2>3. Aktualizacja Ubuntu 24.04<\/h2>\n<p>Przed instalacj\u0105, zawsze zaktualizuj system na <a href=\"https:\/\/netcloud24.com\/\">Linux VPS<\/a>:<\/p>\n<div class=\"code-block\">sudo apt update<br \/>\nsudo apt upgrade -y<br \/>\nsudo apt install -y wget curl gnupg2 ca-certificates<\/div>\n<\/section>\n<p><!-- Section 4 --><\/p>\n<section id=\"instalacja-pakietow\">\n<h2>4. Instalacja Pakiet\u00f3w (PHP, MySQL, Nginx)<\/h2>\n<h3>Krok 1: Instalacja Nginx<\/h3>\n<div class=\"code-block\">sudo apt install -y nginx<br \/>\nsudo systemctl start nginx<br \/>\nsudo systemctl enable nginx<\/div>\n<h3>Krok 2: Instalacja PHP 8.3 z Rozszerzeniami<\/h3>\n<div class=\"code-block\">sudo apt install -y php php-fpm php-mysql php-mbstring php-zip php-gd php-json php-curl<\/div>\n<h3>Krok 3: Uruchomienie PHP-FPM<\/h3>\n<div class=\"code-block\">sudo systemctl start php8.3-fpm<br \/>\nsudo systemctl enable php8.3-fpm<\/div>\n<h3>Krok 4: Instalacja MySQL Server<\/h3>\n<div class=\"code-block\">sudo apt install -y mysql-server<br \/>\nsudo mysql_secure_installation<\/div>\n<p>Podczas bezpiecznej instalacji:<\/p>\n<ul>\n<li>VALIDATE PASSWORD: Y (tak)<\/li>\n<li>Root password: wpisz silne has\u0142o<\/li>\n<li>Remove anonymous users: Y<\/li>\n<li>Disable root login remotely: Y<\/li>\n<li>Remove test database: Y<\/li>\n<\/ul>\n<h3>Sprawdzenie MySQL Status<\/h3>\n<div class=\"code-block\">sudo systemctl status mysql<\/div>\n<\/section>\n<p><!-- Section 5 --><\/p>\n<section id=\"instalacja-phpmyadmin\">\n<h2>5. Pobranie i Instalacja PhpMyAdmin<\/h2>\n<h3>Krok 1: Pobranie PhpMyAdmin<\/h3>\n<p>Przejd\u017a do \/var\/www i pobierz najnowszy PhpMyAdmin:<\/p>\n<div class=\"code-block\">cd \/var\/www<br \/>\nsudo wget https:\/\/files.phpmyadmin.net\/phpMyAdmin\/5.2.1\/phpMyAdmin-5.2.1-all-languages.tar.gz<br \/>\nsudo tar xzf phpMyAdmin-5.2.1-all-languages.tar.gz<br \/>\nsudo mv phpMyAdmin-5.2.1-all-languages phpmyadmin<br \/>\nsudo rm phpMyAdmin-5.2.1-all-languages.tar.gz<\/div>\n<h3>Krok 2: Zmiana Uprawnie\u0144<\/h3>\n<div class=\"code-block\">sudo chown -R www-data:www-data \/var\/www\/phpmyadmin<br \/>\nsudo chmod -R 755 \/var\/www\/phpmyadmin<\/div>\n<h3>Krok 3: Tworzenie Folderu Config<\/h3>\n<div class=\"code-block\">sudo mkdir -p \/var\/www\/phpmyadmin\/tmp<br \/>\nsudo chown -R www-data:www-data \/var\/www\/phpmyadmin\/tmp<br \/>\nsudo chmod -R 700 \/var\/www\/phpmyadmin\/tmp<\/div>\n<h3>Krok 4: Konfiguracja PhpMyAdmin<\/h3>\n<p>Skopiuj plik config:<\/p>\n<div class=\"code-block\">sudo cp \/var\/www\/phpmyadmin\/config.sample.inc.php \/var\/www\/phpmyadmin\/config.inc.php<\/div>\n<p>Edytuj plik config:<\/p>\n<div class=\"code-block\">sudo nano \/var\/www\/phpmyadmin\/config.inc.php<\/div>\n<p>Zmie\u0144 linijk\u0119 (szukaj $cfg[&#8217;blowfish_secret&#8217;]):<\/p>\n<div class=\"code-block\">$cfg[&#8217;blowfish_secret&#8217;] = 'WYGENERUJ_LOSOWY_TEKST_32_ZNAKI&#8217;;<\/div>\n<p>Gdzie &#8222;WYGENERUJ_LOSOWY_TEKST&#8221; to losowy tekst (np. z openssl rand -base64 32)<\/p>\n<div class=\"success-box\"><strong>Sukces!<\/strong> PhpMyAdmin jest pobrany i skonfigurowany!<\/div>\n<\/section>\n<p><!-- Section 6 --><\/p>\n<section id=\"konfiguracja-nginx\">\n<h2>6. Konfiguracja Nginx dla PhpMyAdmin<\/h2>\n<h3>Tworzenie Pliku Konfiguracji Nginx<\/h3>\n<div class=\"code-block\">sudo nano \/etc\/nginx\/sites-available\/phpmyadmin<\/div>\n<h3>Zawarto\u015b\u0107 Pliku:<\/h3>\n<div class=\"code-block\">server {<br \/>\nlisten 80;<br \/>\nlisten [::]:80;<br \/>\nserver_name phpmyadmin.example.com www.phpmyadmin.example.com;root \/var\/www\/phpmyadmin;<br \/>\nindex index.php index.html index.htm;<\/p>\n<p>location \/ {<br \/>\ntry_files $uri $uri\/ =404;<br \/>\n}<\/p>\n<p>location ~ \\.php$ {<br \/>\ninclude snippets\/fastcgi-php.conf;<br \/>\nfastcgi_pass unix:\/var\/run\/php\/php8.3-fpm.sock;<br \/>\n}<\/p>\n<p>location ~ \/\\.ht {<br \/>\ndeny all;<br \/>\n}<\/p>\n<p># Zakaz dost\u0119pu do wra\u017cliwych folder\u00f3w<br \/>\nlocation ~ ^\/config\/ {<br \/>\ndeny all;<br \/>\n}<\/p>\n<p>location ~ ^\/libraries\/ {<br \/>\ndeny all;<br \/>\n}<br \/>\n}<\/p>\n<\/div>\n<p>Zmie\u0144 &#8222;phpmyadmin.example.com&#8221; na Twoj\u0105 domen\u0119!<\/p>\n<h3>Aktywacja Virtual Host<\/h3>\n<div class=\"code-block\">sudo ln -s \/etc\/nginx\/sites-available\/phpmyadmin \/etc\/nginx\/sites-enabled\/<\/div>\n<h3>Testowanie Konfiguracji<\/h3>\n<div class=\"code-block\">sudo nginx -t<\/div>\n<p>Powinna pokaza\u0107 &#8222;syntax is ok&#8221;.<\/p>\n<h3>Restart Nginx<\/h3>\n<div class=\"code-block\">sudo systemctl restart nginx<\/div>\n<\/section>\n<p><!-- Section 7 --><\/p>\n<section id=\"konfiguracja-php\">\n<h2>7. Konfiguracja PHP dla PhpMyAdmin<\/h2>\n<h3>Edycja PHP Config<\/h3>\n<div class=\"code-block\">sudo nano \/etc\/php\/8.3\/fpm\/php.ini<\/div>\n<h3>Zmie\u0144 te Warto\u015bci:<\/h3>\n<div class=\"code-block\">upload_max_filesize = 100M<br \/>\npost_max_size = 100M<br \/>\nmemory_limit = 256M<br \/>\nmax_execution_time = 300<\/div>\n<p>(Dla wi\u0119kszych baz danych &#8211; edytuj wielko\u00f3\u015bci jako potrzebujesz)<\/p>\n<h3>Restart PHP-FPM<\/h3>\n<div class=\"code-block\">sudo systemctl restart php8.3-fpm<\/div>\n<\/section>\n<p><!-- Section 8 --><\/p>\n<section id=\"lets-encrypt\">\n<h2>8. Instalacja Let&#8217;s Encrypt SSL<\/h2>\n<h3>Instalacja Certbot<\/h3>\n<div class=\"code-block\">sudo apt install -y certbot python3-certbot-nginx<\/div>\n<h3>Generowanie Certyfikatu SSL<\/h3>\n<div class=\"code-block\">sudo certbot certonly &#8211;nginx -d phpmyadmin.example.com -d www.phpmyadmin.example.com<\/div>\n<p>Zmie\u0144 domen\u0119 na Twoj\u0105!<\/p>\n<h3>Automatyczne Odnawianie<\/h3>\n<div class=\"code-block\">sudo systemctl start certbot.timer<br \/>\nsudo systemctl enable certbot.timer<\/div>\n<div class=\"success-box\"><strong>Sukces!<\/strong> Let&#8217;s Encrypt SSL certyfikat jest wygenerowany!<\/div>\n<\/section>\n<p><!-- Section 9 --><\/p>\n<section id=\"bezpieczenstwo\">\n<h2>9. Bezpiecze\u0144stwo PhpMyAdmin<\/h2>\n<h3>Krok 1: Edycja Nginx Config dla HTTPS<\/h3>\n<div class=\"code-block\">sudo nano \/etc\/nginx\/sites-available\/phpmyadmin<\/div>\n<p>Dodaj blok HTTPS:<\/p>\n<div class=\"code-block\">server {<br \/>\nlisten 443 ssl http2;<br \/>\nlisten [::]:443 ssl http2;<br \/>\nserver_name phpmyadmin.example.com www.phpmyadmin.example.com;ssl_certificate \/etc\/letsencrypt\/live\/phpmyadmin.example.com\/fullchain.pem;<br \/>\nssl_certificate_key \/etc\/letsencrypt\/live\/phpmyadmin.example.com\/privkey.pem;<\/p>\n<p># Reszta konfiguracji jak wy\u017cej&#8230;<br \/>\n}<\/p>\n<p># Redirect HTTP na HTTPS<br \/>\nserver {<br \/>\nlisten 80;<br \/>\nlisten [::]:80;<br \/>\nserver_name phpmyadmin.example.com www.phpmyadmin.example.com;<br \/>\nreturn 301 https:\/\/$server_name$request_uri;<br \/>\n}<\/p>\n<\/div>\n<h3>Krok 2: Ograniczenie Dost\u0119pu IP (Opcjonalnie)<\/h3>\n<p>W bloku server {} dodaj:<\/p>\n<div class=\"code-block\">allow 192.168.1.0\/24; # Twoja sie\u0107 domowa<br \/>\ndeny all; # Wszystkie inne zablokowane<\/div>\n<h3>Krok 3: Zmiana URL Logowania<\/h3>\n<p>Edytuj config.inc.php:<\/p>\n<div class=\"code-block\">sudo nano \/var\/www\/phpmyadmin\/config.inc.php<\/div>\n<p>Zmie\u0144:<\/p>\n<div class=\"code-block\">$cfg[&#8217;PmaAbsoluteUri&#8217;] = 'https:\/\/phpmyadmin.example.com\/&#8217;;<\/div>\n<h3>Krok 4: Zmiana Portu PhpMyAdmin (Opcjonalnie)<\/h3>\n<p>Zamiast \/phpmyadmin zmie\u0144 na \/admin123 (bardziej bezpieczne):<\/p>\n<div class=\"code-block\">sudo mv \/var\/www\/phpmyadmin \/var\/www\/admin123<\/div>\n<h3>Krok 5: Wy\u0142\u0105czenie Root Logowania<\/h3>\n<p>W config.inc.php dodaj:<\/p>\n<div class=\"code-block\">$cfg[&#8217;Servers&#8217;][$i][&#8217;AllowRoot&#8217;] = false;<\/div>\n<h3>Krok 6: Restart Nginx<\/h3>\n<div class=\"code-block\">sudo systemctl restart nginx<\/div>\n<h3>Sprawdzenie PhpMyAdmin<\/h3>\n<p>Otw\u00f3rz w przegl\u0105darce:<\/p>\n<div class=\"code-block\">https:\/\/phpmyadmin.example.com\/<\/div>\n<p>Powinna pokaza\u0107 formularz logowania PhpMyAdmin z zielonym zamkiem \ud83d\udd12<\/p>\n<div class=\"warning-box\"><strong>WA\u017bNE!<\/strong> ZAWSZE loguj si\u0119 do PhpMyAdmin na HTTPS! Nigdy HTTP! Has\u0142o MySQL nie b\u0119dzie szyfrowane na HTTP.<\/div>\n<\/section>\n<p><!-- Section 10 --><\/p>\n<section id=\"faq\">\n<h2>10. Pytania i Odpowiedzi<\/h2>\n<div class=\"info-box\"><strong>P: Czy PhpMyAdmin jest bezpieczny?<\/strong>O: Tak, je\u015bli prawid\u0142owo skonfigurowa\u0107. SSL\/HTTPS, ograniczenia IP, zmieniony URL, wy\u0142\u0105czony root &#8211; to wszystko zwi\u0119ksza bezpiecze\u0144stwo.<\/p>\n<\/div>\n<div class=\"info-box\"><strong>P: Czy mog\u0119 zainstalowa\u0107 PhpMyAdmin na <a href=\"https:\/\/netcloud24.com\/\">tanich VPS Linux<\/a>?<\/strong>O: Oczywi\u015bcie! PhpMyAdmin to lekkie narz\u0119dzie. Nawet <a href=\"https:\/\/netcloud24.com\/\">tani VPS Linux<\/a> z 512 MB RAM b\u0119dzie dzia\u0142a\u0107.<\/p>\n<\/div>\n<div class=\"info-box\"><strong>P: Czy mog\u0119 zainstalowa\u0107 PhpMyAdmin na <a href=\"https:\/\/netcloud24.com\/\">serwer vps z windows<\/a>?<\/strong>O: Nie. PhpMyAdmin wymaga PHP, a PHP naturalne dzia\u0142a na Linux. Na <a href=\"https:\/\/netcloud24.com\/\">serwer vps z windows<\/a> mo\u017cesz zamiast tego u\u017cy\u0107 SQL Server Management Studio.<\/p>\n<\/div>\n<div class=\"info-box\"><strong>P: Co je\u015bli zapomn\u0119 has\u0142a root MySQL?<\/strong>O: Mo\u017cesz zresetowa\u0107 has\u0142o root: `sudo mysql -u root` i u\u017cy\u0107 ALTER USER komendy.<\/p>\n<\/div>\n<div class=\"info-box\"><strong>P: Czy mog\u0119 zmieni\u0107 URL z \/phpmyadmin na co\u015b innego?<\/strong>O: Tak! Najprostszy spos\u00f3b to przeniesienie folderu: `sudo mv \/var\/www\/phpmyadmin \/var\/www\/admin123`<\/p>\n<\/div>\n<div class=\"info-box\"><strong>P: Jak backup bazy danych w PhpMyAdmin?<\/strong>O: W PhpMyAdmin: wybierz baz\u0119 \u2192 Export \u2192 wybierz SQL format \u2192 Download. Gotowe!<\/p>\n<\/div>\n<div class=\"info-box\"><strong>P: Czy PhpMyAdmin wykorzysta du\u017co zasob\u00f3w?<\/strong>O: Nie. PhpMyAdmin tylko czyta\/pisze do MySQL. CPU usage jest minimalny na <a href=\"https:\/\/netcloud24.com\/\">Linux VPS<\/a>.<\/p>\n<\/div>\n<div class=\"info-box\"><strong>P: Czy Let&#8217;s Encrypt certyfikat jest naprawd\u0119 darmowy?<\/strong>O: Tak! 100% darmowy, wa\u017cny 90 dni, auto-renew za darmo. Idealny dla ka\u017cdego <a href=\"https:\/\/netcloud24.com\/\">Linux VPS<\/a>.<\/p>\n<\/div>\n<\/section>\n<p><!-- Summary --><\/p>\n<section>\n<h2>\ud83c\udf89 Podsumowanie<\/h2>\n<p>Zainstalowanie <strong>PhpMyAdmin z Nginx i SSL na Ubuntu 24.04<\/strong> to \u015bwietny krok dla zarz\u0105dzania MySQL na <a href=\"https:\/\/netcloud24.com\/\">Linux VPS<\/a> lub <a href=\"https:\/\/netcloud24.com\/\">serwerze dedykowanym<\/a>. Teraz mo\u017cesz \u0142atwo zarz\u0105dza\u0107 bazami danych!<\/p>\n<p><strong>Checklist Po Instalacji:<\/strong><\/p>\n<ul>\n<li>\u2705 Nginx zainstalowany i konfiguracyjny<\/li>\n<li>\u2705 PHP 8.3 zainstalowany z rozszerzeniami<\/li>\n<li>\u2705 MySQL zainstalowany i bezpieczny<\/li>\n<li>\u2705 PhpMyAdmin pobrany i skonfigurowany<\/li>\n<li>\u2705 Let&#8217;s Encrypt SSL certyfikat wygenerowany<\/li>\n<li>\u2705 Nginx HTTPS skonfigurowany<\/li>\n<li>\u2705 PhpMyAdmin dost\u0119pny na HTTPS<\/li>\n<li>\u2705 Bezpiecze\u0144stwo zwi\u0119kszone (IP limit, zmieniony URL)<\/li>\n<\/ul>\n<p><strong>Nast\u0119pne Kroki:<\/strong><\/p>\n<ul>\n<li>\ud83d\udd10 Zmie\u0144 has\u0142o root MySQL regularnie<\/li>\n<li>\ud83d\udcca Stw\u00f3rz dedykowane u\u017cytkownika dla ka\u017cdej bazy<\/li>\n<li>\ud83d\udcbe Regularnie backupuj bazy danych<\/li>\n<li>\ud83d\udea8 Monitoruj logi dost\u0119pu (\/var\/log\/nginx\/)<\/li>\n<li>\ud83d\udee1\ufe0f Updateuj PhpMyAdmin gdy b\u0119d\u0105 dost\u0119pne nowe wersje<\/li>\n<\/ul>\n<p>Je\u015bli wynajmujesz <a href=\"https:\/\/netcloud24.com\/\">Linux VPS<\/a> lub <a href=\"https:\/\/netcloud24.com\/\">serwer dedykowany<\/a> od <a href=\"https:\/\/netcloud24.com\/\">NetCloud24<\/a>, mo\u017cesz zainstalowa\u0107 PhpMyAdmin bez problem\u00f3w &#8211; mamy 24\/7 support w polskim j\u0119zyku!<\/p>\n<p><a class=\"cta-button\" style=\"font-size: 1.1em; padding: 15px 40px;\" href=\"https:\/\/netcloud24.com\/\">\u279c Zam\u00f3w Linux VPS z PhpMyAdmin &#8211; NetCloud24<\/a><\/p>\n<\/section>\n<p>&nbsp;<\/p>\n<p><!-- Footer --><\/p>\n<footer>\u00a9 2024 NetCloud24 &#8211; PhpMyAdmin Nginx SSL Ubuntu 24.04<\/p>\n<p>Frazy: <a href=\"https:\/\/netcloud24.com\/\">Linux VPS<\/a>, <a href=\"https:\/\/netcloud24.com\/\">serwer dedykowany<\/a>, <a href=\"https:\/\/netcloud24.com\/\">serwer dedykowany windows<\/a>, <a href=\"https:\/\/netcloud24.com\/\">serwer vps z windows<\/a>, <a href=\"https:\/\/netcloud24.com\/\">tani VPS windows<\/a>, <a href=\"https:\/\/netcloud24.com\/\">tani VPS Linux<\/a><\/p>\n<p>\ud83d\udce7 Kontakt: <a href=\"https:\/\/netcloud24.com\/\">NetCloud24.com<\/a> | biuro@netcloud24.com<\/p>\n<\/footer>\n<\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; &nbsp; &nbsp; &nbsp; \ud83d\uddc4\ufe0f Jak Zainstalowa\u0107 PhpMyAdmin z Nginx i SSL na Ubuntu 24.04 Opublikowano: 2024 | Kategoria: MySQL \/ Nginx | Autor: NetCloud24\u2026<\/p>\n","protected":false},"author":1,"featured_media":377,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-522","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/netcloud24.com\/pl\/blog\/wp-json\/wp\/v2\/posts\/522","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/netcloud24.com\/pl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/netcloud24.com\/pl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/pl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/pl\/blog\/wp-json\/wp\/v2\/comments?post=522"}],"version-history":[{"count":1,"href":"https:\/\/netcloud24.com\/pl\/blog\/wp-json\/wp\/v2\/posts\/522\/revisions"}],"predecessor-version":[{"id":523,"href":"https:\/\/netcloud24.com\/pl\/blog\/wp-json\/wp\/v2\/posts\/522\/revisions\/523"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/pl\/blog\/wp-json\/wp\/v2\/media\/377"}],"wp:attachment":[{"href":"https:\/\/netcloud24.com\/pl\/blog\/wp-json\/wp\/v2\/media?parent=522"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/netcloud24.com\/pl\/blog\/wp-json\/wp\/v2\/categories?post=522"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/netcloud24.com\/pl\/blog\/wp-json\/wp\/v2\/tags?post=522"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}