Comments - CONNECT PIVOT Table Type

7 years, 1 month ago Jan Steinman

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;"

2 years, 3 months ago Gilles Sierra

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