Linux MySql Password

[oOIOo]

Hello

i forgot mysql password for my dedicated

what should i do to get it or reset it

((i already setup password before))

Thanks for help

 

[Diath]

mysqladmin -u root password NEWPASSWORD

Don't remove the 'password' keyword.

 

[oOIOo]

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

 

[Don Daniello]

/etc/init.d/mysql stop
mysqld_safe --skip-grant-tables &
mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
mysql> flush privileges;
mysql> quit
/etc/init.d/mysql stop
/etc/init.d/mysql start