Skip to main content
Question

Error while connecting to MySQL Database

  • 5 August 2024
  • 1 reply
  • 13 views

Hi folks,

I am getting below error when I am using connection mode as “ user defined”, database type as “MYSQL”, server name as “local host”, database name as “rpa” , credentials using which are created in credentials vault, port number as “3306”

 

I am getting below error when I am using connection mode as “default” and connection is as follows:

Driver={MySQL ODBC 5.2 ANSI Driver};Server=local host;Port=3306;Database=rpa;User=$username$;Password=$password$;Option=3

here, I am selecting the check box for “Use ODBC 64-bit driver for connection

 

Also i am not finding my sql realted option in odbc system DSN.

Kindly help me out from this issue and please let me know what are the prerequisites to connect with MYSQL database?

 

Hi @polugopi,

Please install the MYSQL jdbc driver. 

https://dbschema.com/jdbc-driver/mysql.html


Reply