New Question
 
 
PRTG Network Monitor

Intuitive to Use.
Easy to manage.

200.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free PRTG
Download >>

 

What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

 

Top Tags


View all Tags


PRTG unable to connect to MySQL

Votes:

0

Your Vote:

Up

Down

Hi, I am trying to configure sensor to Mysql on default port with specific user id and password. But during discovery I am getting "unable to connect to any of the specified Mysql hosts".

Please help.

mysql mysql-v2-sensor prtg-network-monitor

Created on Oct 9, 2018 11:57:54 AM by  Nandish Basavaraj Talikotimath (2) 1



9 Replies

Votes:

0

Your Vote:

Up

Down

Is the PRTG Server itself allowed to connect via this IP? Is a different SQL Client (like HeidiSQL or SQLyog) able to connect?


PRTG Scheduler | PRTGapi | Feature Requests | WMI Issues | SNMP Issues

Kind regards,
Stephan Linke, Tech Support Team

Created on Oct 9, 2018 2:59:36 PM by  Stephan Linke [Paessler Support]



Votes:

0

Your Vote:

Up

Down

Yes, PRTG is allowed to connect. I am able to connect to MS SQL Server without any issues.

Created on Oct 10, 2018 6:12:27 AM by  Nandish Basavaraj Talikotimath (2) 1



Votes:

0

Your Vote:

Up

Down

Are you using Kerberos or SQL authentication? If the former, did you configure the Windows credentials accordingly? If the latter, please make sure that database credentials are entered and that there's no domain configured in the Windows authentication section. Also ensure that the port is configured correctly within the sensor.


PRTG Scheduler | PRTGapi | Feature Requests | WMI Issues | SNMP Issues

Kind regards,
Stephan Linke, Tech Support Team

Created on Oct 10, 2018 6:29:14 AM by  Stephan Linke [Paessler Support]



Votes:

0

Your Vote:

Up

Down

I am using SQL Authentication for Mysql with userid and password. Port is default Mysql 3306

Created on Oct 10, 2018 8:55:40 AM by  Nandish Basavaraj Talikotimath (2) 1



Votes:

0

Your Vote:

Up

Down

What is it now, MSSQL or MySQL? Since you referred to MS SQL in your previous post :)


PRTG Scheduler | PRTGapi | Feature Requests | WMI Issues | SNMP Issues

Kind regards,
Stephan Linke, Tech Support Team

Created on Oct 10, 2018 9:01:48 AM by  Stephan Linke [Paessler Support]



Votes:

0

Your Vote:

Up

Down

In previous post I mentioned able to connect to MSSQL but not able to make connections to MySQL. Its Mysql which is having this issues. "unable to connect to any of the specified Mysql hosts"

Created on Oct 10, 2018 9:12:55 AM by  Nandish Basavaraj Talikotimath (2) 1



Votes:

0

Your Vote:

Up

Down

Its MySQL issue. Previous post mentioned that I am successfully able to make connections to MS SQL Server. The current issue in on MySQL

Created on Oct 10, 2018 9:16:55 AM by  Nandish Basavaraj Talikotimath (2) 1



Votes:

0

Your Vote:

Up

Down

These are two very different things. Please try a MySQL client on the PRTG Server and see if it can connect successfully to the MySQL database.


PRTG Scheduler | PRTGapi | Feature Requests | WMI Issues | SNMP Issues

Kind regards,
Stephan Linke, Tech Support Team

Created on Oct 10, 2018 9:45:48 AM by  Stephan Linke [Paessler Support]



Votes:

0

Your Vote:

Up

Down

Please mark the this as closed. Was able to fix the issue.

Created on Oct 10, 2018 9:49:09 AM by  Nandish Basavaraj Talikotimath (2) 1



Please log in or register to enter your reply.


Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.