Installation and Upgrade Guides › Directory Configuration Guide › MySQL Server › How to Set Up a MySQL Server › Create a MySQL Data Source

Create a MySQL Data Source

ODBC requires a data source for the MySQL Server wire protocol driver. You can create the MySQL data source using the ODBC Data Source Administrator.

To create a MySQL data source

1. Click Add on the UserDN tab of the ODBC Data Source Administrator.

   The Create New Data Source dialog opens.

2. Select MySQL ODBC 3.5.1 Driver from the list of available drivers, and click Finish.

   The Connector/ODBC dialog and Login tab open.

3. Complete the Data Source Name, Server, User, Password, and Database fields on the Login tab, and click the Connect Options tab.

   Note: The data source name is required for configuring a connection between the Policy Server and the user store.

   Note: Enter the password that you specified when you assigned the root user privileges.

4. Type the server port number in the Port field, and click the Advanced tab.
5. Select Don't Optimize Column Width and Return Matching Rows on the Flags 1 tab, and click Test.

   The MySQL data source is created.