Installing MySQL/EMS

Use this procedure to install a MySQL database and EMS.

Procedure

  1. Install the TIBCO Enterprise Messaging Server and start the server.
  2. Install the MySQL Database.
    1. Download and install the MySQL Database.
    2. Perform the server configuration by following the prompts in the MySQL installer.
    3. Accept the default port value 3306, or enter your own port number.
    4. Download the following JDBC driver connector JAR files (com.mysql.jdbc_5.1.5.jar) to the TIBCO_HOME/afx/version/system/lib/db folder.
    Note: The TIBCO_HOME/afx/version/config/dbscripts/mysql/folder contains two SQL scripts named mysql_create and mysql_drop. These scripts help you to administer the database in an efficient manner. The mysql_create script indicates what you can expect in the database and the mysql_drop script allows you to drop a table if you have a problem with the database. You should back up the data before using the mysql_drop script.