{"id":133,"date":"2023-11-28T15:03:56","date_gmt":"2023-11-28T14:03:56","guid":{"rendered":"https:\/\/artheodoc.fr\/?page_id=133"},"modified":"2025-03-04T11:37:26","modified_gmt":"2025-03-04T10:37:26","slug":"installation-de-phpmyadmin-sur-un-serveur-sous-debian-11","status":"publish","type":"page","link":"https:\/\/artheodoc.fr\/index.php\/installation-de-phpmyadmin-sur-un-serveur-sous-debian-11\/","title":{"rendered":"Installation de phpMyAdmin sur un serveur sous Debian 11"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

phpMyAdmin (PMA) est une application Web de gestion pour les syst\u00e8mes de gestion de base de donn\u00e9es MySQL et MariaDB, r\u00e9alis\u00e9e principalement en PHP et distribu\u00e9e sous licence GNU GPL.<\/em><\/p>\n\n\n\n

wikip\u00e9dia<\/em><\/p>\n\n\n\n

Sources : https:\/\/askubuntu.com\/questions\/896988\/change-phpmyadmin-port-from-80-to-another-number<\/a><\/p>\n\n\n\n

Mise \u00e0 jour du syst\u00e8me (en administrateur root su<\/strong>) :<\/p>\n\n\n\n

apt-get update<\/strong><\/pre>\n\n\n\n
apt-get upgrade<\/strong><\/pre>\n\n\n\n
Installation de phpMyAdmin depuis un terminal en administrateur :<\/p>\n\n\n\n
apt-get install phpmyadmin<\/strong><\/pre>\n\n\n\n
Serveur web \u00e0 reconfigurer automatiquement : apache2<\/strong><\/p>\n\n\n\n
Faut-il configurer la base de donn\u00e9es de phpmyadmin avec dbconfig-common ? Oui<\/strong><\/p>\n\n\n\n
Configuration de l\u2019h\u00f4te virtuel (virtualhost) exemple avec le port 99<\/strong>.<\/p>\n\n\n\n
nano \/etc\/apache2\/sites-available\/phpmyadmin.conf<\/strong><\/pre>\n\n\n\n
<VirtualHost *:99>\n   ServerName localhost\n        <Directory \/usr\/share\/phpmyadmin>\n                AllowOverride None\n                Require all granted\n        <\/Directory>\n   DocumentRoot \/usr\/share\/phpmyadmin\n   Include \/etc\/phpmyadmin\/apache.conf\n   ErrorLog ${APACHE_LOG_DIR}\/phpmyadmin.error.log\n   CustomLog ${APACHE_LOG_DIR}\/phpmyadmin.access.log combined\n<\/VirtualHost><\/pre>\n\n\n\n
Pour enregistrer le fichier :<\/p>\n\n\n\n
[CRTL] <\/strong>+ [X]<\/strong> pour quitter l\u2019\u00e9diteur nano.<\/p>\n\n\n\n
[O]<\/strong> pour confirmer l\u2019enregistrement des modifications.<\/p>\n\n\n\n
[Entr\u00e9e]<\/strong> pour confirmer le nom du fichier.<\/p>\n\n\n\n
Changez la configuration d\u2019Apache et red\u00e9marrez-le.<\/p>\n\n\n\n
a2disconf phpmyadmin<\/strong><\/pre>\n\n\n\n
a2ensite phpmyadmin<\/strong><\/pre>\n\n\n\n
systemctl restart apache2.service<\/strong><\/pre>\n\n\n\n
\n\n\n\n
Fichier pour changer le port d\u2019\u00e9coute d\u2019Apache 2<\/p>\n\n\n\n
Apr\u00e8s son installation Apache \u00e9coute les ports par d\u00e9faut 80 pour le HTTP et 443 pour le HTTPS.<\/p>\n\n\n\n
Pour modifier le fichier de configuration.<\/p>\n\n\n\n
nano \/etc\/apache2\/ports.conf<\/strong><\/pre>\n\n\n\n
Si je veux qu\u2019Apache \u00e9coute en plus le port 99, j\u2019ajoute la ligne suivante en d\u00e9but du fichier.<\/p>\n\n\n\n
Listen 0.0.0.0:99<\/strong><\/pre>\n\n\n\n
Enregistrez le fichier comme vu pr\u00e9c\u00e9demment.<\/p>\n\n\n\n
Red\u00e9marrer le serveur WEB Apache :<\/p>\n\n\n\n
systemctl restart apache2.service<\/strong><\/pre>\n\n\n\n
\n\n\n\n
Acc\u00e8s au serveur depuis le r\u00e9seau local ou \u00e0 distance<\/p>\n\n\n\n
Configurez les r\u00e8gles NAT <\/strong>de la box et le pare-feu si n\u00e9cessaire.<\/p>\n\n\n\n
Pour acc\u00e9der \u00e0 phpMyAdmin avec l\u2019ip et le port 99.<\/p>\n\n\n\n
http:\/\/adresse_ip<\/em>:99<\/strong> ou http:\/\/ adresse_ip<\/em>:99\/phpmyadmin<\/strong><\/p>\n\n\n\n
Login : root<\/strong> mot de passe administrateur MariaDB<\/strong><\/p>\n\n\n\n
Remplacez adresse_ip<\/em><\/strong> par l\u2019adresse IP de votre pare-feu sur le r\u00e9seau local<\/strong> ou \u00e0 distance par l\u2019IP publique<\/strong> de la box (si les r\u00e8gles NAT et \u00e9ventuellement le pare-feu sont configur\u00e9s pour autoriser l\u2019acc\u00e8s.).<\/p>\n\n\n\n
\n\n\n\n
Plus d\u2019informations<\/p>\n\n\n\n
Exemple d\u2019utilisation de phpMyAdmin pour changer le nom de domaine d\u2019un site WordPress.<\/p>\n\n\n\n
Comment changer le nom de domaine d\u2019un site WordPress ?<\/p>\n\n\n\n
https:\/\/www.journalducm.com\/comment-changer-nom-de-domaine-site-wordpress\/<\/a><\/p>\n\n\n\n
Sauvegarde d\u2019un site avec Filezilla et PhpMyAdmin.<\/p>\n\n\n\n
https:\/\/www.team-ever.com\/sauvegarde-site-avec-filezilla-et-phpmyadmin\/<\/a><\/p>\n\n\n\n
Probl\u00e8me de fichiers trop volumineux.<\/p>\n\n\n\n
PhpMyAdmin fichiers trop volumineux<\/a><\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
phpMyAdmin (PMA) est une application Web de gestion pour les syst\u00e8mes de gestion de base de donn\u00e9es MySQL et MariaDB, r\u00e9alis\u00e9e principalement en PHP et distribu\u00e9e sous licence GNU GPL. wikip\u00e9dia Sources : https:\/\/askubuntu.com\/questions\/896988\/change-phpmyadmin-port-from-80-to-another-number Mise \u00e0 jour du syst\u00e8me (en administrateur root su) : apt-get update apt-get upgrade Installation de phpMyAdmin depuis un terminal en administrateur : […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-133","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/pages\/133","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/comments?post=133"}],"version-history":[{"count":4,"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/pages\/133\/revisions"}],"predecessor-version":[{"id":1856,"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/pages\/133\/revisions\/1856"}],"wp:attachment":[{"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/media?parent=133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}