v6.0 MariaDB Default Credentials

Troubleshooting
7
  • Since Stretch, MariaDB comes with unix_socket authentication plugin for root user by default.
  • This means unix root can log into MariaDB root without password, but on the other hand no other user can do this, not even via sudo.
  • Thus all web ui software (using www-data) needs it’s own database user.
  • I just verified the missing privileges for phpMyAdmin on fresh installation. A newly added services stop (including mysql) prevents database access to grant full privileges to ‘phpmyadmin’:
 DietPi-Software
─────────────────────────────────────────────────────
 Mode: Configuring phpMyAdmin: optional mysql admin tools

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")