Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Enable "mysql_clear_password" plugin in phpMyAdmin

I'm trying to enable our MySQL users to authenticate against our corporate user database via PAM (Kerberos). I can login with my credentials to our MySQL server with command line if I use "--enable-cleartext-plugin" in the command. If I try to login with phpMyAdmin I get the following information:

#2059 Cannot log in to the MySQL server

Is there a way to enable such plugin in phpMyAdmin without hacking any PHP files?

Thank you in advance!

like image 538
Pasi Avatar asked Jul 12 '26 03:07

Pasi


1 Answers

For future reference: I fixed this by adding

mysqli_options($link, MYSQLI_READ_DEFAULT_FILE, '/etc/my.cnf');

in /usr/share/phpMyAdmin/libraries/dbi/mysqli.dbi.lib.php inside the function PMA_DBI_real_connect

With

[client]

enable-cleartext-plugin

in /etc/my.cnf

like image 169
HaloWebMaster Avatar answered Jul 14 '26 18:07

HaloWebMaster



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!