Thread: Mailbox Stopped
View Single Post
  #17 (permalink)  
Old 11-23-2005, 06:38 PM
marcmac marcmac is offline
Zimbra Employee
 
Posts: 2,103
Default mysql password recovery

Kill your mysql process, and restart it with mysql.server - if the mysqladmin returns an errror after that, we'll have to reset your password:

zmcontrol stop
zmlocalconfig -e zimbra_mysql_password=newpasswd
zmlocalconfig -e mysql_root_password=newrootpasswd

edit /opt/zimbra/bin/mysql.server

Change
'start')
# --defaults-file must be first argument
cd ${mysql_directory}; \
${mysql_directory}/bin/mysqld_safe \
--defaults-file=${mysql_mycnf} \
--ledir=${mysql_directory}/bin &
;;

to
'start')
# --defaults-file must be first argument
cd ${mysql_directory}; \
${mysql_directory}/bin/mysqld_safe \
--defaults-file=${mysql_mycnf} \
--skip-grant-tables \
--ledir=${mysql_directory}/bin &
;;

su - zimbra
mysql.server start

mysql mysql
update user set password=PASSWORD('newpasswd') where user='zimbra';
update user set password=PASSWORD('newrootpasswd') where user='root';
flush privileges
exit

mysql.server stop
Change mysql.server back (remove --skip-grant-tables)
mysql.server start
mysqladmin status
Reply With Quote