views:

8

answers:

0

hi,

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.

regards.