The default database of the user manager is the H2 database shipped by WSO2 Carbon-based products. You can configure it to point to databases of different vendors.
Follow the instructions below to change the RDBMS.
1. Add the JDBC driver to the classpath by dropping the jar into IS_HOME/ repository/components/lib
.
2. Change the values of the properties described here under the the main properties of the user Realm Configuration appropriately.
3. Create the database by running the relevant script in IS_HOME/dbscript/
and starting the server as wso2server.sh
for Linux or wso2server.bat
for Windows.
OR
Start the server as wso2server.sh -Dsetup
for Linux or wso2server.bat -Dsetup
for Windows.