title: MySQL INFORMATION_SCHEMA Bugged
body: <p>based on this post in phpmyadmin (that i am the owner)</p>
  <p>i dont know what happen with INFORMATION_SCHEMA Table.</p>
  <p><a href="https://github.com/phpmyadmin/phpmyadmin/issues/16378#issuecomment-703820551" rel="nofollow noreferrer">https://github.com/phpmyadmin/phpmyadmin/issues/16378#issuecomment-703820551</a></p>
  <p>I've been digging a bit deeper on the subject and it seems that everything points to a mysql server problem and the &quot;INFORMATION_SCHEMA&quot;.</p>
  <pre class="lang-sql prettyprint-override"><code>DROP TABLE IF EXISTS `Tbl_Lis_Agencias`;
  CREATE TABLE IF NOT EXISTS `Tbl_Lis_Agencias` (
    `IdAgency` int(3) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
    `AgencyCodU` int(3) UNSIGNED ZEROFILL NOT NULL DEFAULT '000',
    `AgencyName` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `Agency_Order` int UNSIGNED DEFAULT NULL,
    `AgencyStatus` int UNSIGNED NOT NULL DEFAULT '1',
    PRIMARY KEY (`IdAgency`),
    UNIQUE KEY `IdAgency` (`IdAgency`),
    UNIQUE KEY `Agency_Order` (`Agency_Order`),
    UNIQUE KEY `AgencyName` (`AgencyName`),
    KEY `xAgencyStatus` (`AgencyStatus`)
  ) ENGINE=InnoDB AUTO_INCREMENT=12345 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  INSERT INTO `Tbl_Lis_Agencias` VALUES
  (001, 001, 'Panama', 1, 1),
  (002, 020, 'Aguadulce', 2, 1),
  (003, 080, 'David', 3, 1),
  (004, 010, 'Vacamonte', 4, 1);
  </code></pre>
  <p><strong>I have used the Mysql WorkBench, to execute the following query:</strong></p>
  <pre class="lang-sql prettyprint-override"><code>SELECT `AUTO_INCREMENT`
  FROM  INFORMATION_SCHEMA.TABLES
  WHERE TABLE_SCHEMA = 'DB_LIS'
  AND   TABLE_NAME   = 'Tbl_Lis_Agencias';
  </code></pre>
  <p>**and output: no matter how many times you run the update of auto_increment to the value: 5 **</p>
  <pre class="lang-sql prettyprint-override"><code>ALTER TABLE Tbl_Lis_Agencias AUTO_INCREMENT =5;
  </code></pre>
  <p><img src="https://user-images.githubusercontent.com/1207306/95118958-cde2dc00-0710-11eb-898f-9af17a1ec431.png" alt="image" /></p>
  <p>but when i go to table option in tab option in software; not code:</p>
  <p><img src="https://user-images.githubusercontent.com/1207306/95119182-2b772880-0711-11eb-9c65-114039ec402a.png" alt="image" /></p>
  <p><img src="https://user-images.githubusercontent.com/1207306/95119277-55c8e600-0711-11eb-94ba-4390e070e8fd.png" alt="image" /></p>
  <p><strong>### this must be a joke ... what's going on here ???</strong></p>