...
3. Once you click on JDBC, following window will open, where you need to click on '+' (Create New Connection) button.
4. Once you click on 'Create New Connection' the following window will appear. Here, you have to provide all the setting information as given in the following table and then click on 'Test' button to generate the Message Box where it shows the confirmation of connection. Once Connection is established click on 'Ok' button.
| Sl.No | Field Name | Description |
|---|---|---|
| 1 | Connection Name | Provide the appropriate connection name |
| 2 | Host Name | This is the name of server to which designer tool connects to. In this case, we are connecting to 'localhost'. |
| 3 | Database Name | Provide the database name to which designer tool needs to connect. In MifosX, we generally connect to the database 'mifostenant-default' |
| 4 | Connection Type | In the left column, please select the appropriate connection type(in this case, mysql) . Once you select 'mysql' the Port Number automatically selected as 3306. |
| 5 | User Name | Provide the mysql username( in this case it is 'root') |
| 6 | Password | Provide the mysql password. |