The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

creating pivot table fails

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 Sergei Golubchik 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.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.