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

mariadb-dump to stop using mysql.user view

    XMLWordPrintable

Details

    Description

      From https://bugzilla.opensuse.org/show_bug.cgi?id=1227109

      kostunrix:~ # mysqldump --system=users
      /*!999999\- enable the sandbox mode */
      -- MariaDB dump 10.19  Distrib 10.11.8-MariaDB, for Linux (x86_64)
      ...
      mysqldump: Couldn't execute 'SELECT CONCAT(QUOTE(u.user), '@', QUOTE(u.Host)) AS u FROM mysql.user u  /*!80001 LEFT JOIN mysql.role_edges e             ON u.user=e.from_user               AND u.host=e.from_host          WHERE e.from_user IS NULL */ /*M!100005 WHERE is_role='N' */': Illegal mix of collations (utf8mb4_unicode_520_ci,COERCIBLE) and (utf8mb4_general_ci,COERCIBLE) for 
      

      Attachments

        Issue Links

          Activity

            People

              danblack Daniel Black
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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