I just upgraded to the latest version of DietPi yesterday and the default credentials for MariaDB via PhpMyAdmin don’t seem to be working. According to the software list the login should be:
MySql / MariaDB Details:
username = root
password = dietpi
Can anyone tell me if I’m missing something? I also tried a SQL command line update of the root password and it allowed me to use command line. But I still am unable to access the instance via PhpMyAdmin. This was working perfectly on version 159 and I didn’t need to do anything additional. I appreciate the look.
Additionally Dietpi-Software seems to have no issue installing apps such as Pydio. And the default cred for those apps seems to work appropriately. I also tried the most recent info on phpmyadmin as follows:
I am attempting another fresh install and will try to do a root logon from the default subnet of 192.168.0.x as shown in the default settings from the above forum post. Will update.
Update: Definitely on version 161 now. May have been before, installed less than 24hrs ago.
So you were onto it. It was a security limitation. There are no users with server wide permissions by default. The following posts helped me. Really no different than MySQL but a little security change makes setup, longer… :ugeek:
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")