http://blog.roxing.net/ weblog roxing.net - astuces spip, php, bash, linux & more fr SPIP - www.spip.net https://blog.roxing.net/local/cache-vignettes/L144xH37/siteon0-6ddb5.png?1727125340 http://blog.roxing.net/ 37 144 https://blog.roxing.net/debian9-installation-apache2-mariadb-phpmyadmin https://blog.roxing.net/debian9-installation-apache2-mariadb-phpmyadmin 2017-12-04T21:20:52Z text/html fr Pierrox mysql debian linux howto debian stretch phpmyadmin <p>Comment installer un serveur http sur Debian 9 avec une base de données MySQL et son interface phpmyadmin en 30 secondes :<</p> - <a href="https://blog.roxing.net/administration-systeme" rel="directory">administration système</a> / <a href="https://blog.roxing.net/mysql" rel="tag">mysql</a>, <a href="https://blog.roxing.net/debian" rel="tag">debian</a>, <a href="https://blog.roxing.net/gnu-linux" rel="tag">linux</a>, <a href="https://blog.roxing.net/howto" rel="tag">howto</a>, <a href="https://blog.roxing.net/debian-stretch" rel="tag">debian stretch</a>, <a href="https://blog.roxing.net/phpmyadmin" rel="tag">phpmyadmin</a> <div class='rss_texte'><textarea readonly='readonly' cols='40' rows='2' class='spip_cadre spip_cadre_block' dir='ltr'>apt install apache2 php7.0 logrotate mariadb-server phpmyadmin</textarea> <p>A l'installation de phpmyadmin laisser le champ vide pour configurer automatiquement les identifiants de connexion à la base de données.</p> <p>[x] Cocher redémarrer apache2 pour prendre en compte la configuration ;</p> <p>Puis ajouter "root" en superadmin de phpmyadmin</p> <textarea readonly='readonly' cols='40' rows='4' class='spip_cadre spip_cadre_block' dir='ltr'>mysql -uroot mysql -e "SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MonPassRootIci'); update user set plugin='' where user='root'; flush privileges;"</textarea> <p>Se connecter sur <a href="http://localhost/phpmyadmin" class="spip_url spip_out auto" rel="nofollow external">http://localhost/phpmyadmin</a></p></div>