kmcoleau
Posts: 10
Joined: Tue Mar 08, 2016 7:55 am

PHPMyAdmin Questions

Fri May 01, 2020 5:08 am

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

User avatar
DougieLawson
Posts: 39120
Joined: Sun Jun 16, 2013 11:19 pm
Location: A small cave in deepest darkest Basingstoke, UK
Contact: Website Twitter

Re: PHPMyAdmin Questions

Fri May 01, 2020 9:44 am

You use the credentials you've added with a command line mysql session.
Note: Any requirement to use a crystal ball or mind reading will result in me ignoring your question.

Criticising any questions is banned on this forum.

Any DMs sent on Twitter will be answered next month.
All non-medical doctors are on my foes list.

kmcoleau
Posts: 10
Joined: Tue Mar 08, 2016 7:55 am

Re: PHPMyAdmin Questions

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.

User avatar
DougieLawson
Posts: 39120
Joined: Sun Jun 16, 2013 11:19 pm
Location: A small cave in deepest darkest Basingstoke, UK
Contact: Website Twitter

Re: PHPMyAdmin Questions

Sat May 02, 2020 11:12 am

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.
Note: Any requirement to use a crystal ball or mind reading will result in me ignoring your question.

Criticising any questions is banned on this forum.

Any DMs sent on Twitter will be answered next month.
All non-medical doctors are on my foes list.

Return to “Troubleshooting”