Re: Mysql, Perl, DBI, DBD Authentication Protocol

[Peter Broome]

More information...

I tried a suggestion I found in another post. Specifically, on the MySql server, I did:

--------------------------------------------------------------------------
UPDATE mysql.user SET Password = OLD_PASSWORD('newpass') WHERE Host = '%' AND User = 'Peter';

FLUSH PRIVILEDGES;

---------------------------------------------------------------------------
I then removed the host reference in my code snipet to make it default to localhost and executed the Perl script ON THE MYSQL SERVER. WHen I did this, it worked just as documented.

When I made similar changes to include the user at the other workstation (tower), I got the same problem as originally stated.

So, I can make the scriopt work IF AND ONLY IF I run it on the MySql host machien.

Maybe this will jog somevodies ideas....

Many Thanks,

Pete