MySQL & WSO2 Identity Server quick setup

WSO2 identity servers are compatible with MySQL database. Today we are looking quick start guide for MySQL and how to use a MySQL database to run WSO2 identity servers.

step 1 : MySQL and PHPMyadmin installation

Step 2 : go to localhost/phpmyadmin

step 3 : create a database userstore

step 4 : Download WSO2 Identity Servers and Extract

step 5 : Download MySQL jdbc connector and Extract  after that
             mysql-connector-java-5.1.38-bin.jar move to wso2is-5.1.0/repository/components/lib

step 6 : wso2is database configuration edit wso2is-5.1.0/repository/conf/datasources/master-
             datasources.xml  (add this configuration)
         
        <datasource>
           <name>WSO2_CARBON_DB</name>
           <description>The datasource used for registry and user manager</description>
           <jndiConfig>
               <name>jdbc/WSO2CarbonDB</name>
           </jndiConfig>
           <definition type="RDBMS">
               <configuration>
                   <url>jdbc:mysql://localhost:3306/userstore</url>
                   <username>root</username>
                   <password>root</password>
                   <driverClassName>com.mysql.jdbc.Driver</driverClassName>
                   <maxActive>80</maxActive>
                   <maxWait>60000</maxWait>
                   <minIdle>5</minIdle>
                   <testOnBorrow>true</testOnBorrow>
                   <validationQuery>SELECT 1</validationQuery>
                   <validationInterval>30000</validationInterval>
               </configuration>
           </definition>
       </datasource>

step 7 : open your terminal and run wso2 IS
            cd wso2is-5.1.0/
            sh bin/wso2server.sh -Dsetup

step 8 : now check you MySQL DB

so finally your are configured.