Update:

worked a treat thanks. 2nd link also has other PHP issues that may affect some users.

Code
SET PASSWORD FOR
'user_account'@'localhost' = OLD_PASSWORD('yourpassword');
 
Thanks again Gizmo.