Error phpMyAdmin

Posted on January 2, 2020

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.

This textbox defaults to using Markdown to format your 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.

Bobby

January 2, 2020

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

Latapoune Sébastien

January 2, 2020

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