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

cannot get grant for user

    XMLWordPrintable

Details

    Description

      MariaDB [(none)]> select user,host,password from mysql.user;
      +------------------------+------------------+-------------------------------------------+
      | user                   | host             | password                                  |
      +------------------------+------------------+-------------------------------------------+
      | root                   | hb01-mariacart01 | *60A016B4E2D64B7A468635B5CF730D43D241C345 |
      +------------------------+------------------+-------------------------------------------+
      45 rows in set (0.00 sec)
       
      MariaDB [(none)]> show grants for root@'hb01-mariacart01';
      ERROR 1141 (42000): There is no such grant defined for user 'root' on host 'hb01-mariacart01'
       
       
      MariaDB [(none)]> show global variables like 'skip%';
      +-----------------------+-------+
      | Variable_name         | Value |
      +-----------------------+-------+
      | skip_name_resolve     | ON    |
      +-----------------------+-------+
      4 rows in set (0.00 sec)
      

      But with this I saw I got some other user@host and it's work with it.

      Attachments

        Activity

          People

            Unassigned Unassigned
            Aurelien_LEQUOY Aurélien LEQUOY
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.