MySql Upgrade & Passord issues

[Melik]

I have an app that requires the pre-MySql 4.1 password hash. In order to get my app to connect I need to run the following script:

SET PASSWORD FOR
MYUSER = OLD_PASSWORD('newpassword')

The script gives me an error: #1044 - Access denied for user 'MYUSER'@'localhost' to database 'mysql'

How am I supposed to revert my password to the old version if I dont have access?

thx

[james]

Did you use the syntax:
cpanelusername_myuser?

All usernames in a cpanel server are prefixed by your cpanel username and an underscore. The same goes for mysql database names.

[Melik]

yes I did add the cpanel prefix

[DrCool]

are you on cpanel11?