Results 1 to 5 of 5

Thread: [SOLVED] help about mysql password

  1. #1
    old-cow is offline Intermediate Member
    Join Date
    Dec 2007
    Location
    China
    Posts
    22
    Rep Power
    7

    Default [SOLVED] help about mysql password

    Hi,

    I changed my mysql password like that .
    Code:
    mysqladmin -u root -p passeord NETPW
    
    logmysqladmin -u root -p passeord NETPW
    I am sorry that I did not use
    zmmylogpasswd --root NEWPW
    to do it.

    now I got some error :

    Code:
    [zimbra@sub ~]$ zmcontrol status
            antispam                Running
            antivirus               Running
            imapproxy               Running
            ldap                    Running
            logger                  Stopped
                    logmysql.server is not running
            mailbox                 Stopped
                    mysql.server is not running
            mta                     Running
            snmp                    Running
            stats                   Stopped
    but my zimbra server run well , it can send mail and receive mail correct.


    Code:
    [zimbra@sub ~]$ mysql mysql
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A
    
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 18
    Server version: 5.0.45-log Source distribution
    
    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
    
    mysql>
    and now I can not use zmmmypasswd and zmmylogpasswd to change password.
    Code:
    [zimbra@sub ~]$ zmmypasswd --root NETWORD
    /opt/zimbra/bin/mysqladmin -u root --password=F3dkjMXyfqy2CH_vvtJJshwO password NETWORD
    /opt/zimbra/mysql/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: YES)'
    **** PASSWORD CHANGE FAILED
    
    [zimbra@sub ~]$ zmmylogpasswd --root NEWPW
    /opt/zimbra/bin/logmysqladmin -u root --password=XX0mvfRgnwMCxuvxz2XAXEFg password NEWPW
    /opt/zimbra/logger/mysql/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: YES)'
    **** PASSWORD CHANGE FAILED
    [zimbra@sub ~]$
    can anybody help ?

    Thanks !
    Last edited by old-cow; 08-11-2008 at 06:58 AM.
    Code:
    [zimbra@sub ~]$ zmcontrol -v
    
    
    Release 5.0.2_GA_1975.RHEL4_20080130212006 RHEL4 FOSS edition
    
    [zimbra@sub ~]$

  2. #2
    old-cow is offline Intermediate Member
    Join Date
    Dec 2007
    Location
    China
    Posts
    22
    Rep Power
    7

    Question

    Code:
    [zimbra@sub ~]$ zmcontrol stop
    Host abc.com
            Stopping stats...Done
            Stopping mta...Done
            Stopping spell...Done
            Stopping snmp...Done
            Stopping archiving...Done
            Stopping antivirus...Done
            Stopping antispam...Done
            Stopping imapproxy...Done
            Stopping mailbox...Done
            Stopping logger...Done
            Stopping ldap...Done
    [zimbra@sub ~]$ zmcontrol start
    Host abc.com
            Starting ldap...Done.
            Starting logger...Done.
            Starting mailbox...Done.
            Starting imapproxy...Done.
            Starting antispam...Done.
            Starting antivirus...Done.
            Starting snmp...Done.
            Starting mta...Done.
            Starting stats...Done.
    [zimbra@sub ~]$ zmcontrol status
    Host abc.com
            antispam                Running
            antivirus               Running
            imapproxy               Running
            ldap                    Running
            logger                  Stopped
                    logmysql.server is not running
            mailbox                 Stopped
                    mysql.server is not running
            mta                     Running
            snmp                    Running
            stats                   Running
    [zimbra@sub ~]$
    can somebody help?
    Code:
    [zimbra@sub ~]$ zmcontrol -v
    
    
    Release 5.0.2_GA_1975.RHEL4_20080130212006 RHEL4 FOSS edition
    
    [zimbra@sub ~]$

  3. #3
    old-cow is offline Intermediate Member
    Join Date
    Dec 2007
    Location
    China
    Posts
    22
    Rep Power
    7

    Default

    Code:
    [zimbra@sub ~]$ zmcontrol status
            antispam                Running
            antivirus               Running
            imapproxy               Running
            ldap                    Running
            logger                  Stopped
                    logmysql.server is not running
            mailbox                 Stopped
                    mysql.server is not running
            mta                     Running
            snmp                    Running
            stats                   Running
    [zimbra@sub ~]$ mysql.server stop
    Killing mysqld with pid 28074 . done.
    [zimbra@sub ~]$ mysql.server start
    [zimbra@sub ~]$ zmcontrol status
            antispam                Running
            antivirus               Running
            imapproxy               Running
            ldap                    Running
            logger                  Stopped
                    logmysql.server is not running
            mailbox                 Stopped
                    mysql.server is not running
            mta                     Running
            snmp                    Running
            stats                   Running
    [zimbra@sub ~]$ mysql.server start
    mysqld_safe already running with pid 32417
    [zimbra@sub ~]$
    Code:
    [zimbra@sub ~]$ zmcontrol -v
    
    
    Release 5.0.2_GA_1975.RHEL4_20080130212006 RHEL4 FOSS edition
    
    [zimbra@sub ~]$

  4. #4
    bdial's Avatar
    bdial is offline Moderator
    Join Date
    Jul 2007
    Location
    Baltimore
    Posts
    1,649
    Rep Power
    10

    Default

    see if your mysql_logger_root_password is still the old one

    Code:
    zimbra@server:~> zmlocalconfig -s | grep -i mysql_logger
    If it's sitll the old password, set it to your NEWPW

    Code:
    zmlocalconfig -e mysql_logger_root_password=NEWPW

  5. #5
    old-cow is offline Intermediate Member
    Join Date
    Dec 2007
    Location
    China
    Posts
    22
    Rep Power
    7

    Talking

    Thanks a lots. That help me to fix this problem.

    And I found that all the run time value come from file
    /opt/zimbra/conf/localconfig.xml . I make a backup of localconfig.xml, then
    I modified the vaule mysql_root_password and mysql_logger_root_password
    to the new value , and then all things got well.


    Thanks again !

    --
    old-cow
    Code:
    [zimbra@sub ~]$ zmcontrol -v
    
    
    Release 5.0.2_GA_1975.RHEL4_20080130212006 RHEL4 FOSS edition
    
    [zimbra@sub ~]$

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  2. [SOLVED] Install Problem in Ubuntu 6.06 Server
    By xtimox in forum Installation
    Replies: 16
    Last Post: 03-27-2008, 09:36 AM
  3. DNS Questions and Trouble Installing
    By smurraysb in forum Installation
    Replies: 22
    Last Post: 03-14-2008, 03:27 PM
  4. Replies: 18
    Last Post: 03-20-2006, 02:22 PM
  5. Can't start MySQL to init db - Gentoo
    By fak3r in forum Installation
    Replies: 3
    Last Post: 10-10-2005, 06:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •