{"id":1177,"date":"2021-05-03T21:51:22","date_gmt":"2021-05-04T00:51:22","guid":{"rendered":"https:\/\/blog.abratel.com.br\/?p=1177"},"modified":"2023-12-29T05:50:12","modified_gmt":"2023-12-29T08:50:12","slug":"phpmyadmin-setando-usuario-master-para-login","status":"publish","type":"post","link":"https:\/\/blog.abratel.com.br\/?p=1177","title":{"rendered":"Phpmyadmin setando usuario master para login"},"content":{"rendered":"<p>These steps worked for me on several Systems using  MariaDB.<\/p>\n<p>log into MYSQL as root<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\nmysql -u root\n<\/pre>\n<p>Create new user (admin) and Grant privileges. To a new user execute:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\nCREATE USER 'admin'@'localhost' IDENTIFIED BY 'password';\nGRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost';\nFLUSH PRIVILEGES;\n<\/pre>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\nexit\n\nservice mysql restart\n<\/pre>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\nroot@:\/home\/uferes# vim \/etc\/apache2\/sites-enabled\/phpmyadmin.conf\n\nAlias \/phpmyadmin2  \/var\/www\/html\/phpmyadmin2\n&lt;directory &quot;=&quot;&quot; var=&quot;&quot; www=&quot;&quot; html=&quot;&quot; phpmyadmin2&quot;=&quot;&quot;&gt;\nAddDefaultCharset UTF-8\n&lt;files *=&quot;&quot;&gt;\nHeader set Cache-Control: &quot;private, pre-check=0, post-check=0, max-age=0&quot;\nHeader set Expires: 0\nHeader set Pragma: no-cache\n&lt;\/files&gt;\nRequire all granted\nAllowOverride all\nOptions +FollowSymLinks\n&lt;\/directory&gt;\n\n<\/pre>\n<p>Compare a imagem abaixo uma vez que o wordpress troca os caracteres.<br \/>\nATENCAO: Debian eu tive que retirar a linha 4 onde fala: php_value magic_quotes_gpc off<\/p>\n","protected":false},"excerpt":{"rendered":"<p>These steps worked for me on several Systems using MariaDB. log into MYSQL as root Create new user (admin) and Grant privileges. To a new user execute: Compare a imagem abaixo uma vez que o wordpress troca os caracteres. ATENCAO: Debian eu tive que retirar&#8230;<\/p>\n","protected":false},"author":1,"featured_media":1179,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts\/1177"}],"collection":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1177"}],"version-history":[{"count":16,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts\/1177\/revisions"}],"predecessor-version":[{"id":1670,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts\/1177\/revisions\/1670"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/media\/1179"}],"wp:attachment":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1177"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}