Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

[sam wun]

Deniss Hennesy wrote:

>Hi, 
>
>I have had to change mysql root passwd  
>My procedure is just below
>
>
>shell> mysql -u root -p
>mysql> UPDATE mysql.user SET Password=PASSWORD('newpwd')  WHERE User='root';
>mysql> flush privileges;
>
>
>  
>
YOu may be need to execute command mysqladmin -u root password 
(yourpassword) for the creation of password. I m not sure,  not expert 
in DBA.

Sam

>and I checked this password another consol  I saw MySQL wasn't
>accepted  new passwd else, it didnt old password or without password.
>
>  
>