So the use mysql worked, and it let me reset the password.
I also did a flush...restarted many times...
Here's my order of what I did.
mysql> use mysql
mysql> update user set password=PASSWORD('passhere') where user like 'root%';
flush privileges;
zmmypasswd --root passhere
zmlocalconfig -e -f mysql_logger_root_password='passhere';
I'm pretty sure I'm not smart enough to do this right. Everything works but the logger...and I want to upgrade (I'm using an old build), but I don't even want to try to upgrade w/o fixing this dang logger problem.
Am I missing a step?
---------------------------------------------------------
If I run
Code:
+ BASE=/opt/zimbra
+ SCRIPTS='logmysql.server zmlogswatchctl'
+ case "$1" in
+ STATUS=0
+ for i in '$SCRIPTS'
+ '[' logmysql.server = logmysql.server ']'
+ /opt/zimbra/bin/logmysqladmin status
+ R=1
+ '[' 1 -ne 0 ']'
+ STATUS=1
+ for i in '$SCRIPTS'
+ '[' zmlogswatchctl = logmysql.server ']'
+ /opt/zimbra/bin/zmlogswatchctl status
/opt/zimbra/bin/zmlogswatchctl: line 69: kill: (4369) - No such process
+ R=1
+ '[' 1 -ne 0 ']'
+ STATUS=1
+ exit 1
-------------------------------------------------------
If I try to start the logmysqladmin
I get
[zimbra@tusd-exch01 bin]$ logmysqladmin start
/opt/zimbra/logger/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
[zimbra@tusd-exch01 bin]$ logmysql.server stop
Killing mysqld with pid 30959 ..[zimbra@tusd-exch01 bin]$ logmysql.server start
[zimbra@tusd-exch01 bin]$ Starting mysqld daemon with databases from /opt/zimbra/logger/db/data
I know this is annoying....but any help will be rewarded.