Access denied for user 'da_admin'@'localhost'

[armo]

I have a problem with MySQL after upgrading to 5.1 through custom build.

I can login as root.

Also I can login as da_admin with specified password.

But while I'm trying to grant privileges to da_admin as root :

GRANT ALL PRIVILEGES ON *.* TO da_admin@localhost IDENTIFIED BY 'mypass' WITH GRANT OPTION;

It says :

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

User da_admin exists and I can see in mysql.user table and it's set in /usr/local/directadmin/conf/mysql.conf but I have error while trying to connect with directadmin (Error connecting to MySQL: Access denied for user 'da_admin'@'localhost' (using password: NO)) and setting privileges in phpmyadmin

 

[smtalk]

http://help.directadmin.com/item.php?id=45

 

[armo]

u did not read my post carefully .

 

[smtalk]

Why do you think so? Have you tried to start MySQLd with --skip-grant-tables option?

 

[armo]

Why do you think so? Have you tried to start MySQLd with --skip-grant-tables option?

I said , I have root password and I can login as root , why i have to use --skip-grant-tables ?

 

[armo]

Not any ideas ? It's confusing me.

 

[Spark]

In case anyone comes across this old thread... the problem is when a failed upgrade attempt happens...

To fix:
/usr/bin/mysql_upgrade

... once done run
./build mysql --force

viola problem is gone