phpMyAdmin - config inc php configuration

Question

With this configuration i found the error        The phpMyAdmin configuration storage is not completely configured  some        extended features have been deactivated  To find out why click here    When click then the following error is found        cfg  Servers    i   users          not OK      cfg  Servers    i   usergroups         not ok      cfg  Servers    i   navigationhiding       not OK  cfg  Servers    i   savedsearches          not OK    lt  php       This is needed for cookie based authentication to encrypt password in    cookie      cfg  blowfish secret      xampp      YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH            Servers configuration      i   0         First server      i        Authentication type and info     cfg  Servers    i   auth type      config    cfg  Servers    i   user      root    cfg  Servers    i   password          cfg  Servers    i   extension      mysqli    cfg  Servers    i   AllowNoPassword     true   cfg  Lang             Bind to the localhost ipv4 address and tcp     cfg  Servers    i   host      127 0 0 1    cfg  Servers    i   connect type      tcp       User for advanced features     cfg  Servers    i   controluser      pma    cfg  Servers    i   controlpass          cfg  Servers    i   users      pma users    cfg  Servers    i   usergroups      pma usergroups        Advanced phpMyAdmin features     cfg  Servers    i   pmadb          cfg  Servers    i   navigationhiding      pma navigationhiding    cfg  Servers    i   pmadb      phpmyadmin    cfg  Servers    i   bookmarktable      pma bookmark    cfg  Servers    i   relation      pma relation    cfg  Servers    i   table info      pma table info    cfg  Servers    i   table coords      pma table coords    cfg  Servers    i   pdf pages      pma pdf pages    cfg  Servers    i   column info      pma column info    cfg  Servers    i   history      pma history    cfg  Servers    i   designer coords      pma designer coords    cfg  Servers    i   tracking      pma tracking    cfg  Servers    i   userconfig      pma userconfig    cfg  Servers    i   recent      pma recent    cfg  Servers    i   table uiprefs      pma table uiprefs          End of servers configuration        gt

User · Answer

for phpMyAdmin-4 8 5-all-languages copy content from config sample inc php into new file config inc php and  instead of      Authentication type     cfg  Servers    i   auth type      cookie      Server parameters     cfg  Servers    i   host      localhost    cfg  Servers    i   compress     false   cfg  Servers    i   AllowNoPassword     false    put the folowing content      Authentication type     cfg  Servers    i   auth type      config      Server parameters     cfg  Servers    i   host      localhost     cfg  Servers    i   user       your root mysql username    cfg  Servers    i   password       your pasword for root user to login into mysql     cfg  Servers    i   extension      mysqli    cfg  Servers    i   compress     false   cfg  Servers    i   AllowNoPassword     true    the rest remain commented an un-changed

User · Answer

