Query Failed - check grafana server logs

First off, thank you for taking the time to read this post, and if this is the wrong category, please let me know so that I delete it and repost it in the proper one. I am a first time grafana user and I’ve been following the documentation closely to connect a data source on a dummy server in order to try out grafana. The issue I am facing relates to connecting a MySQL data source, despite quadriple checking that the info on the config matches. The logs are not helpful, hence why I’m here.

  • What Grafana version and what operating system are you using?
    Grafana v10.2.2
  • What are you trying to achieve?
    Connect a data source (MySQL)
  • How are you trying to achieve it?
    I installed grafana locally on my server, accessed port 3000 and used the GUI
  • What happened?
    I got a vague error: “query failed - please inspect Grafana server log for details”. I checked the logs, but it wasn’t very helpful. The only thing worth noting from the log is the following:

logger=sqlstore.transactions t=2024-03-14T08:17:46.954116153Z level=info msg="Database locked, sleeping then retrying" error="database is locked" retry=0 code="database is locked"

  • What did you expect to happen?
    For the connection to be successfully added since all the fields are filled with the exact information as found in the config.

  • Can you copy/paste the configuration(s) that you are having problems with?
    If that’s absolutely necessary, I can do that (but the information will be blurred out, so I’m not sure how this will help?)

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

logger=sqlstore.transactions t=2024-03-14T08:12:46.969088252Z level=info msg=“Database locked, sleeping then retrying” error=“database is locked” retry=0 code=“database is locked”
logger=plugins.update.checker t=2024-03-14T08:12:47.024385111Z level=info msg=“Update check succeeded” duration=29.666222ms
logger=grafana.update.checker t=2024-03-14T08:12:47.063959309Z level=info msg=“Update check succeeded” duration=41.163365ms
logger=sqlstore.transactions t=2024-03-14T08:17:46.954116153Z level=info msg=“Database locked, sleeping then retrying” error=“database is locked” retry=0 code=“database is locked”
logger=cleanup t=2024-03-14T08:22:46.976419529Z level=info msg=“Completed cleanup jobs” duration=18.098583ms

It is worth mentioning I am running mariaDB, but based on my research it shouldn’t really make a difference. Please let me know if I’m wrong, and once again I appreciate your time and effort.