How to track MySQL errors, timeouts and login attempts?

Question

When configuring a third-party CMS (Sitefinity) of a third party, the installation does not create all the tables and procedures necessary to run it. There is no registration system in the software, and this made me wonder: is it possible to track and track errors of SQL queries from MySQL?

This is not only the goal of solving my problem with Sitefinity. Most often, I am interested in what to send to the MySQL server, not wanting to dive into software products or configure the debugging environment, etc.

I tried JetProfiler (performance only) and looked at a few others , but although they track a lot, they do not track request failures, timeouts, or login attempts. Does anyone know a profiler, tracer, monitoring tool, commercial or free, that can show me this information?

Answer 1

Give up Kontrollbase - it keeps track of everything you might want for MySQL servers, including failed connections, disconnected connections, etc. It has over 50 different graphs, performance tuning reports, advanced analytic usage reports, security checks and much more. It is also 100% FREE. http://kontrollsoft.com/software-kontrollbase

There, an online demo is available at the same link on the page as above. Check this!