shell> /etc/init.d/mysql stop
shell> mysqld_safe --skip-grant-tables &
shell>mysql
UPDATE mysql.user SET Password=PASSWORD('...') WHERE User='...' AND Host= '...';
FLUSH PRIVILEGES;
shell> /etc/init.d/mysqld restart
shell> mysqld_safe --skip-grant-tables &
shell>mysql
UPDATE mysql.user SET Password=PASSWORD('...') WHERE User='...' AND Host= '...';
FLUSH PRIVILEGES;
shell> /etc/init.d/mysqld restart