Last modified 01 Feb 2022 19:38 +01:00
This functionality is obsolete. It is no longer supported or maintained.


Provisioning works well.
Activation (disable/enable) is not supported.
Synchronization is not supported.


The connector can be used to manage MySQL accounts.

Resource Configuration


Two accounts must be created in MySQL database: an administrative account for provisioning and a sample "prototype" account, which privileges are copied for all newly created accounts.

Consider the following example:

SQL Import File "init-mysql.sql"
-- If you encounter problems, you can set query logging on:

-- mysql -u root -p

-- set global general_log_file = '/var/tmp/mysql.log';

-- set global general_log = 1;

-- Do not forget to reset the logging after tests!!! by using

-- set global general_log = 0;

-- Administrative user for midPoint

CREATE USER 'midpointadmin'@'%' IDENTIFIED BY 'secret';

CREATE USER 'midpointadmin'@'localhost' IDENTIFIED BY 'secret';

GRANT ALL on *.* TO 'midpointadmin'@'%' WITH GRANT OPTION;

GRANT ALL on *.* TO 'midpointadmin'@'localhost' WITH GRANT OPTION;

-- Sample prototype user used as User Model in connector

-- This sample user has global SELECT privilege

CREATE USER 'prototypeuser'@'%' IDENTIFIED BY 'secret';

GRANT SELECT on *.* TO 'prototypeuser'@'%';

The above example defines the "midpointadmin" account with superuser privileges and the "prototypeuser" account with a global SELECT privilege. You are encouraged to customize the example for your needs.

Import the above example with:

Importing SQL Import File
mysql -u root -p < samples/mysqluser/init-mysql.sql

Sample resource can be imported from samples/resources/mysqluser.

Framework: ICF
Bundle: org.forgerock.openicf.connectors.db.mysqluser
Connector: org.identityconnectors.mysqluser.MySQLUserConnector

Connector Configuration

See MySQLUser Connector documentation. (currently, no published documentation).

Connector Configuration Example


Was this page helpful?
Thanks for your feedback