LiveCycle ES Turnkey - Enabling Remote MySQL Administrator Access

The LiveCycle ES JBoss and WebLogic Turnkeys in Windows both use MySQL Community Edition as their database. By default, MySQL does not allow remote or local access to it using tools such as MySQL Administrator, Oracle SQL Developer, Aquafold Aqua Data Studio or Navicat.

MySQL Administrator is a very useful tool. It is part of what MySQL calls 'MySQL GUI Tools' which can be downloaded here. One of its best features is the ability to optimize the tables which keeps the database running efficiently.

To enable remote access, the following steps are required:

Change directory to MySQL's /bin folder:
cd C:\Adobe\LiveCycle8.2\mysql\bin

Login as user 'root' with password 'password'
mysql -u root -ppassword
or without a password
mysql -u root

If MySQL was installed separately (in the case of non-turnkey install on Linux), you need to set the password for the 'root' user first. Here is an example for SUSE Enterprise Linux 10:
cd /usr/bin
mysqladmin -u root password 'your_new_password'

Verify that you can run commands. Tell MySQL to list its databases
show databases;
You should see multiple databases listed, including adobe (used by LiveCycle) and adobe_meta (used by BAM)

Tell MySQL to allow your user in. Here the user is 'root' with password 'password' logging in from a machine with the DNS name 'laptop.company.com'
GRANT ALL PRIVILEGES ON *.* TO 'root'@'laptop.company.com' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

You should see a response like this :
Query OK, 0 rows affected (0.03 sec)

Logout
quit;
You should see a response like this :
Bye

You can now login as 'root' from the machine 'laptop.company.com' using MySQL Administrator. To optimize the Adobe LIveCycle tables, login and lcik on the schemata called 'adobe'. This will display the list of tables on the right in the 'Schema Tables' tab. On the right pane, at the bottom, click on 'Maintenance'. Check the radiobuton for 'Optimize Tables' and proceed.