Splunk DB connect connection setup for mysql database

[ips_mandar]

Hi
I have installed mysql server database on server where splunk is installed.
In Splunk DB connect I have created identity and saved it . Now I was created new connection where
Connection Type - MySQL
Host - local
Port - 3306 (by default)
Default Database- Here What I need to give since I tried giving schema name but when I tried to save it gives me error
that connection is invalid
https://imgur.com/2BxpSQD
What I am missing here...

[ips_mandar · Accepted solution]

My bad
I need to give hostname as localhost and updated driver version .
Now I am able to save connection.