{"id":6992,"date":"2022-12-22T11:53:06","date_gmt":"2022-12-22T06:23:06","guid":{"rendered":"https:\/\/pheonixsolutions.com\/blog\/?p=6992"},"modified":"2026-11-03T11:42:17","modified_gmt":"2026-11-03T06:12:17","slug":"how-to-reset-the-zabbix-admin-password-by-using-mysql-on-ubuntu","status":"publish","type":"post","link":"https:\/\/pheonixsolutions.com\/blog\/how-to-reset-the-zabbix-admin-password-by-using-mysql-on-ubuntu\/","title":{"rendered":"How to Reset Zabbix Admin Password Using MySQL on Ubuntu"},"content":{"rendered":"\n

Post Date:<\/strong><\/strong> December 22, 2022
Last Updated:<\/strong> <\/strong>November 03, 2026<\/p>\n\n\n\n

Introduction<\/h2>\n\n\n\n

Zabbix<\/a> is an open-source monitoring solution used to monitor servers, network devices, virtual machines, cloud services, and other IT infrastructure components. It helps system administrators monitor essential performance metrics, including CPU utilization, memory usage, disk space, network traffic, and system availability.<\/p>\n\n\n\n

Sometimes, administrators may lose access to the Zabbix web interface after forgetting their login credentials. In such situations, you can reset the Zabbix Admin password<\/strong> directly through the MySQL database to restore administrator access without using the web interface.<\/p>\n\n\n\n

In this guide, we will explain how to reset Zabbix Admin password using MySQL on Ubuntu<\/strong> with step-by-step instructions. We will also cover database identification, password hash updates, and how to securely access the Zabbix monitoring dashboard after resetting the password.<\/p>\n\n\n\n

Prerequisites<\/h2>\n\n\n\n

Before resetting the Zabbix administrator password, ensure that you have:<\/p>\n\n\n\n

    \n
  1. Root or sudo access to the Ubuntu server.<\/li>\n\n\n\n
  2. MySQL or MariaDB database access with sufficient privileges.<\/li>\n\n\n\n
  3. Access to the Zabbix database.<\/li>\n\n\n\n
  4. The Zabbix database name and configuration details.<\/li>\n\n\n\n
  5. A recent backup of the Zabbix database.<\/li>\n<\/ol>\n\n\n\n

    Important:<\/strong> The SQL procedure below uses the password hash documented by Zabbix. It resets the administrator password to zabbix<\/code>. You must change this default password immediately after logging in.<\/p>\n\n\n\n

    Implementation<\/h2>\n\n\n\n

    Step 1: Log in to the Ubuntu Server<\/h3>\n\n\n\n

    First, connect to your Ubuntu server using SSH:<\/p>\n\n\n\n

    ssh root@YOUR_SERVER_IP<\/pre>\n\n\n\n
    Replace YOUR_SERVER_IP<\/code> with your actual server IP address.<\/p>\n\n\n\n
    If you are using a non-root account, connect using:<\/p>\n\n\n\n
    ssh username@YOUR_SERVER_IP<\/pre>\n\n\n\n
    Step 2: Identify the Zabbix Database<\/h3>\n\n\n\n
    Before making database changes, identify the database configured for your Zabbix server.<\/p>\n\n\n\n
    Check the Zabbix server configuration:<\/p>\n\n\n\n
    sudo grep -E '^(DBName|DBUser|DBHost)=' \/etc\/zabbix\/zabbix_server.conf<\/pre>\n\n\n\n
    The output will display the configured database name and connection details.<\/p>\n\n\n\n
    For example:<\/p>\n\n\n\n
    DBName=zabbix\nDBUser=zabbix\nDBHost=localhost<\/pre>\n\n\n\n
    In this example, the database name is zabbix<\/code>.<\/p>\n\n\n\n
    Note:<\/strong> If your Zabbix installation uses a different configuration file or a separate frontend database configuration, verify the database settings before proceeding.<\/p>\n\n\n\n
    Step 3: Back Up the Zabbix Database<\/h3>\n\n\n\n
    Before updating the administrator password, create a database backup.<\/p>\n\n\n\n
    Run the following command:<\/p>\n\n\n\n
    mysqldump -u root -p zabbix > zabbix_backup.sql<\/pre>\n\n\n\n
    Enter your MySQL root password when prompted.<\/p>\n\n\n\n
    Replace zabbix<\/code> with your actual database name if it is different.<\/p>\n\n\n\n
    The backup helps you recover the database if an unexpected issue occurs.<\/p>\n\n\n\n
    Step 4: Log in to MySQL<\/h3>\n\n\n\n
    Connect to the MySQL database using an account with permission to update the Zabbix database.<\/p>\n\n\n\n
    mysql -u root -p<\/pre>\n\n\n\n
    Enter your MySQL password to access the MySQL command-line interface.<\/p>\n\n\n\n
    Alternatively, connect directly to the Zabbix database:<\/p>\n\n\n\n
    mysql -u root -p zabbix<\/pre>\n\n\n\n
    \"Zabbix<\/figure>\n\n\n\n
    Step 5: Select the Zabbix Database<\/h3>\n\n\n\n
    If you have not already connected directly to the database, select the Zabbix database:<\/p>\n\n\n\n
    USE zabbix;<\/pre>\n\n\n\n
    You should receive a confirmation that the database has been selected.<\/p>\n\n\n\n
    Replace zabbix<\/code> with your actual database name if necessary.<\/p>\n\n\n\n
    \"Selecting<\/a><\/figure>\n\n\n\n
    Step 6: Verify the Zabbix Admin Account<\/p>\n\n\n\n
    Before updating the password, verify that the administrator account exists.<\/p>\n\n\n\n
    For modern Zabbix versions, execute:<\/p>\n\n\n\n
    SELECT userid, username FROM users WHERE username = 'Admin';<\/pre>\n\n\n\n
    The query should return the administrator account.<\/p>\n\n\n\n
    Note:<\/strong> Modern Zabbix versions use the username<\/code> column. Older Zabbix installations may use a different database schema..<\/p>\n\n\n\n
    Step 7: Reset the Zabbix Admin Password<\/h3>\n\n\n\n
    Now, execute the following SQL query to reset the administrator password:<\/p>\n\n\n\n
    UPDATE users\nSET passwd = '$2a$10$ZXIvHAEP2ZM.dLXTm6uPHOMVlARXX7cqjbhM6Fn0cANzkCQBWpMrS'\nWHERE username = 'Admin';<\/pre>\n\n\n\n
    This is the official bcrypt hash provided in the Zabbix password-reset documentation.<\/p>\n\n\n\n
    After executing the query, the administrator password will be reset to:<\/p>\n\n\n\n
    Username: Admin\nPassword: zabbix<\/pre>\n\n\n\n
    Check the query result to confirm that one administrator record was updated.<\/p>\n\n\n\n
    Step 8: Verify the Password Update<\/h3>\n\n\n\n
    Run the following query to verify that the administrator account exists:<\/p>\n\n\n\n
    SELECT userid, username FROM users WHERE username = 'Admin';<\/pre>\n\n\n\n
    If the account is returned and the update affected the intended record, the database password reset is complete.<\/p>\n\n\n\n
    Step 9: Exit MySQL<\/h3>\n\n\n\n
    After completing the database update, exit the MySQL command-line interface:<\/p>\n\n\n\n
    EXIT;\n<\/pre>\n\n\n\n
    Step 10: Log in to the Zabbix Web Interface<\/h3>\n\n\n\n
    Open your browser and access the Zabbix frontend:<\/p>\n\n\n\n
    http:\/\/YOUR_SERVER_IP\/zabbix<\/pre>\n\n\n\n
    If your installation uses a domain name or a different frontend URL, use the appropriate address.<\/p>\n\n\n\n
    Enter the following login credentials:<\/p>\n\n\n\n
    \"Reset<\/a><\/figure>\n\n\n\n
    Username: Admin\nPassword: zabbix<\/pre>\n\n\n\n
    After successful authentication, navigate to the user profile settings and change the default password to a strong, unique password.<\/p>\n\n\n\n
    Security recommendation:<\/strong> Never continue using the default password after completing the recovery process.<\/p>\n\n\n\n
    Important Security Considerations<\/h2>\n\n\n\n
    When resetting the Zabbix administrator password through MySQL, follow these security recommendations:<\/p>\n\n\n\n