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.
Note that if your database is password-protected (as it should be) you will need to enter the password into the table definition (see previous comments).
This is a security issue: the password is saved without encryption and can be read by any user who can run SHOW CREATE TABLE on the pivot table. If there is an SQL injection vulnerability in your application, someone could therefore find the database password.