perl problem

[Fridgecritter]

Ok, here is what you do...

Let's say your user that accesses the database for your server is "root".

You run this code:

set password for 'root'@'localhost' = OLD_PASSWORD('newpwd');

Now, where it says 'newpwd' you change that to the password that you already have. When you set up MySQL with the password '121212' for root, then the code should look like this:

set password for 'root'@'localhost' = OLD_PASSWORD('121212');

If your username for the server is different than 'root' and it is something like '12user12' and your pass is '121212' then the code should look like this:

set password for '12user12'@'localhost' = OLD_PASSWORD('121212');

If you are having trouble doing this in the console, then you should use the console in a program like Navicat. You install Navicat and then setup the connection, then go to "tools" from the file menu, and click on "console..." or just hit the F6 key on your keyboard while the Navicat program is the active window.

Copy and paste your code into the console and hit the "Enter" key on the keyboard, and it should give you a message saying 0 rows effected or something to that effect.

That worked for me.