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

Privilege bug on MariaDB 10.4

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

            Transition Time In Source Status Execution Times
            Sergei Golubchik made transition -
            Open Closed
            		66d 13h 52m 1
            Elena Stepanova made transition -
            Closed Stalled
            		137d 4h 11m 1
            Oleksandr Byelkin made transition -
            Stalled In Progress
            		60d 21h 52m 2
            Oleksandr Byelkin made transition -
            In Progress In Review
            		15d 57m 2
            Sergei Golubchik made transition -
            In Review Stalled
            		60d 20h 57m 2
            Sergei Golubchik made transition -
            Stalled Closed
            		3d 2h 59m 1

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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