I tried running:
mysqladmin -u root password 'new-password'
and it (at least the first time) was fine. Now when I try to change the password again, or start a mysql instance, it says 'access denied for user root@xxxxxxxxx using password YES'
"-p"
$mysqladmin -uroot ... -p
$mysql -uroot -p Enter password:
mysql> set password =password('your_password');
Query OK, 0 rows affected (0.00 sec)mysql> grant all privileges on *.* to 'your_user'@'192.%' identified by 'passwd';
Query OK, 0 rows affected (0.00 sec)
or #killall mysqld; mysqld_safe --skip-grant-tables &
http://www.mysql.com/doc/en/Command-line_options.html
-- shrek-m
