Skip to main content

phpMyAdmin - Database Passwords Stop Working

Very reluctantly, I had to install phpMyAdmin (PMA) 2.10.2 (beta) on my Debian production server. Before I booed for doing this, let me just note that it was out of sheer compulsion that I had to do this.

Anyways, I noticed that CLI scripts from SellerBay stopped being able to connect to confero24.com's OSC database, incessantly throwing this error:
sb09@ottawa:~$ ./app/scripts/OSC/osc2sb_orders.pl 1 -real
[Sat Jun 16 18:01:53 2007] osc2sb_orders.pl: DBI connect('host=localhost;database=confero_2007_01',' confero',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at /home/sb09/app/lib/Markets/OSC/OSCDB.pm line 33
It turns out that PMA's database libraries use a different password encryption algorithm than those used by the Perl installation SellerBay uses. I'm not yet sure why at all the passwords were re-saved after the PMA installation, as I didn't deliberately do so.

To fix it, I had to login as root using the CLI MySQL client and reset the password (or just run the below command on the old password).
SET PASSWORD FOR db_user@localhost = OLD_PASSWORD('db_pass');
Others' nightmares with this problem:

Some others seem to have faced a more desperate problem when they actually used PMA to re-save (or have it mysteriously to it by itself) the root password. Here's one thread that seems to offer real help (It's long, but worth taking the time)
http://forums.mysql.com/read.php?11,6400,15113#msg-15113

Comments