Man, I hate to keep posting. I'm really sorry for bugging you guys.
anyway... neither command had any rows to update. AND... I was running without the --skip flag and logged in as logmysql -u root -p mysql
to run those commands and used my password, so I think that the password is totally sorted on the mysql side. I'll reset it again in zmlocalconfig using -f and see if it helps.
Note the 0 rows affected.
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> update user set password=PASSWORD('frankjones') where user like 'root%';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 3 Changed: 0 Warnings: 0 |