[Mashiro]

Part 1 of the fix is already available here: https://post4vps.com/Thread-Reset-MariaDB-Root-Password

Part 2 is nothing special either. I created a second user that is not called root and I granted it global administrative permission. All of this through the MySQL command line client "mysql".

The commands I used are:

Code: (Select All)

1. mysql -u root -p
2. USE mysql;
3. CREATE USER 'username'@'localhost' IDENTIFIED BY 'passwordhere';
4. GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;
5. FLUSH PRIVILEGES;
6. exit

In MySQL 5.7 and MariaDB 10.1 login as root in applications has usually been disabled as a security protection method. You can usually only login as root from the MySQL command line client "mysql". To fix that I created a new user as described above.

Or better said:

MySQL 5.7 changed the secure model: now MySQL root login requires a sudo. phpMyAdmin will be not able to use root credentials. The simplest, safest and permanent solution will be create a new user and grant required privileges.

About your phpMyAdmin not found issue. You simply installed it wrong or at the wrong location. I just downloaded the latest version as .zip file, moved the file to /var/www/html, extracted it, renamed the extracted folder and then inside I renamed "config.inc.sample.php" to "config.inc.php" and set the required "blowfish secret" inside that file.