Changing your MySQL password

Article:HOWTO59405  |  Created: 2011-10-04  |  Updated: 2011-10-04  |  Article URL http://www.symantec.com/docs/HOWTO59405
Article Type
How To


Subject


Changing your MySQL password

Symantec Message Filter uses a user account called brightmailuser. The password for that account is a randomly generated password that is created when you install MySQL.

To change the password for the MySQL database after installation

  1. Do the following to turn off Tomcat on the computer that runs the Control Center:

    Linux and Solaris

    Type sudo /etc/init.d/tomcat4 stop

    Windows

    Open the Services Management console, find the Tomcat service, and click Stop.

  2. Open a console window (Solaris and Linux) as root or the command prompt (Windows) as an administrator and navigate to the MySQL installation directory. The default directory location is as follows:

    Solaris

    cd /opt/symantec/sbas/ControlCenter/MySQL/ mysql-pro-4.0.16-sun-solaris2.8-sparc/bin/

    Note:

    If you use a non-default installation directory location, replace /opt/symantec/sbas/ControlCenter with /$loadpoint.

    Linux

    cd /opt/symantec/sbas/ControlCenter/MySQL/ mysql-pro-4.0.16-pc-linux-i686/bin/

    Note:

    If you use a non-default installation directory location, replace /opt/symantec/sbas/ControlCenter with /$loadpoint.

    Windows

    cd C:\mysql\bin

  3. Do the following to open the MySQL client with the password that you looked up:

    Linux and Solaris

    ./mysql --user=brightmailuser --password=<password> --host=127.0.0.1

    Windows

    mysql --user=brightmailuser --password=<password>

  4. Run the following command and change NEW_PASSWORD to a new password:

    UPDATE mysql.user SET Password=<password>('NEW_PASSWORD')
    WHERE User='brightmailuser' LIMIT 1;
  5. Run the following command before you log off of the MySQL Client:

    flush privileges;

    If you omit this step, the Tomcat server cannot log on to the MySQL server with the new password until the MySQL server restarts.

  6. Open the following file in a text editor:

    Linux and Solaris

    $CATALINA_HOME/conf/server.xml

    Windows

    $CATALINA_HOME\conf\server.xml

  7. Locate the following section under the /brightmail Context.

    <!-- MySQL dB username and password for dB connections -->
    <parameter>
    <name>username</name>
    <value>brightmailuser</value>
    </parameter>
    <parameter>
    <name>password</name>
    <value>password</value>
    </parameter>
  8. Change the password in <value>password</value> to your new password.

  9. Save and exit from the server.xml file.

  10. Start Tomcat.


Legacy ID



v41520394_v64406064


Article URL http://www.symantec.com/docs/HOWTO59405


Terms of use for this information are found in Legal Notices