{"id":2656,"date":"2013-05-10T12:50:30","date_gmt":"2013-05-10T10:50:30","guid":{"rendered":"http:\/\/www.collet-matrat.com\/?p=2656"},"modified":"2013-05-10T12:50:30","modified_gmt":"2013-05-10T10:50:30","slug":"adminer-une-bonne-alternative-a-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.collet-matrat.com\/?p=2656","title":{"rendered":"\u00ab\u00a0Adminer\u00a0\u00bb : une bonne alternative \u00e0 PhpMyAdmin"},"content":{"rendered":"<p style=\"text-align: justify;\"><a href=\"http:\/\/www.adminer.org\/\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2657 aligncenter\" style=\"border: 0px none;\" alt=\"logo_adminer\" src=\"https:\/\/i0.wp.com\/www.collet-matrat.com\/wp-content\/uploads\/2013\/05\/logo_adminer.png?resize=355%2C88&#038;ssl=1\" width=\"355\" height=\"88\" srcset=\"https:\/\/i0.wp.com\/www.collet-matrat.com\/wp-content\/uploads\/2013\/05\/logo_adminer.png?w=355&amp;ssl=1 355w, https:\/\/i0.wp.com\/www.collet-matrat.com\/wp-content\/uploads\/2013\/05\/logo_adminer.png?resize=300%2C74&amp;ssl=1 300w\" sizes=\"auto, (max-width: 355px) 100vw, 355px\" \/><\/a>Jusqu'\u00e0 maintenant, lorsque j'installais un serveur <a href=\"http:\/\/fr.wikipedia.org\/wiki\/Lamp\" target=\"_blank\">LAMP<\/a> j'avais pour habitude d'y ajouter syst\u00e9matiquement <em>PhpMyAdmin<\/em>. Non pas que je sois allergique \u00e0 la ligne de commande (\u00e7a serait m\u00eame plut\u00f4t l'inverse ...) mais il faut reconna\u00eetre que pour manipuler rapidement une base de donn\u00e9es <em>MySQL<\/em> une interface web n'est pas de trop !<\/p>\n<p style=\"text-align: justify;\">Malheureusement, au fil du temps, <em>PhpMyAdmin<\/em> est devenu de plus en plus lourd et de plus en plus complexe. C'est donc avec plaisir que j'ai d\u00e9couvert, essay\u00e9 et approuv\u00e9 \"<a href=\"http:\/\/www.adminer.org\/\" target=\"_blank\"><em>Adminer<\/em><\/a>\". Il s'agit d'une alternative int\u00e9ressante \u00e0 <em>PhpMyAdmin<\/em> pour les raisons suivantes :<\/p>\n<p style=\"text-align: justify;\">- <em>Adminer<\/em> tient dans un seul et m\u00eame script <em>PHP<\/em>. Et oui vous avez bien lu : pour l'installer il suffit de t\u00e9l\u00e9charger le script (un peu moins de 300ko), de le placer au sein de votre espace d'h\u00e9bergement, de faire pointer votre navigateur dessus et le tour est jou\u00e9 !<\/p>\n<p style=\"text-align: justify;\">- bien que l'interface soit particuli\u00e8rement simple et sobre (ce qui n'est pas sans me d\u00e9plaire) toutes les fonctions de <em>PhpMyAdmin<\/em> semblent \u00eatre pr\u00e9sentes (du moins je n'ai pas constat\u00e9 de fonction manquante pour mes usages) ;<\/p>\n<p style=\"text-align: justify;\">- <em>Adminer<\/em> est \u00e9galement compatible avec d\u2019autres bases de donn\u00e9es : <em>PostgreSQL<\/em>, <em>SQLite<\/em>, <em>MS SQL<\/em> &amp; <em>Oracle<\/em> (mais l\u00e0 je n'ai pas essay\u00e9 ...) ;<\/p>\n<p style=\"text-align: justify;\">- Les mises \u00e0 jour sont simplifi\u00e9es \u00e0 l\u2019extr\u00eame : vous remplacez tout simplement l'ancien script par le nouveau.<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/i0.wp.com\/www.collet-matrat.com\/wp-content\/uploads\/2013\/05\/adminer_screen_db.png?ssl=1\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-2659\" alt=\"adminer_screen_db\" src=\"https:\/\/i0.wp.com\/www.collet-matrat.com\/wp-content\/uploads\/2013\/05\/adminer_screen_db.png?resize=584%2C340&#038;ssl=1\" width=\"584\" height=\"340\" srcset=\"https:\/\/i0.wp.com\/www.collet-matrat.com\/wp-content\/uploads\/2013\/05\/adminer_screen_db.png?w=1048&amp;ssl=1 1048w, https:\/\/i0.wp.com\/www.collet-matrat.com\/wp-content\/uploads\/2013\/05\/adminer_screen_db.png?resize=300%2C174&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.collet-matrat.com\/wp-content\/uploads\/2013\/05\/adminer_screen_db.png?resize=1024%2C596&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.collet-matrat.com\/wp-content\/uploads\/2013\/05\/adminer_screen_db.png?resize=500%2C291&amp;ssl=1 500w\" sizes=\"auto, (max-width: 584px) 100vw, 584px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Petite information pour les utilisateurs de <em>Debian<\/em> (mais certainement aussi pour les autres distribs) il est n\u00e9cessaire d'ajouter pr\u00e9alablement le module <em>php5-mysql<\/em> \u00e0 l'aide de la commande \"<em>apt-get install php5-mysql<\/em>\" (n\u00e9cessaire pour que <em>Adminer<\/em> puisse communiquer avec votre base de donn\u00e9es <em>Mysql<\/em>).<\/p>\n<p style=\"text-align: justify;\">Plus d'infos sur Adminer ? C'est par <a href=\"http:\/\/www.adminer.org\/\" target=\"_blank\">ICI<\/a><\/p>\n<p style=\"text-align: justify;\">\n","protected":false},"excerpt":{"rendered":"<p>Jusqu'\u00e0 maintenant, lorsque j'installais un serveur LAMP j'avais pour habitude d'y ajouter syst\u00e9matiquement PhpMyAdmin. Non pas que je sois allergique \u00e0 la ligne de commande (\u00e7a serait m\u00eame plut\u00f4t l'inverse ...) mais il faut reconna\u00eetre que pour manipuler rapidement une &hellip; <a href=\"https:\/\/www.collet-matrat.com\/?p=2656\">Lire la suite <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"\"Adminer\" : une bonne alternative \u00e0 PhpMyAdmin","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[105,7,90],"tags":[],"class_list":["post-2656","post","type-post","status-publish","format-standard","hentry","category-hebergement","category-linux","category-gpl"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.collet-matrat.com\/index.php?rest_route=\/wp\/v2\/posts\/2656","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.collet-matrat.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.collet-matrat.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.collet-matrat.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.collet-matrat.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2656"}],"version-history":[{"count":16,"href":"https:\/\/www.collet-matrat.com\/index.php?rest_route=\/wp\/v2\/posts\/2656\/revisions"}],"predecessor-version":[{"id":2674,"href":"https:\/\/www.collet-matrat.com\/index.php?rest_route=\/wp\/v2\/posts\/2656\/revisions\/2674"}],"wp:attachment":[{"href":"https:\/\/www.collet-matrat.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2656"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.collet-matrat.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2656"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.collet-matrat.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2656"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}