Getting error in mysql database connection

Help Studio
, ,
1

Hi Community,

I am getting this error while connecting with the MySQL database:
image

Could you please guide how to fix this error?

Thanks

2

Hi @Tapan_Behera1

Seems like the bot account does not have the permission to access the specified database. Please contact the database administrator & ask them to provide the appropriate access to the account.

Hope this helps,
Best Regards.

3

Hi @arjunshenoy thanks for the quick response. I have the database admin access and I have also gave all the permission but still getting this error.

4

Hi @Tapan_Behera1 ,

Test the connection using a different client: Use a different MySQL client (e.g., MySQL Workbench) to verify if you can connect to the MySQL database using the same credentials. This will help isolate the issue to UiPath or the database configuration.

And also make sure that you are entering correct credentials, hostname or IP address and port number(mostly MySQL uses 3306 port) and also check the firewalls and security settings and make sure that necessary port open to connect with mysql.

Regards,
Kirankumar.