{"id":2196,"date":"2015-10-02T15:25:06","date_gmt":"2015-10-02T13:25:06","guid":{"rendered":"https:\/\/adrhc.go.ro\/wordpress\/?p=2196"},"modified":"2017-05-11T09:48:30","modified_gmt":"2017-05-11T07:48:30","slug":"ubuntu-phpmyadmin-setup","status":"publish","type":"post","link":"https:\/\/adrhc.go.ro\/blog\/ubuntu-phpmyadmin-setup\/","title":{"rendered":"Ubuntu: phpMyAdmin setup"},"content":{"rendered":"<pre class=\"brush:bash shell\">\r\nwget https:\/\/files.phpmyadmin.net\/phpMyAdmin\/4.5.0.2\/phpMyAdmin-4.5.0.2-english.tar.gz\r\ntar xvzf phpMyAdmin-4.5.0.2-english.tar.gz\r\nmv phpMyAdmin-4.5.0.2-english myadmin\r\nmkdir myadmin\/config\r\nchown -R ************ myadmin\/config\r\n\r\n\/etc\/php5\/fpm\/php.ini\r\nsession.gc_maxlifetime = 3600\r\nsudo service php5-fpm restart\r\n\r\n#save configuration created using https:\/\/adrhc.go.ro\/myadmin\/setup\r\nmv -v myadmin\/config\/config.inc.php myadmin\/config.inc.php\r\nsudo chown ************ myadmin\/config.inc.php\r\nrmdir myadmin\/config\r\nsudo service php5-fpm restart\r\n\r\n#pma tables (phpMyAdmin configuration storage)\r\n#pma = php My Admin\r\n#Use phpMyAdmin in order to execute the sql content of myadmin\/sql\/create_tables.sql.\r\n#Disable the phpmyadmin-DB creation if you want the pma tables to be included in the current database.\r\n\r\n#config.inc.php\r\n\/* Servers configuration *\/\r\n$i = 0;\r\n\r\n\/* Server: localhost [1] *\/\r\n$i++;\r\n$cfg['Servers'][$i]['verbose'] = 'mysql asrock';\r\n$cfg['Servers'][$i]['host'] = 'localhost';\r\n$cfg['Servers'][$i]['port'] = '';\r\n$cfg['Servers'][$i]['socket'] = '';\r\n$cfg['Servers'][$i]['connect_type'] = 'tcp';\r\n$cfg['Servers'][$i]['auth_type'] = 'cookie';\r\n$cfg['Servers'][$i]['auth_http_realm'] = 'phpMyAdmin';\r\n\r\n\/* don't know the purpose of these commented & not required settings\r\n$cfg['Servers'][$i]['user'] = 'db user name';\r\n$cfg['Servers'][$i]['password'] = 'db password';\r\n*\/\r\n\r\n$cfg['Servers'][$i]['controluser'] = 'db user name for accessing the pmadb below named phpmyadmin';\r\n$cfg['Servers'][$i]['controlpass'] = 'db password for controluser';\r\n$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';\r\n$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';\r\n$cfg['Servers'][$i]['relation'] = 'pma__relation';\r\n$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';\r\n$cfg['Servers'][$i]['users'] = 'pma__users';\r\n$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';\r\n$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';\r\n$cfg['Servers'][$i]['table_info'] = 'pma__table_info';\r\n$cfg['Servers'][$i]['column_info'] = 'pma__column_info';\r\n$cfg['Servers'][$i]['history'] = 'pma__history';\r\n$cfg['Servers'][$i]['recent'] = 'pma__recent';\r\n$cfg['Servers'][$i]['favorite'] = 'pma__favorite';\r\n$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';\r\n$cfg['Servers'][$i]['tracking'] = 'pma__tracking';\r\n$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';\r\n$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';\r\n$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';\r\n$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';\r\n$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';\r\n$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';\r\n\/* End of servers configuration *\/\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>wget https:\/\/files.phpmyadmin.net\/phpMyAdmin\/4.5.0.2\/phpMyAdmin-4.5.0.2-english.tar.gz tar xvzf phpMyAdmin-4.5.0.2-english.tar.gz mv phpMyAdmin-4.5.0.2-english myadmin mkdir myadmin\/config chown -R ************ myadmin\/config \/etc\/php5\/fpm\/php.ini session.gc_maxlifetime = 3600 sudo service php5-fpm restart #save configuration created using https:\/\/adrhc.go.ro\/myadmin\/setup mv -v myadmin\/config\/config.inc.php myadmin\/config.inc.php sudo chown ************ myadmin\/config.inc.php rmdir myadmin\/config sudo service php5-fpm [&hellip;]<\/p>\n<div class=\"link-more\"><a href=\"https:\/\/adrhc.go.ro\/blog\/ubuntu-phpmyadmin-setup\/#more-2196\" class=\"more-link\">Continue reading &#10142; <span class=\"screen-reader-text\">Ubuntu: phpMyAdmin setup<\/span><\/a><\/div>","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,12,8,11,33],"tags":[107],"class_list":["post-2196","post","type-post","status-publish","format-standard","hentry","category-configuration","category-database","category-howto","category-linux","category-ubuntu","tag-phpmymdmin"],"_links":{"self":[{"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/posts\/2196","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/comments?post=2196"}],"version-history":[{"count":0,"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/posts\/2196\/revisions"}],"wp:attachment":[{"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/media?parent=2196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/categories?post=2196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/tags?post=2196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}