topic Splunk DB connect connection setup for mysql database in All Apps and Add-ons https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-connect-connection-setup-for-mysql-database/m-p/419690#M51167 <P>Hi <BR /> I have installed mysql server database on server where splunk is installed.<BR /> In Splunk DB connect I have created identity and saved it . Now I was created new connection where <BR /> <STRONG>Connection Type</STRONG> - MySQL<BR /> <STRONG>Host</STRONG> - local<BR /> <STRONG>Port</STRONG> - 3306 (by default)<BR /> <STRONG>Default Database</STRONG>- Here What I need to give since I tried giving schema name but when I tried to save it gives me error<BR /> that connection is invalid<BR /> <A href="https://imgur.com/2BxpSQD">https://imgur.com/2BxpSQD</A><BR /> What I am missing here...</P> Wed, 12 Jun 2019 07:31:34 GMT ips_mandar 2019-06-12T07:31:34Z Splunk DB connect connection setup for mysql database https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-connect-connection-setup-for-mysql-database/m-p/419690#M51167 <P>Hi <BR /> I have installed mysql server database on server where splunk is installed.<BR /> In Splunk DB connect I have created identity and saved it . Now I was created new connection where <BR /> <STRONG>Connection Type</STRONG> - MySQL<BR /> <STRONG>Host</STRONG> - local<BR /> <STRONG>Port</STRONG> - 3306 (by default)<BR /> <STRONG>Default Database</STRONG>- Here What I need to give since I tried giving schema name but when I tried to save it gives me error<BR /> that connection is invalid<BR /> <A href="https://imgur.com/2BxpSQD">https://imgur.com/2BxpSQD</A><BR /> What I am missing here...</P> Wed, 12 Jun 2019 07:31:34 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-connect-connection-setup-for-mysql-database/m-p/419690#M51167 ips_mandar 2019-06-12T07:31:34Z Re: Splunk DB connect connection setup for mysql database https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-connect-connection-setup-for-mysql-database/m-p/419691#M51168 <P>My bad<BR /> I need to give hostname as <STRONG>localhost</STRONG> and updated driver version .<BR /> Now I am able to save connection.</P> Wed, 12 Jun 2019 07:54:37 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-connect-connection-setup-for-mysql-database/m-p/419691#M51168 ips_mandar 2019-06-12T07:54:37Z