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

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

    XMLWordPrintable

    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: