Configuring External Applications to View the SFX Databases

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

For a general description of the SFX databases, refer to the SFX Environment section of the SFX Advanced User’s Guide.

A list of database tables and fields, as well as a section of the ERD diagram that shows the connections between the most important database tables, can be found in the Database Tables section of the SFX Advanced User’s Guide.

After installation, access to the MySQL databases of each instance is available only via the UNIX MySQL interface, not via a GUI client. If access via a GUI client is needed, you need to grant permissions for external applications to access the local SFX database.

To grant permissions for external applications to access the local SFX database:

Type the following:

mysql -p<root_password> -uroot

use mysql

select password('<local instance>');

You will see something similar to the following:

+-------------------------------------------+

| password('sfxlcl42') |

+-------------------------------------------+

| *82B3FB27642224053A89127297A4AE73FE4EF235 |

+-------------------------------------------+

Type the following:

GRANT SELECT ON *.* TO '<local instance>'@'%.<local hostname>' IDENTIFIED BY PASSWORD '<password>';

For example:

mysql -p1q2w3e4r -uroot

use mysql

select password('sfxlcl42');

GRANT SELECT ON *.* TO 'sfxlcl42'@'%.exlibrisgroup.com' IDENTIFIED BY PASSWORD '*82B3FB27642224053A89127297A4AE73FE4EF235';