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.


Submit an answer

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!

Sign In or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

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