{"id":96,"date":"2018-12-22T16:31:36","date_gmt":"2018-12-22T08:31:36","guid":{"rendered":"http:\/\/itrapt.com\/blog\/?p=96"},"modified":"2018-12-22T16:33:14","modified_gmt":"2018-12-22T08:33:14","slug":"setting-up-phpmyadmin-configuration-storage-on-a-synology-diskstation","status":"publish","type":"post","link":"https:\/\/itrapt.com\/blog\/setting-up-phpmyadmin-configuration-storage-on-a-synology-diskstation\/","title":{"rendered":"Setting Up phpMyAdmin Configuration Storage on a Synology DiskStation"},"content":{"rendered":"

Setting Up phpMyAdmin Configuration Storage:<\/p>\n

    \n
  1. Import create_tables.sql from phpMyAdmin’s examples folder to MySQL. When upgrading from a previous phpMyAdmin installation then import upgrade_tables_mysql_4_1_2+.sql before importing create_tables.sql.<\/li>\n
  2. Create user `pma` and grant access to the database `phpmyadmin` GRANT SELECT, INSERT, UPDATE, DELETE ON `phpmyadmin`.* TO ‘pma’@’localhost’;<\/li>\n
  3. Uncomment phpMyAdmin configuration storage settings in config.inc.php\/*
    \n\/* Storage database and tables *\/
    \n$cfg[‘Servers’][$i][‘pmadb’] = ‘phpmyadmin’;
    \n$cfg[‘Servers’][$i][‘bookmarktable’] = ‘pma__bookmark’;
    \n$cfg[‘Servers’][$i][‘relation’] = ‘pma__relation’;
    \n$cfg[‘Servers’][$i][‘table_info’] = ‘pma__table_info’;
    \n$cfg[‘Servers’][$i][‘table_coords’] = ‘pma__table_coords’;
    \n$cfg[‘Servers’][$i][‘pdf_pages’] = ‘pma__pdf_pages’;
    \n$cfg[‘Servers’][$i][‘column_info’] = ‘pma__column_info’;
    \n$cfg[‘Servers’][$i][‘history’] = ‘pma__history’;
    \n$cfg[‘Servers’][$i][‘table_uiprefs’] = ‘pma__table_uiprefs’;
    \n$cfg[‘Servers’][$i][‘tracking’] = ‘pma__tracking’;
    \n$cfg[‘Servers’][$i][‘userconfig’] = ‘pma__userconfig’;
    \n$cfg[‘Servers’][$i][‘recent’] = ‘pma__recent’;
    \n$cfg[‘Servers’][$i][‘favorite’] = ‘pma__favorite’;
    \n$cfg[‘Servers’][$i][‘users’] = ‘pma__users’;
    \n$cfg[‘Servers’][$i][‘usergroups’] = ‘pma__usergroups’;
    \n$cfg[‘Servers’][$i][‘navigationhiding’] = ‘pma__navigationhiding’;
    \n$cfg[‘Servers’][$i][‘savedsearches’] = ‘pma__savedsearches’;
    \n$cfg[‘Servers’][$i][‘central_columns’] = ‘pma__central_columns’;<\/li>\n
  4. That’s it! Begin saving your configuration.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    Setting Up phpMyAdmin Configuration Storage: Import create_tables.sql from phpMyAdmin’s examples folder to MySQL. When upgrading from a previous phpMyAdmin installation then import upgrade_tables_mysql_4_1_2+.sql before importing create_tables.sql. Create user `pma` and grant access to the database `phpmyadmin` GRANT SELECT, INSERT, UPDATE, DELETE ON `phpmyadmin`.* TO ‘pma’@’localhost’; Uncomment phpMyAdmin configuration storage settings in config.inc.php\/* \/* Storage database […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":""},"categories":[62],"tags":[61,60,58,59],"_links":{"self":[{"href":"https:\/\/itrapt.com\/blog\/wp-json\/wp\/v2\/posts\/96"}],"collection":[{"href":"https:\/\/itrapt.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itrapt.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itrapt.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itrapt.com\/blog\/wp-json\/wp\/v2\/comments?post=96"}],"version-history":[{"count":4,"href":"https:\/\/itrapt.com\/blog\/wp-json\/wp\/v2\/posts\/96\/revisions"}],"predecessor-version":[{"id":132,"href":"https:\/\/itrapt.com\/blog\/wp-json\/wp\/v2\/posts\/96\/revisions\/132"}],"wp:attachment":[{"href":"https:\/\/itrapt.com\/blog\/wp-json\/wp\/v2\/media?parent=96"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itrapt.com\/blog\/wp-json\/wp\/v2\/categories?post=96"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itrapt.com\/blog\/wp-json\/wp\/v2\/tags?post=96"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}