Connecting to the MySQL database of the Adobe LiveCycle ES Turnkey installation

This post is about gaining access to the MySQL database that comes installed with the Adobe LiveCycle ES Turnkey solution.

When installing the Turnkey solution of Adobe LiveCycle ES, one automatically installs a MySQL 5.0 database which will be used by the Adobe LiveCycle ES platform. During the installation of the Turnkey solution one will be asked to provide a username and password for the account that Adobe LiveCycle ES will use to gain access to the MySQL 5.0 database (write these down somewhere because we need them later on!!).

When the Adobe LiveCycle ES platform is installed, configured and started one needs to perform the following actions to gain access to the Adobe LiveCycle ES database:

1. Install the MySQL GUI Tools according to the installation guide provided by MySQL.
2. Open a command window (start -> run -> cmd) and navigate to the bin directory of the mysql database that comes installed with Adobe LiveCycle ES (normally this would be: C:\Adobe\LiveCycle8.2\mysql\bin).
3. Open the MySQL console under the root account and execute the command: msql -u root -p<the password you entered during the installation>
4. To grant the Adobe LiveCycle ES user all privileges to the MySQL database one needs to execute the following command within the MySQL console: grant all privileges on *.* to ‘<the username you entered during the installation>’@’%’ identified by ‘<the password you entered during the installation>’;
5. After this one needs to flush the privileges by executing the command: flush privileges;
6. One can quit the MySQL console by executing the command: quit;

After these actions one should be able to connect to the MySQL 5.0 database of Adobe LiveCycle ES via the MySQL Query Browser of the MySQL GUI Tools.

To setup a connection to the database with the MySQL Query Browser, one will need to perform the following steps:

1. Start the MySQL Query Browser
2. In the connection window one presses the ellipsis (…) button to open de connection configuration window.
   

   Connection Window

3. In the connection configuration window, one can enter the parameters needed for the connection. To connect to the Adobe LiveCycle database use the schema: adobe. When one is finished one can apply those settings and close the configuration window.
   

   Configuration Window

4. Make a connection to the Adobe LiveCycle database by selecting the profile one just has created and entering the password.

Now one is able to query the Adobe LiveCycle ES database, but be careful not to change anything unless you’re an expert!!!!!