I am getting below error in my local, I am using root configuration in DBConfig file like below but getting error for user NB00XXXXXX.
DBConfig_file

[2024-08-01 20:27:21,828] ERROR {DBDeployer} – The RCP_Configuration_DS-1.0.0.dbs service, which is not valid, caused {1} DS Fault Message: Access denied for user ‘NB00XXXXXX’@’localhost’ (using password: NO)
Nested Exception:-
java.sql.SQLException: Access denied for user ‘NB00XXXXXX’@’localhost’ (using password: NO)
Source Data Service:-
Name: RCP_Configuration_DS
Location: D:wso2mi-4.1.0bin..tmpcarbonapps-12341722524236215TOTSCo_RCP_ConfigurationCompositeExporter_1.0.0-SNAPSHOT.carRCP_Configuration_DS_1.0.0RCP_Configuration_DS-1.0.0.dbs
Description:
Default Namespace:
http://ws.wso2.org/dataservice
DS Code: CONNECTION_UNAVAILABLE_ERROR

To fix this issue I changed the DBConfig file user from ‘root’ to ‘NB00XXXXXX’ and grant all permission to ‘NB00XXXXXX’ still not fixed.
Then i copied the WSO2-MI folder to /:D drive and ran micro-integrator.sh still no luck.
I am using mysql 8 in windows system in local and trying to pass DB config details under conf/datasources/DBConfig file, by doing this we can deploy the same code in any environment.