Run This Query       gt  -- --------------------------------------------------------  gt  -- SQL Commands to set up the pmadb as described in the documentation   gt  --  gt  -- This file is meant for use with MySQL 5 and above   gt  --  gt  -- This script expects the user pma to already be existing  If we would put a  gt  -- line here to create him too many users might just use this script and end  gt  -- up with having the same password for the controluser   gt  --  gt  -- This user  pma  must be defined in config inc php  controluser controlpass   gt  --  gt  -- Please don t forget to set up the tablenames in config inc php  gt  --  gt    gt  -- --------------------------------------------------------  gt    gt  --  gt  -- Database    phpmyadmin   gt  -- CREATE DATABASE IF NOT EXISTS  phpmyadmin    DEFAULT CHARACTER SET utf8 COLLATE utf8 bin  USE phpmyadmin   gt    gt  -- --------------------------------------------------------  gt    gt  --  gt  -- Privileges  gt  --  gt  --  activate this statement if necessary   gt  -- GRANT SELECT  INSERT  DELETE  UPDATE  ALTER ON  phpmyadmin    TO  gt  --     pma  localhost   gt    gt  -- --------------------------------------------------------  gt    gt  --  gt  -- Table structure for table  pma  bookmark   gt  --  gt    gt  CREATE TABLE IF NOT EXISTS  pma  bookmark       id  int 10  unsigned  gt  NOT NULL auto increment     dbase  varchar 255  NOT NULL default        gt   user  varchar 255  NOT NULL default        label  varchar 255   gt  COLLATE utf8 general ci NOT NULL default        query  text NOT NULL    gt  PRIMARY KEY    id       COMMENT  Bookmarks    DEFAULT CHARACTER SET  gt  utf8 COLLATE utf8 bin   gt    gt  -- --------------------------------------------------------  gt    gt  --  gt  -- Table structure for table  pma  column info   gt  --  gt    gt  CREATE TABLE IF NOT EXISTS  pma  column info       id  int 5  unsigned  gt  NOT NULL auto increment     db name  varchar 64  NOT NULL default       gt   table name  varchar 64  NOT NULL default        column name   gt  varchar 64  NOT NULL default        comment  varchar 255  COLLATE  gt  utf8 general ci NOT NULL default        mimetype  varchar 255  COLLATE  gt  utf8 general ci NOT NULL default        transformation  varchar 255   gt  NOT NULL default        transformation options  varchar 255  NOT NULL  gt  default        input transformation  varchar 255  NOT NULL default      gt   input transformation options  varchar 255  NOT NULL default        gt  PRIMARY KEY    id      UNIQUE KEY  db name   gt    db name   table name   column name       COMMENT  Column information  gt  for phpMyAdmin    DEFAULT CHARACTER SET utf8 COLLATE utf8 bin   gt    gt  -- --------------------------------------------------------  gt    gt  --  gt  -- Table structure for table  pma  history   gt  --  gt    gt  CREATE TABLE IF NOT EXISTS  pma  history       id  bigint 20  unsigned  gt  NOT NULL auto increment     username  varchar 64  NOT NULL default      gt   db  varchar 64  NOT NULL default        table  varchar 64  NOT NULL  gt  default        timevalue  timestamp NOT NULL default  gt  CURRENT TIMESTAMP     sqlquery  text NOT NULL    PRIMARY KEY    id      gt  KEY  username    username   db   table   timevalue       COMMENT  SQL  gt  history for phpMyAdmin    DEFAULT CHARACTER SET utf8 COLLATE utf8 bin   gt    gt  -- --------------------------------------------------------  gt    gt  --  gt  -- Table structure for table  pma  pdf pages   gt  --  gt    gt  CREATE TABLE IF NOT EXISTS  pma  pdf pages       db name  varchar 64   gt  NOT NULL default        page nr  int 10  unsigned NOT NULL  gt  auto increment     page descr  varchar 50  COLLATE utf8 general ci NOT  gt  NULL default       PRIMARY KEY    page nr      KEY  db name   gt    db name       COMMENT  PDF relation pages for phpMyAdmin    DEFAULT  gt  CHARACTER SET utf8 COLLATE utf8 bin   gt    gt  -- --------------------------------------------------------  gt    gt  --  gt  -- Table structure for table  pma  recent   gt  --  gt    gt  CREATE TABLE IF NOT EXISTS  pma  recent       username  varchar 64   gt  NOT NULL     tables  text NOT NULL    PRIMARY KEY   username        gt  COMMENT  Recently accessed tables    DEFAULT CHARACTER SET utf8  gt  COLLATE utf8 bin   gt    gt  -- --------------------------------------------------------  gt    gt  --  gt  -- Table structure for table  pma  favorite   gt  --  gt    gt  CREATE TABLE IF NOT EXISTS  pma  favorite       username  varchar 64   gt  NOT NULL     tables  text NOT NULL    PRIMARY KEY   username        gt  COMMENT  Favorite tables    DEFAULT CHARACTER SET utf8 COLLATE  gt  utf8 bin   gt    gt  -- --------------------------------------------------------  gt    gt  --  gt  -- Table structure for table  pma  table uiprefs   gt  --  gt    gt  CREATE TABLE IF NOT EXISTS  pma  table uiprefs       username   gt  varchar 64  NOT NULL     db name  varchar 64  NOT NULL     table name   gt  varchar 64  NOT NULL     prefs  text NOT NULL     last update   gt  timestamp NOT NULL DEFAULT CURRENT TIMESTAMP ON UPDATE  gt  CURRENT TIMESTAMP    PRIMARY KEY   username   db name   table name      gt  COMMENT  Tables   UI preferences    DEFAULT CHARACTER SET utf8 COLLATE  gt  utf8 bin   gt    gt  -- --------------------------------------------------------  gt    gt  --  gt  -- Table structure for table  pma  relation   gt  --  gt    gt  CREATE TABLE IF NOT EXISTS  pma  relation       master db  varchar 64   gt  NOT NULL default        master table  varchar 64  NOT NULL default      gt   master field  varchar 64  NOT NULL default        foreign db   gt  varchar 64  NOT NULL default        foreign table  varchar 64  NOT  gt  NULL default        foreign field  varchar 64  NOT NULL default        gt  PRIMARY KEY    master db   master table   master field      KEY  gt   foreign field    foreign db   foreign table       COMMENT  Relation  gt  table    DEFAULT CHARACTER SET utf8 COLLATE utf8 bin   gt    gt  -- --------------------------------------------------------  gt    gt  --  gt  -- Table structure for table  pma  table coords   gt  --  gt    gt  CREATE TABLE IF NOT EXISTS  pma  table coords       db name   gt  varchar 64  NOT NULL default        table name  varchar 64  NOT NULL  gt  default        pdf page number  int 11  NOT NULL default  0      x   gt  float unsigned NOT NULL default  0      y  float unsigned NOT NULL  gt  default  0     PRIMARY KEY    db name   table name   pdf page number    gt      COMMENT  Table coordinates for phpMyAdmin PDF output    DEFAULT  gt  CHARACTER SET utf8 COLLATE utf8 bin   gt    gt  -- --------------------------------------------------------  gt    gt  --  gt  -- Table structure for table  pma  table info   gt  --  gt    gt  CREATE TABLE IF NOT EXISTS  pma  table info       db name  varchar 64   gt  NOT NULL default        table name  varchar 64  NOT NULL default        gt   display field  varchar 64  NOT NULL default       PRIMARY KEY   gt    db name   table name       COMMENT  Table information for  gt  phpMyAdmin    DEFAULT CHARACTER SET utf8 COLLATE utf8 bin   gt    gt  -- --------------------------------------------------------  gt    gt  --  gt  -- Table structure for table  pma  tracking   gt  --  gt    gt  CREATE TABLE IF NOT EXISTS  pma  tracking       db name  varchar 64   gt  NOT NULL     table name  varchar 64  NOT NULL     version  int 10   gt  unsigned NOT NULL     date created  datetime NOT NULL     gt   date updated  datetime NOT NULL     schema snapshot  text NOT NULL     gt   schema sql  text     data sql  longtext     tracking   gt  set  UPDATE   REPLACE   INSERT   DELETE   TRUNCATE   CREATE  gt  DATABASE   ALTER DATABASE   DROP DATABASE   CREATE TABLE   ALTER  gt  TABLE   RENAME TABLE   DROP TABLE   CREATE INDEX   DROP INDEX   CREATE  gt  VIEW   ALTER VIEW   DROP VIEW   default NULL     tracking active   gt  int 1  unsigned NOT NULL default  1     PRIMARY KEY   gt    db name   table name   version       COMMENT  Database changes  gt  tracking for phpMyAdmin    DEFAULT CHARACTER SET utf8 COLLATE  gt  utf8 bin   gt    gt  -- --------------------------------------------------------  gt    gt  --  gt  -- Table structure for table  pma  userconfig   gt  --  gt    gt  CREATE TABLE IF NOT EXISTS  pma  userconfig       username   gt  varchar 64  NOT NULL     timevalue  timestamp NOT NULL default  gt  CURRENT TIMESTAMP ON UPDATE CURRENT TIMESTAMP     config data  text  gt  NOT NULL    PRIMARY KEY    username       COMMENT  User preferences  gt  storage for phpMyAdmin    DEFAULT CHARACTER SET utf8 COLLATE utf8 bin   gt    gt  -- --------------------------------------------------------  gt    gt  --  gt  -- Table structure for table  pma  users   gt  --  gt    gt  CREATE TABLE IF NOT EXISTS  pma  users       username  varchar 64  NOT  gt  NULL     usergroup  varchar 64  NOT NULL    PRIMARY KEY  gt    username   usergroup       COMMENT  Users and their assignments to  gt  user groups    DEFAULT CHARACTER SET utf8 COLLATE utf8 bin   gt    gt  -- --------------------------------------------------------  gt    gt  --  gt  -- Table structure for table  pma  usergroups   gt  --  gt    gt  CREATE TABLE IF NOT EXISTS  pma  usergroups       usergroup   gt  varchar 64  NOT NULL     tab  varchar 64  NOT NULL     allowed   gt  enum  Y   N   NOT NULL DEFAULT  N     PRIMARY KEY  gt    usergroup   tab   allowed       COMMENT  User groups with configured  gt  menu items    DEFAULT CHARACTER SET utf8 COLLATE utf8 bin   gt    gt  -- --------------------------------------------------------  gt    gt  --  gt  -- Table structure for table  pma  navigationhiding   gt  --  gt    gt  CREATE TABLE IF NOT EXISTS  pma  navigationhiding       username   gt  varchar 64  NOT NULL     item name  varchar 64  NOT NULL     gt   item type  varchar 64  NOT NULL     db name  varchar 64  NOT NULL     gt   table name  varchar 64  NOT NULL    PRIMARY KEY  gt    username   item name   item type   db name   table name        gt  COMMENT  Hidden items of navigation tree    DEFAULT CHARACTER SET utf8  gt  COLLATE utf8 bin   gt    gt  -- --------------------------------------------------------  gt    gt  --  gt  -- Table structure for table  pma  savedsearches   gt  --  gt    gt  CREATE TABLE IF NOT EXISTS  pma  savedsearches       id  int 5   gt  unsigned NOT NULL auto increment     username  varchar 64  NOT NULL  gt  default        db name  varchar 64  NOT NULL default        gt   search name  varchar 64  NOT NULL default        search data  text  gt  NOT NULL    PRIMARY KEY    id      UNIQUE KEY  gt   u savedsearches username dbname    username   db name   search name    gt      COMMENT  Saved searches    DEFAULT CHARACTER SET utf8 COLLATE  gt  utf8 bin   gt    gt  -- --------------------------------------------------------  gt    gt  --  gt  -- Table structure for table  pma  central columns   gt  --  gt    gt  CREATE TABLE IF NOT EXISTS  pma  central columns       db name   gt  varchar 64  NOT NULL     col name  varchar 64  NOT NULL     col type   gt  varchar 64  NOT NULL     col length  text     col collation   gt  varchar 64  NOT NULL     col isNull  boolean NOT NULL     col extra   gt  varchar 255  default        col default  text    PRIMARY KEY  gt    db name   col name       COMMENT  Central list of columns    DEFAULT  gt  CHARACTER SET utf8 COLLATE utf8 bin   gt    gt  -- --------------------------------------------------------  gt    gt  --  gt  -- Table structure for table  pma  designer settings   gt  --  gt    gt  CREATE TABLE IF NOT EXISTS  pma  designer settings       username   gt  varchar 64  NOT NULL     settings data  text NOT NULL    PRIMARY KEY  gt    username       COMMENT  Settings related to Designer    DEFAULT  gt  CHARACTER SET utf8 COLLATE utf8 bin   gt    gt  -- --------------------------------------------------------  gt    gt  --  gt  -- Table structure for table  pma  export templates   gt  --  gt    gt  CREATE TABLE IF NOT EXISTS  pma  export templates       id  int 5   gt  unsigned NOT NULL AUTO INCREMENT     username  varchar 64  NOT NULL     gt   export type  varchar 10  NOT NULL     template name  varchar 64  NOT  gt  NULL     template data  text NOT NULL    PRIMARY KEY   id      UNIQUE  gt  KEY  u user type template    username   export type   template name    gt      COMMENT  Saved export templates    DEFAULT CHARACTER SET utf8  gt  COLLATE utf8 bin       Open This File     C  xampp phpMyAdmin config inc php     Clear and Past this Code      gt  ---------------------------------------------------------  lt  php        Debian local configuration file       This file overrides the settings  gt  made by phpMyAdmin interactive setup    utility        For example  gt  configuration see  gt   usr share doc phpmyadmin examples config default php gz       NOTE   gt  do not add security sensitive data to this file  like passwords      gt  unless you really know what you re doing  If you do  any user that can  gt    run PHP or CGI on your webserver will be able to read them  If you still    want to do this  make sure to properly secure the access to  gt  this file     also on the filesystem level              Server s   gt  configuration      i   0     The  cfg  Servers   array starts with  gt   cfg  Servers   1    Do not use  cfg  Servers   0      You can disable  gt  a server config entry by setting host to      i       Read  gt  configuration from dbconfig-common     gt  require   etc phpmyadmin config-db php       Configure according to  gt  dbconfig-common if enabled    if   empty  dbname      gt         Authentication type     gt       cfg  Servers    i   auth type      cookie    gt         Server parameters     gt      if  empty  dbserver    dbserver    localhost    gt       cfg  Servers    i   host      dbserver   gt      if   empty  dbport      gt           cfg  Servers    i   connect type      tcp    gt           cfg  Servers    i   port      dbport   gt         gt         cfg  Servers    i   compress     false   gt         Select mysqli if your server has it     gt       cfg  Servers    i   extension      mysqli    gt         Optional  User for advanced features     gt       cfg  Servers    i   controluser      dbuser   gt       cfg  Servers    i   controlpass      dbpass   gt         Optional  Advanced phpMyAdmin features     gt       cfg  Servers    i   pmadb      dbname   gt       cfg  Servers    i   bookmarktable      pma bookmark    gt       cfg  Servers    i   relation      pma relation    gt       cfg  Servers    i   table info      pma table info    gt       cfg  Servers    i   table coords      pma table coords    gt       cfg  Servers    i   pdf pages      pma pdf pages    gt       cfg  Servers    i   column info      pma column info    gt       cfg  Servers    i   history      pma history    gt       cfg  Servers    i   designer coords      pma designer coords    gt         Uncomment the following to enable logging in to passwordless accounts   gt         after taking note of the associated security risks      gt          cfg  Servers    i   AllowNoPassword     TRUE   gt         Advance to next server for rest of config     gt       i         Authentication type       cfg  Servers    i   auth type      cookie      Server parameters     gt   cfg  Servers    i   host      localhost      gt   cfg  Servers    i   connect type      tcp    gt     cfg  Servers    i   compress     false     Select mysqli if your  gt  server has it       cfg  Servers    i   extension      mysql       gt  Optional  User for advanced features        gt   cfg  Servers    i   controluser      pma       gt   cfg  Servers    i   controlpass      pmapass      Optional  Advanced  gt  phpMyAdmin features        cfg  Servers    i   pmadb      phpmyadmin    gt      cfg  Servers    i   bookmarktable      pma bookmark       gt   cfg  Servers    i   relation      pma relation       gt   cfg  Servers    i   table info      pma table info       gt   cfg  Servers    i   table coords      pma table coords       gt   cfg  Servers    i   pdf pages      pma pdf pages       gt   cfg  Servers    i   column info      pma column info       gt   cfg  Servers    i   history      pma history       gt   cfg  Servers    i   designer coords      pma designer coords       gt  Uncomment the following to enable logging in to passwordless accounts   gt    after taking note of the associated security risks         cfg  Servers    i   AllowNoPassword     TRUE        End of servers  gt  configuration           Directories for saving loading files from  gt  server      cfg  UploadDir          cfg  SaveDir          ------------------------------------------   i Solve My Problem Through this Method

User · Answer

Have a look at config sample inc php  you will find examples of the configuration directives that you should copy to your config inc php  copy the missing ones   Then  have a look at examples create tables sql which will help you create the missing tables   The complete documentation for this is available at http   docs phpmyadmin net en latest setup html phpmyadmin-configuration-storage

User · Answer

Do Ctrl alt t and then    sudo chmod 777  opt lampp phpmyadmin config inc php open config inc php test   change config to cookie  cfg  Servers    i   auth type      config   donot change this  cfg  Servers    i   user      root   change    to  root   cfg  Servers    i   password          save config inc php  sudo chmod 644  opt lampp phpmyadmin config inc php restart the xampp and check phpmyadmin   If it works i think i am glad to help you

User · Answer

I found that the new version of PhpMyAdmin put the  config inc php  files in   var lib phpmyadmin   I spend much time in the wrong dir   usr share  as this is where all the files also is located  but changes are not reflected   After putting my settings in    var lib phpmyadmin config inc php   They worked

User · Answer

I had the same problem for days until I noticed  how could I look at it and not read the code  -     that config inc php is calling config-db php     MySql Server version  5 7 5-m15    Apache 2 4 10  Ubuntu     phpMyAdmin 4 2 9 1deb0 1   etc phpmyadmin config-db php    dbuser  yourDBUserName    dbpass      basepath      dbname  phpMyAdminDBName    dbserver      dbport      dbtype  mysql     Here you need to define your username  password  dbname and others that are showing empty  use default unless you changed their configuration  That solved the issue for me  U hope it helps you  latest phpmyadmin docs

[phpmyadmin] phpMyAdmin - config.inc.php configuration?

Examples related to phpmyadmin