Changing your MySQL password

Article:HOWTO59405  |  Created: 2011-10-04  |  Updated: 2011-10-04  |  Article URL
Article Type
How To


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


    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:


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


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


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


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


    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=


    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




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

    <!-- MySQL dB username and password for dB connections -->
  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


Article URL

Terms of use for this information are found in Legal Notices