{"id":4771,"date":"2019-09-13T19:45:55","date_gmt":"2019-09-13T22:45:55","guid":{"rendered":"https:\/\/blog.clusterweb.com.br\/?p=4771"},"modified":"2019-09-13T19:45:55","modified_gmt":"2019-09-13T22:45:55","slug":"instalar-a-ferramenta-de-administracao-de-banco-de-dados-phpmyadmin","status":"publish","type":"post","link":"https:\/\/blog.clusterweb.com.br\/?p=4771","title":{"rendered":"Instalar a ferramenta de administra\u00e7\u00e3o de banco de dados PHPMyAdmin"},"content":{"rendered":"

Desde o Debian 10, o PHPMyAdmin n\u00e3o est\u00e1 mais dispon\u00edvel como pacote .deb.\u00a0Portanto, vamos instal\u00e1-lo a partir da fonte.<\/span><\/p>\n

Crie pastas para o PHPMyadmin:<\/span><\/p>\n

mkdir \/usr\/share\/phpmyadmin\r\nmkdir \/etc\/phpmyadmin\r\nmkdir -p \/var\/lib\/phpmyadmin\/tmp\r\nchown -R www-data:www-data\u00a0\/var\/lib\/phpmyadmin\r\ntouch\u00a0\/etc\/phpmyadmin\/htpasswd.setup<\/code><\/pre>\n
<\/p>\n
V\u00e1 para o diret\u00f3rio \/ tmp e fa\u00e7a o download das fontes do PHPMyAdmin:<\/span><\/p>\n
cd \/tmp\r\nwget\u00a0https:\/\/files.phpmyadmin.net\/phpMyAdmin\/4.9.0.1\/phpMyAdmin-4.9.0.1-all-languages.tar.gz<\/code><\/pre>\n
Descompacte o arquivo baixado e mova os arquivos para a pasta \/ usr \/ share \/ phpmyadmin e limpe o diret\u00f3rio \/ tmp.<\/span><\/p>\n
tar xfz\u00a0phpMyAdmin-4.9.0.1-all-languages.tar.gz\r\nmv\u00a0phpMyAdmin-4.9.0.1-all-languages\/* \/usr\/share\/phpmyadmin\/\r\nrm\u00a0phpMyAdmin-4.9.0.1-all-languages.tar.gz\r\nrm -rf\u00a0phpMyAdmin-4.9.0.1-all-languages<\/code><\/pre>\n
Crie um novo arquivo de configura\u00e7\u00e3o para o PHPMyaAdmin com base no arquivo de amostra fornecido:<\/span><\/p>\n
cp \/usr\/share\/phpmyadmin\/config.sample.inc.php\u00a0 \/usr\/share\/phpmyadmin\/config.inc.php<\/code><\/pre>\n
Abra o arquivo de configura\u00e7\u00e3o com o nano editor:<\/span><\/p>\n
nano\u00a0\/usr\/share\/phpmyadmin\/config.inc.php<\/code><\/pre>\n
Defina uma senha segura (segredo do blowfish) que deve ter 32 caracteres:<\/span><\/p>\n
$cfg['blowfish_secret'] = 'bD3e6wva9fnd93jVsb7SDgeiBCd452Dh'; \/* YOU MUST FILL IN THIS FOR COOKIE AUTH! *\/<\/code><\/pre>\n
N\u00e3o use meu segredo de blowfish de exemplo, defina o seu!<\/span><\/p>\n
Em seguida, adicione uma linha para definir o diret\u00f3rio que o PHPMyAdmin deve usar para armazenar arquivos tempor\u00e1rios:<\/span><\/p>\n
$cfg['TempDir'] = '\/var\/lib\/phpmyadmin\/tmp';<\/code><\/pre>\n
Em seguida, criamos o arquivo de configura\u00e7\u00e3o do Apache para PHPMyAdmin abrindo um novo arquivo no nano editor:<\/span><\/p>\n
nano\u00a0\/etc\/apache2\/conf-available\/phpmyadmin.conf<\/code><\/pre>\n
Cole a seguinte configura\u00e7\u00e3o no arquivo e salve-a.<\/span><\/p>\n
# phpMyAdmin default Apache configuration\r\n\r\nAlias \/phpmyadmin \/usr\/share\/phpmyadmin\r\n\r\n<Directory \/usr\/share\/phpmyadmin>\r\n Options FollowSymLinks\r\n DirectoryIndex index.php\r\n\r\n <IfModule mod_php7.c>\r\n AddType application\/x-httpd-php .php\r\n\r\n php_flag magic_quotes_gpc Off\r\n php_flag track_vars On\r\n php_flag register_globals Off\r\n php_value include_path .\r\n <\/IfModule>\r\n\r\n<\/Directory>\r\n\r\n# Authorize for setup\r\n<Directory \/usr\/share\/phpmyadmin\/setup>\r\n <IfModule mod_authn_file.c>\r\n AuthType Basic\r\n AuthName \"phpMyAdmin Setup\"\r\n AuthUserFile \/etc\/phpmyadmin\/htpasswd.setup\r\n <\/IfModule>\r\n Require valid-user\r\n<\/Directory>\r\n\r\n# Disallow web access to directories that don't need it\r\n<Directory \/usr\/share\/phpmyadmin\/libraries>\r\n Order Deny,Allow\r\n Deny from All\r\n<\/Directory>\r\n<Directory \/usr\/share\/phpmyadmin\/setup\/lib>\r\n Order Deny,Allow\r\n Deny from All\r\n<\/Directory><\/code><\/pre>\n
Ative a configura\u00e7\u00e3o e reinicie o Apache.<\/span><\/p>\n
a2enconf phpmyadmin\r\nsystemctl restart apache2<\/code><\/pre>\n
Na pr\u00f3xima etapa, iremos configurar o reposit\u00f3rio de configura\u00e7\u00f5es do phpMyadmin (banco de dados).<\/span><\/p>\n
Efetue login no MariaDB como usu\u00e1rio root:<\/span><\/p>\n
mysql -u root -p<\/code><\/pre>\n
No shell do MariaDB, crie um novo banco de dados para o PHPMyAdmin:<\/span><\/p>\n
MariaDB [(none)]> CREATE DATABASE phpmyadmin;<\/code><\/pre>\n
Em seguida, crie um novo usu\u00e1rio:<\/span><\/p>\n
MariaDB [(none)]> CREATE USER 'pma'@'localhost' IDENTIFIED BY 'mypassword';<\/code><\/pre>\n
Substitua a palavra\u00a0<\/span>mypassword<\/span><\/em>\u00a0por uma senha segura de sua escolha nos comandos acima e abaixo; use a mesma senha nas duas vezes.\u00a0Em seguida, conceda ao usu\u00e1rio acesso a esse banco de dados e recarregue as permiss\u00f5es do banco de dados.<\/span><\/p>\n
MariaDB [(none)]> GRANT ALL PRIVILEGES ON phpmyadmin.* TO 'pma'@'localhost' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;\r\nMariaDB [(none)]> FLUSH PRIVILEGES;\r\nMariaDB [(none)]> EXIT;<\/code><\/pre>\n
Por fim, carregue as tabelas SQL no banco de dados:<\/span><\/p>\n
mysql -u root -p phpmyadmin < \/usr\/share\/phpmyadmin\/sql\/create_tables.sql<\/code><\/pre>\n
Digite a senha raiz do MariaDB, mediante solicita\u00e7\u00e3o.<\/span><\/p>\n
Tudo o que precisamos fazer agora \u00e9 definir os detalhes do usu\u00e1rio phpmyadmin no arquivo de configura\u00e7\u00e3o.\u00a0Abra o arquivo no nano editor novamente:<\/span><\/p>\n
nano \/usr\/share\/phpmyadmin\/config.inc.php<\/code><\/pre>\n
Role para baixo at\u00e9 ver as linhas abaixo e edit\u00e1-las:<\/span><\/p>\n
\/* User used to manipulate with storage *\/\r\n$cfg['Servers'][$i]['controlhost'] = 'localhost';<\/span>\r\n$cfg['Servers'][$i]['controlport'] = '';<\/span>\r\n$cfg['Servers'][$i]['controluser'] = 'pma';<\/span>\r\n$cfg['Servers'][$i]['controlpass'] = 'mypassword';<\/span>\r\n\r\n\/* Storage database and tables *\/\r\n$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';<\/span>\r\n$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';<\/span>\r\n$cfg['Servers'][$i]['relation'] = 'pma__relation';<\/span>\r\n$cfg['Servers'][$i]['table_info'] = 'pma__table_info';<\/span>\r\n$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';<\/span>\r\n$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';<\/span>\r\n$cfg['Servers'][$i]['column_info'] = 'pma__column_info';<\/span>\r\n$cfg['Servers'][$i]['history'] = 'pma__history';<\/span>\r\n$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';<\/span>\r\n$cfg['Servers'][$i]['tracking'] = 'pma__tracking';<\/span>\r\n$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';<\/span>\r\n$cfg['Servers'][$i]['recent'] = 'pma__recent';<\/span>\r\n$cfg['Servers'][$i]['favorite'] = 'pma__favorite';<\/span>\r\n$cfg['Servers'][$i]['users'] = 'pma__users';<\/span>\r\n$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';<\/span>\r\n$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';<\/span>\r\n$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';<\/span>\r\n$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';<\/span>\r\n$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';<\/span>\r\n$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';<\/span><\/code><\/pre>\n
Marquei as linhas em vermelho que editei.\u00a0Substitua\u00a0<\/span>mypassword<\/span><\/em>\u00a0pela senha que voc\u00ea escolheu para o usu\u00e1rio phpmyadmin.\u00a0Observe que o \/\/ na frente das linhas tamb\u00e9m foi removido!<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Desde o Debian 10, o PHPMyAdmin n\u00e3o est\u00e1 mais dispon\u00edvel como pacote .deb.\u00a0Portanto, vamos instal\u00e1-lo a partir da fonte. Crie pastas para o PHPMyadmin: mkdir \/usr\/share\/phpmyadmin mkdir \/etc\/phpmyadmin mkdir -p \/var\/lib\/phpmyadmin\/tmp chown -R www-data:www-data\u00a0\/var\/lib\/phpmyadmin touch\u00a0\/etc\/phpmyadmin\/htpasswd.setup<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[455,1082,730,1,830,42,51,495,514],"tags":[773,1416,1417,1418,353,1415,699,1419],"class_list":["post-4771","post","type-post","status-publish","format-standard","hentry","category-apache2","category-centos-7-rhel-7","category-clusterweb","category-viazap","category-debian","category-leitura-recomendada","category-linux-linuxrs","category-profissional-de-ti","category-programacao","tag-a","tag-administracao","tag-banco","tag-dados","tag-de","tag-ferramenta","tag-instalar","tag-phpmyadmin"],"_links":{"self":[{"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/posts\/4771","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4771"}],"version-history":[{"count":1,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/posts\/4771\/revisions"}],"predecessor-version":[{"id":4772,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/posts\/4771\/revisions\/4772"}],"wp:attachment":[{"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4771"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4771"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4771"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}