Error while connecting to MySQL Database

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?