MySQL Forums
Forum List  »  Perl

Re: Mysql, Perl, DBI, DBD Authentication Protocol
Posted by: Peter Broome
Date: April 05, 2005 02:56PM

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';


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,


Options: ReplyQuote

Written By
Re: Mysql, Perl, DBI, DBD Authentication Protocol
April 05, 2005 02:56PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.