Question

Error phpMyAdmin

Posted January 2, 2020 341 views
Debian 10

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.

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.

×
2 answers

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

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

Submit an Answer