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's OSC database, incessantly throwing this error:
sb09@ottawa:~$ ./app/scripts/OSC/ 1 -real
[Sat Jun 16 18:01:53 2007] 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/ 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),6400,15113#msg-15113


Popular posts from this blog

Paypal's Ridiculous Business Practices

In Q3-2005 we discovered the power of online sales and started to market Wapsol's products extensively online. Just as importantly we decided to get into the trading business for WLAN accessories (antennae, cable, connectors etc) which entails buying from manufacturers and selling on online-retail. Needless to say ebay's 26 worldwide markets were lucrative points of sales.

We used Paypal for collecting most of payments from customers outside Germany. The numbers ticked up fast and we were hecticly building up infrastructure for shipping, online-support, product-portfolio and payment-systems.

One morning as I woke up in Germany I found that Paypal decided to lock up our account without any specific reason. There were no disputes or complaints from buyers or anything that suggested provocation. They just locked it. In it a few thousands of dollars of cash-flow and the account was listed as a favored payment option for some 100 pending auctions - now customers couldn't pay for …

The Dream of the Information Age

If this beauty of a device meets it's mission of being owned by every kid on the planet, we are looking to a new dimension of the Information Age.
For full profile of the device, visit BBC's technology page.

SnagIT Problem Solved! (Hangs for minutes)

Here's the solution to the SnagIT sluggishness (hangs for several minutes)
I would try first turning off the magnifier window under tools > program preferences > program options. Uncheck the box to show magnifier windows. Click apply > ok and then try the capture again.Check your security software and make sure that Snagit is set as a safe application. A security program that consistently scans the process will cause a very slow response like you are seeing.Please also check your printers per this article:Answer Title: Slow SnagIt startupAnswer Link:, please review the steps here and try these as well:Answer Title: SnagIt crashes or hangs when launchedAnswer Link: me know what happens.