its been a couple of days that I'm trying to install mysql on my vps which has debian 5.0 with 256mb ram. I've installed webmin also. here is the symptoms : after installing mysql using either webmin or apt-get I am trying to connect to mysql for changing root password but every time I cope with this error :
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
so I start to investigate and I understand there is no root user inside mysql database when I use :
UPDATE user SET password=PASSWORD('newpassword') WHERE user="root";
it says 0 row affected
I reinstall mysql for several times but the same problem still exits. please help me how can I install mysql-server as well as mysql-client correctly.