Ad Widget

Collapse

Zabbix 6.4 problem: can't connect to database MYSQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • djé13
    Junior Member
    • Mar 2023
    • 2

    #1

    Zabbix 6.4 problem: can't connect to database MYSQL

    I recently created a zabbix via this tuto: https://www.layerstack.com/resources...IX-on-Ubuntu22 everything works until I accidentally delete zabbix-agent from my zabbix server and I launch the updates on it (apt update /upgrade) since I have this error message.

    Error Message

    I also have a problem of access to the MySQL database via terminal, I think of a problem of password but it is impossible to reset it via mysqld_safe --skip-grant-tables If you have any ideas I'm interested.

    error message2

    error message3

    Thanks in advance
  • cyber
    Senior Member
    Zabbix Certified SpecialistZabbix Certified Professional
    • Dec 2006
    • 4807

    #2
    Deleted whole db awell? Can you log in as root to mysql and see what DB-s are present and what users are present..?

    Comment

    • djé13
      Junior Member
      • Mar 2023
      • 2

      #3
      Hello, by editing the file /etc/mysql/my.cnf and adding the following commands:
      [mysqld]
      skip-grant-tables
      skip-networking

      I could make my zabbix work but if I remove these lines nothing works anymore




      Comment

      Working...