Comments - CONNECT PIVOT Table Type
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.
Why might I be getting an "Access denied" message, even though I'm logged into MariaDB as root?
ERROR 1105 (HY000): (1045) Access denied for user 'root'@'localhost' (using password: NO)
This happens with the first example, using appropriate names from the database in USE:
"CREATE TABLE sa_general_journal_pivot ENGINE=connect TABLE_TYPE=pivot TABNAME=sa_general_journal;"
I face the same probleme. I lost some times on it... You need to :