maria-discuss team mailing list archive

[AskMonty KB <noreply@xxxxxxxxxxxx>]

Hello,

A new question has been asked in "CONNECT Table Types" by nobswolf:
--------------------------------
I tried to create a pivot table based on an existing table "test1" and get an error. I am logged in and I can use "test1", so this error makes no sense to me. What I am doing wrong? Any hints?


MariaDB [nav]> create table xsort engine=connect table_type=pivot tabname=test1;

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

MariaDB [nav]>
--------------------------------

To view or answer this question please visit: http://mariadb.com/kb/en/creating-pivot-table-fails/