Question

Error phpMyAdmin

Hello and thank you very much for the tutorial “How To Install phpMyAdmin From Source on Debian 10”. However after having followed the very instructive procedure, I have the following errors when I connect with the user created for phpmyadmin:

mysqli::real_connect(): (HY000/1045): Access denied for user ‘pma’@‘localhost’ (using password: YES)

The connection to the “controluser” as defined in the configuration failed.

I followed exactly the procedure but with a blowfish_secret of 64 characters and I created a user in addition to pma to connect to phpMyAdmin.

Thank you in advance for your reply.

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Hello,

Thank you for your reply ! Indeed I made a mistake on the allocation of privileges and by starting again this step, the errors disappeared. Your answer put me on the track. Thank you !

Regards,

Seb

Hello,

What I could suggest here is creating a user that has privileges to all tables within the database, as well as the power to add, change, and remove user privileges, with this command.

Whatever privileges you assign to this user, be sure to give it a strong password as well:

GRANT ALL PRIVILEGES ON *.* TO 'sammy'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;

Hope that this helps! Regards, Bobby