Page 1 of 1

PHPMyAdmin Questions

Posted: Fri May 01, 2020 5:08 am
by kmcoleau
Latest Raspbian Buster fresh install on Pi 3B
Apache2 installed and working
PHP 7.3 installed and Working
MariaDB 10.3.22 installed and working
PHPMyAdmin installed and appears to work
database mysql table user shows 2 users for localhost, root with no password and phpmyadmin with a hashed password.
database phpmyadmin table pma__users has no records

When I start PHPMyAdmin and get the log in screen what username/password do I use?

Do I manually need to add a user? If yes, how?

Thanks

Ken

Re: PHPMyAdmin Questions

Posted: Fri May 01, 2020 9:44 am
by DougieLawson
You use the credentials you've added with a command line mysql session.

Re: PHPMyAdmin Questions

Posted: Sat May 02, 2020 2:42 am
by kmcoleau
DougieLawson wrote:
Fri May 01, 2020 9:44 am
You use the credentials you've added with a command line mysql session.
This worked, Thank you.

I wasn't expecting to have to use the mysql CLI.

Re: PHPMyAdmin Questions

Posted: Sat May 02, 2020 11:12 am
by DougieLawson
kmcoleau wrote:
Sat May 02, 2020 2:42 am
DougieLawson wrote:
Fri May 01, 2020 9:44 am
You use the credentials you've added with a command line mysql session.
This worked, Thank you.

I wasn't expecting to have to use the mysql CLI.
It's a feature of the changes DebIan made to mysql (aka MariaDB) to remove the root password and the debian-maintenance user from MySQL.