I followed the following documentations- https://is.docs.wso2.com/en/5.9.0/setup/changing-to-mysql/
I had also tried changing the LDAP user store just for the above use case is it neccesary to do AND which is best for user store LDAP or JDBC using MySQL https://is.docs.wso2.com/en/5.9.0/setup/configuring-a-jdbc-user-store/
This is my deployment.toml file configuration-
[server]
hostname = "localhost"
node_ip = "127.0.0.1"
base_path = "https://$ref{server.hostname}:${carbon.management.port}"
[super_admin]
username = "admin"
password = "admin"
create_admin_account = true
[user_store]
type = "database"
TenantManager="org.wso2.carbon.user.core.tenant.JDBCTenantManager"
ReadOnly=false
ReadGroups=true
WriteGroups=true
[database.user]
url = "jdbc:mysql://localhost:3306/regdb?useSSL=false"
username = "regadmin"
password = "regadmin"
driver = "com.mysql.jdbc.Driver"
[realm_manager]
data_source = "WSO2USER_DB"
[database.carbon_db]
type = "mysql"
url= "jdbc:mysql://127.0.0.1:3306/regdb?useSSL=false"
username = "regadmin"
password = "regadmin"
[database.identity_db]
type = "mysql"
url= "jdbc:mysql://127.0.0.1:3306/regdb?useSSL=false"
username = "regadmin"
password = "regadmin"
[database.shared_db]
type = "mysql"
url= "jdbc:mysql://127.0.0.1:3306/regdb?useSSL=false"
username = "regadmin"
password = "regadmin"
[keystore.primary]
name = "wso2carbon.jks"
password = "wso2carbon"
And the change are not reflecting in the WSO2 Console it is still showing H2 database-