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]>

Answer Answered by serg in this comment.

if you think it's a bug, please, report it on mariadb.org/jira and you can expect it to be fixed in the next version.

Comments

Comments loading...