ONE Active Server Pages Product Home Page Developer Site Version


Administering Database Publisher

Database Publisher is administered from the Sun ONE ASP Administration Console. Administrators use the Administration Console to enable Database Publisher, specify an authorization key that unlocks the application for use, and specify global Create privileges.

To make Database Publisher available for users, administrators must do the following:

Note icon Note All database security is governed by the privileges assigned to the user account by the MySQL database administrator. For more information about MySQL security, see documentation on the MySQL Web site pertaining to the privilege system (go to

To administer Database Publisher

  1. Open the Administration Console by using the following URL:

  2. http://[HOSTNAME]:[PORT]

    where [HOSTNAME] is the hostname of the Web server configured to run with Sun ONE ASP, and [PORT] is the port on which the Administration Console is running (5100 by default).

    The Server Management page displays.

  3. In the left navigation pane, click Tools.

  4. The Tools page displays.

  5. To enable or disable Database Publisher, select or clear the Enable box for DB Publisher (Database Publisher is enabled by default).

  6. In the Key box for Database Publisher, specify the authorization key that unlocks the application for use. This authorization key must be supplied to each user of the application. The key is configured as "password" by default. A new key should be chosen as soon as possible.

  7. Select or clear the Create database box to specify global Create privileges:

    • If this box is selected, client-side users with appropriate privileges can create a new database on the MySQL server to which to publish an Access database.

    • If this box is cleared, all users are barred from creating a new database on the MySQL server, regardless of other user privileges. If users are not allowed to create a new database, a database must be supplied on the MySQL server for which users have all permissions.

  8. In the Log file box, specify the path for application logging information. If this box is empty, logging for the application will be disabled.

  9. Click Save to save your changes, or Cancel to revert to the settings that were last saved.

See also:

Installing Database Publisher

Using the Database Publisher Wizard