Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19650

Privilege bug on MariaDB 10.4

    XMLWordPrintable

Details

    Description

      When changing the "root" username to another value for more security, I'm loosing ability to see any users on my phpMyAdmin.

      When trying to access to the "mysql.user" table, I get the error "#1449 - The user specified as a definer ('root'@'localhost') does not exist" that was NOT appearing on MariaDB 10.3.

      This bug is appearing when changing the "root" username after a fresh install, or after an upgrade from a previous version.

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21486 Implement option for mysql_install_db that allows root@localhost to be replaced

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21487 Implement option for mysql_upgrade that allows root@localhost to be replaced

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21486 Implement option for mysql_install_db that allows root@localhost to be replaced

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22478 Bad error ER_VIEW_INVALID returned upon attempt to insert into mysql.user

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22486 mysql_secure_installation cannot work without root user in the database

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23373 Document mariadb.sys user

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21487 Implement option for mysql_upgrade that allows root@localhost to be replaced

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22477 mysql_upgrade fails with sql_notes=OFF

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-24568 MariaDB Documentation need to be updated with details for mariadb.sys user

          • Major - Major loss of function.
          • Closed

          Activity

            People

              sanja Oleksandr Byelkin
              cliXtar Mathieu REHO
              Votes:
              2 Vote for this issue
              Watchers:
              15 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 0d
                  0d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 5d 4h 10m
                  5d 4h 10m

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.