agi mariadb-server mariadb-client systemctl is-enabled mariadb sudo mysql_secure_installation sudo mysql
USE mysql; SELECT plugin FROM USER WHERE USER='root'; UPDATE USER SET plugin='' WHERE USER='root'; FLUSH PRIVILEGES; EXIT;
Ou pour corriger certaines erreurs après une mise à jour automatique (comme “[ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255).” )
sudo mysql_upgrade --user=root --password;
agi php-{mbstring,zip,gd,xml,pear,gettext,cgi} php-mysqli mkdir /var/www/html/phpmyadmin wget https://files.phpmyadmin.net/phpMyAdmin/5.2.0/phpMyAdmin-5.2.0-all-languages.tar.gz tar xzf phpMyAdmin-5.2.0-all-languages.tar.gz --strip-components=1 -C /var/www/html/phpmyadmin cp /var/www/html/phpmyadmin/config.sample.inc.php /var/www/html/phpmyadmin/config.inc.php #pour changer la ligne 'blowfish_secret' : nano /var/www/html/phpmyadmin/config.inc.php chmod 660 /var/www/html/phpmyadmin/config.inc.php chown -R www-data:www-data /var/www/html/phpmyadmin systemctl restart apache2
mkcd /var/www/html/phpmyadminNEW wget https://files.phpmyadmin.net/phpMyAdmin/5.2.0/phpMyAdmin-5.2.0-all-languages.tar.gz tar xzf phpMyAdmin-5.2.0-all-languages.tar.gz --strip-components=1 -C /var/www/html/phpmyadminNEW cp -rp /var/www/html/phpmyadmin/config.inc.php /var/www/html/phpmyadminNEW/config.inc.php chmod 660 /var/www/html/phpmyadminNEW/config.inc.php chown -R www-data:www-data /var/www/html/phpmyadminNEW mv /var/www/html/phpmyadmin /var/www/html/phpmyadminOLD mv /var/www/html/phpmyadminNEW /var/www/html/phpmyadmin # Comparer si le fichier config.inc.php est bien conforme au config.sample.inc.php # (en théorie la seule différence est la ligne 16 avec le "blowfish_secret") # Si tout est OK : # rm /var/www/html/phpmyadmin/phpMyAdmin-5.2.0-all-languages.tar.gz # rm -rf /var/www/html/phpmyadminOLD systemctl restart apache2