The Ultimate Guide to High Availability with MariaDB

Comments - CONNECT PIVOT Table Type

4 years ago Gilles Sierra
Re: CONNECT Table Types - PIVOT Table Type

I face the same probleme. I lost some times on it... You need to :

  1. be sure that the user is able to access to your table 'sa_general_journal' with a host 'localhost' (not only 127.0.1.1)
  2. add option_list='user=[your user],password=[user password]' at the end of your create table query
 
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.