Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9989

(1045) Access denied for user 'root password=admin'@'localhost' (using password: NO)

    Details

      Description

      /* Error occurs at the end of this example */
      DROP TABLE IF EXISTS visitors;
      CREATE TABLE visitors (
      	año CHAR(4) NOT NULL,
      	Jan INT(10) NOT NULL DEFAULT 0,
      	Feb INT(10) NOT NULL DEFAULT 0,
      	Mar INT(10) NOT NULL DEFAULT 0,
      	Apr INT(10) NOT NULL DEFAULT 0,
      	May INT(10) NOT NULL DEFAULT 0,
      	Jun INT(10) NOT NULL DEFAULT 0,
      	Jul INT(10) NOT NULL DEFAULT 0,
      	Aug INT(10) NOT NULL DEFAULT 0,
      	Sep INT(10) NOT NULL DEFAULT 0, 
      	_Oct INT(10) NOT NULL DEFAULT 0,
      	Nov INT(10) NOT NULL DEFAULT 0,
      	Dic INT(10) NOT NULL DEFAULT 0 
      ) ENGINE = CONNECT;
      INSERT INTO visitors VALUES
      ('2015', 121, 172, 199, 181, 108, 199, 171, 156, 170, 183, 105, 176),
      ('2014', 167, 108, 137, 161, 198, 104, 129, 132, 172, 167, 119, 196),
      ('2013', 120, 116, 117, 140, 148, 119, 154, 112, 101, 166, 131, 156),
      ('2012', 189, 175, 112, 132, 127, 141, 121, 186, 165, 169, 148, 136),
      ('2011', 134, 162, 108, 158, 163, 144, 129, 116, 193, 117, 105, 176);
      DROP TABLE IF EXISTS xvisitors;
      CREATE TABLE xvisitors (
      	año CHAR(4) NOT NULL, 
      	_month CHAR(3) NOT NULL,
      	number INT(10) NOT NULL
      ) ENGINE=CONNECT TABLE_TYPE=OCCUR
      tabname=visitors
      option_list='OccurCol=number,RankCol=_month'
      Colist='Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,_Oct,Nov,Dic';
       
      SELECT * FROM xvisitors;
      DROP TABLE IF EXISTS xvisitors2;
      CREATE TABLE xvisitors2 (
      	_year char(4) NOT NULL,
      	_month char(4) NOT NULL,
      	number int(10) NOT NULL
      	) engine = CONNECT;
      INSERT INTO xvisitors2 SELECT * FROM xvisitors;
      /*error occurs in the following line*/
      CREATE TABLE pvisitors ENGINE=CONNECT TABLE_TYPE=PIVOT
      TABNAME=xvisitors2 Option_list='user=root password=admin';
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              gsalinasc Manuel G Salinas Carpio
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: