PMA_PMADB not work in docker

[EngAly]

I try to show the bookmark feature in PHPMyAdmin but not appear.

docker-compose.yml

version: '2.3'
services:

 mysql:
   image: mysql
   container_name: mysql
   restart: always
   ports:
     - "3306:3306"
   volumes:
     - ./mysql:/var/lib/mysql
   environment:
      MYSQL_DATABASE: test
      # MYSQL_USER: root
      MYSQL_PASSWORD: root
      MYSQL_ROOT_PASSWORD: root
      SERVICE_TAGS: dev
      SERVICE_NAME: mysql
 phpmyadmin:
   image: phpmyadmin/phpmyadmin:5.1.1
   restart: always
   container_name: phpmyadmin
   depends_on:
     - mysql
   ports:
     - "80:80"
   environment:
     PMA_HOST: mysql
     PMA_PMADB: phpmyadmin
     MYSQL_ROOT_PASSWORD: root
     UPLOAD_LIMIT: 1G
     # MAX_LIFE_TIME: 100000
     MAX_EXECUTION_TIME: 100000

[williamdes]

Hi @EngAly

Be sure to use the official image even if it still works with ours image: phpmyadmin:5.1.1

Does the homepage give you an error or a warning about phpMyAdmin storage ?

[EngAly]

yes, it gives me an error.

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why. Or alternately go to 'Operations' tab of any database to set it up there.

$cfg['Servers'][$i]['pmadb'] ...	OK

not OK General relation features: Disabled   not OK Display Features: Disabled   not OK not OK Designer and creation of PDFs: Disabled   not OK Displaying Column Comments: Disabled Browser transformation: Disabled   not OK Bookmarked SQL query: Disabled   not OK SQL history: Disabled   not OK Persistent recently used tables: Disabled   not OK Persistent favorite tables: Disabled   not OK Persistent tables' UI preferences: Disabled   not OK Tracking: Disabled   not OK User preferences: Disabled   not OK not OK Configurable menus: Disabled   not OK Hide/show navigation items: Disabled   not OK Saving Query-By-Example searches: Disabled   not OK Managing Central list of columns: Disabled   not OK Remembering Designer Settings: Disabled   not OK Saving export templates: Disabled   Quick steps to set up advanced features:

• Create the needed tables with the /var/www/html/sql/create_tables.sql.
• Create a pma user and give access to these tables.
• Enable advanced features in configuration file (config.inc.php), for example by starting from config.sample.inc.php.
• Re-login to phpMyAdmin to load the updated configuration file.

[williamdes]

Thank you, FYI I am keeping this open so I investigate

[williamdes]

Hi @EngAly

I did pull and run you example. Login to root and click on fix tables and it works. I also tried the file method and it did work too.

Let me know

So I think you would need to define PMA_CONTROLUSER and PMA_CONTROLPASS because you said you did follow "Create a pma user and give access to these tables."

[williamdes]

The changes made in #16906 will certainly improve any issues you had with fixing tables. I would recommend that you subscribe to releases using the custom watch option on this page

Let us know