{{tag>Index Installation Integration DB MySQL}}
[<10>]
===== Integrating Aware IM with MySQL database =====

If you do not have MySQL database software you can download one free of charge from the MySQL web site at [[https://dev.mysql.com/downloads]]. Run MySQL installation program and follow the instructions (see MySQL Installation Guide for details). We recommend that you install MySQL as a Windows service. Once the installation has been completed make sure that MySQL is running and perform the integration steps described below.

  - Start the Aware IM Control Panel
  - Select the Settings/Database menu item and select MySQL as the database engine
  - Enter credentials of the MySQL account. Note that the account you specify here must have root user privileges, otherwise Aware IM will not work
  - Specify MySQL server name and the port number where MySQL listens to requests (if these are different from the default values)
  - Click OK and restart Aware IM



If you installed Aware IM as Windows service you can perform database integration manually without using the Aware IM Control Panel. To do this:


  - Delete the default ''AwareIM/bin/BASServer.props'' file which contains default database settings
  - Rename the file ''BASServerMySQL.props'' to ''BASServer.props''
  - Use any text editor to change server name, port and root user credentials to the following lines in the ''BASServer.props'' file:

<code>
DriverURL=jdbc:mysql://localhost/BASDB?user=root&password=blah
DriverTestURL=jdbc:mysql://localhost/BASDBTEST?user=root&password=blah
BootstrapURL=jdbc:mysql://localhost/?user=root&password=blah
</code>

{{simplenavi>docs:1100_inst_guide:0350_db_integration:0100mysql:}}