11.5 Modifying the ArkSQL Settings

If you need to modify the MySQL root username, password, or port number, you must modify the values in MySQL, in the sys:\arkManager\arkSQL.cnf file, and in the sys:\arkManager\arkConfig.xml file.

  1. Stop ArkManager.

    For information, see Section 11.2, Stopping ArkManager.

  2. If the ArkSQL instance is running at the intended port, shut it down. At the server console, enter

    
mysqladmin -p shutdown --port=value

    Specify -p if the root user’s password is set. Specify the --port if the port is not 3306.

  3. In a text editor, configure ArkSQL with new settings, as necessary.

    1. Set the port number by modifying the following directive:

      
port = 3306

      Replace 3306 with the actual port number.

    2. Save your changes.

    3. (Conditional) If this is an archive server cluster, copy the revised sys:\arkManager\arkSQL.cnf file to each server in the cluster.

  4. Update the archive server information in the sys:\arkManager\arkConfig.xml file. For information, see Section 11.6, Modifying the Archive Server Information.

  5. To start MySQL, at the server console, enter

    
mysqld_safe --defaults-file=sys:\arkManager\arkSQL.cnf

  6. Start ArkManager by entering arkstart at the server console.