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

Pivot throws 'Access denied for user'

    XMLWordPrintable

    Details

      Description

      I am not able to run:

      create table xpivot1
      engine=connect table_type=PIVOT
      option_list='PivotCol=FirstLetter,FncCol=cnt'
      Srcdef='select table_type, left(table_name,1) as FirstLetter , count(table_type) as cnt from tables group by 1, 2';

      The query returns an error:

      SQL error (1105): (1045) Access denied for user 'root'@'localhost' (using password: NO) 
      

      , while root is still connected.

      If I run the query from the command line, the same error reveals.

        Attachments

          Activity

            People

            Assignee:
            bertrandop Olivier Bertrand
            Reporter:
            radimmachu Radim Machů
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated: