{"id":434,"date":"2024-04-16T13:15:43","date_gmt":"2024-04-16T16:15:43","guid":{"rendered":"https:\/\/difusao.tech\/blog\/?p=434"},"modified":"2024-04-16T13:15:46","modified_gmt":"2024-04-16T16:15:46","slug":"como-acessar-o-terminal-mysql-mariadb-do-xampp","status":"publish","type":"post","link":"https:\/\/difusao.tech\/blog\/como-acessar-o-terminal-mysql-mariadb-do-xampp\/","title":{"rendered":"Como acessar o terminal MySQL \/ MariaDB do xampp"},"content":{"rendered":"<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"795\" height=\"311\" src=\"https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-106.png\" alt=\"\" class=\"wp-image-435\" style=\"width:643px;height:auto\" srcset=\"https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-106.png 795w, https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-106-300x117.png 300w, https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-106-768x300.png 768w\" sizes=\"auto, (max-width: 795px) 100vw, 795px\" \/><\/figure>\n<\/div>\n\n\n<p>O XAMPP \u00e9 um pacote com os principais servidores de c\u00f3digo aberto do mercado, incluindo FTP, banco de dados MySQL e Apache com suporte as linguagens PHP e Perl.<\/p>\n\n\n\n<p>Sabemos que usamos o phpmyadmin para acessar o banco de dados com uma interface web mais amig\u00e1vel, por\u00e9m para quest\u00e3o de teste, estudos ou apensa para praticar, precisamos acessar o terminal.<\/p>\n\n\n\n<p>Caso voc\u00ea esteja iniciando os estudos e n\u00e3o tenha o Xampp instalado, baixe no site oficial: <strong><a href=\"http:\/\/apachefriends.org\">apachefriends.org<\/a><\/strong>.<\/p>\n\n\n\n<p>Depois do Xampp instalado, abra com permiss\u00e3o administrativa para conseguirmos instalar o servi\u00e7o.<\/p>\n\n\n\n<p>Obs.: Essa op\u00e7\u00e3o de instala\u00e7\u00e3o do servi\u00e7o \u00e9 opcional, caso voc\u00ea queira que o MySQL inicie autom\u00e1ticamente ao ligar o PC.<\/p>\n\n\n\n<p>No menu iniciar, pesquise Xampp e depois clique com o bot\u00e3o direito do mouse sobre <strong>Executar como administrador<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"767\" height=\"625\" src=\"https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-107.png\" alt=\"\" class=\"wp-image-436\" srcset=\"https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-107.png 767w, https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-107-300x244.png 300w\" sizes=\"auto, (max-width: 767px) 100vw, 767px\" \/><\/figure>\n\n\n\n<p>Clique no x ao lado de MySQL para que seja instalado o servi\u00e7o e ele executar automaticamente toda vez que ligar o computador.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"667\" height=\"430\" src=\"https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-108.png\" alt=\"\" class=\"wp-image-437\" srcset=\"https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-108.png 667w, https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-108-300x193.png 300w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/figure>\n\n\n\n<p>Clique em Yes para confirmar a instala\u00e7\u00e3o do servi\u00e7o.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"370\" height=\"119\" src=\"https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-109.png\" alt=\"\" class=\"wp-image-438\" srcset=\"https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-109.png 370w, https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-109-300x96.png 300w\" sizes=\"auto, (max-width: 370px) 100vw, 370px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Agora vem a configura\u00e7\u00e3o para acesso via terminal.<\/p>\n\n\n\n<p>Abra o explorador de arquivos com o atalho start (windows) + E, navegue at\u00e9 a pasta xampp > mysql > bin e copie o caminho da pasta, ser\u00e1 algo como:  <mark style=\"background-color:#abb8c3\" class=\"has-inline-color\">C:\\xampp\\mysql\\bin<\/mark><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"446\" height=\"373\" src=\"https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-111.png\" alt=\"\" class=\"wp-image-440\" srcset=\"https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-111.png 446w, https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-111-300x251.png 300w\" sizes=\"auto, (max-width: 446px) 100vw, 446px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Vamos abrir as configura\u00e7\u00f5es avan\u00e7adas do sistema.<\/p>\n\n\n\n<p>Tecla de atalho start (windows) + Pause Break.<\/p>\n\n\n\n<p>Clique em configura\u00e7\u00f5es avan\u00e7ada do sistema.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"950\" height=\"672\" src=\"https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-113.png\" alt=\"\" class=\"wp-image-442\" srcset=\"https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-113.png 950w, https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-113-300x212.png 300w, https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-113-768x543.png 768w\" sizes=\"auto, (max-width: 950px) 100vw, 950px\" \/><\/figure>\n\n\n\n<p>Depois em vari\u00e1veis de ambiente.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"410\" height=\"466\" src=\"https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-114.png\" alt=\"\" class=\"wp-image-443\" srcset=\"https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-114.png 410w, https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-114-264x300.png 264w\" sizes=\"auto, (max-width: 410px) 100vw, 410px\" \/><\/figure>\n\n\n\n<p>Em vari\u00e1vis de usu\u00e1rio, selecione Path e depois editar.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"616\" height=\"585\" src=\"https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-115.png\" alt=\"\" class=\"wp-image-444\" srcset=\"https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-115.png 616w, https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-115-300x285.png 300w\" sizes=\"auto, (max-width: 616px) 100vw, 616px\" \/><\/figure>\n\n\n\n<p>Clique em novo e depois cole o caminho da pasta bin que voc\u00ea copiou anteriormente.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"616\" height=\"580\" src=\"https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-116.png\" alt=\"\" class=\"wp-image-445\" srcset=\"https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-116.png 616w, https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-116-300x282.png 300w\" sizes=\"auto, (max-width: 616px) 100vw, 616px\" \/><\/figure>\n\n\n\n<p>Clique em ok at\u00e9 fechar todas as janelas.<\/p>\n\n\n\n<p>Abra o prompt de comando e digite o seguinte comando: <mark style=\"background-color:#abb8c3\" class=\"has-inline-color\">mysql -u root &#8211;password<\/mark><\/p>\n\n\n\n<p>Feito isso vai pedir a senha, que por padr\u00e3o esta em branco, digite apenas enter e agora voc\u00ea esta dentro do terminal do MariaDB.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"980\" height=\"321\" src=\"https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-117.png\" alt=\"\" class=\"wp-image-446\" srcset=\"https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-117.png 980w, https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-117-300x98.png 300w, https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-117-768x252.png 768w\" sizes=\"auto, (max-width: 980px) 100vw, 980px\" \/><\/figure>\n\n\n\n<p>Vamos realizar um teste mostrando as bases de dados dispon\u00edveis.<\/p>\n\n\n\n<p>Digite: <mark style=\"background-color:#abb8c3\" class=\"has-inline-color\">show databases;<\/mark><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"304\" height=\"254\" src=\"https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-118.png\" alt=\"\" class=\"wp-image-447\" srcset=\"https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-118.png 304w, https:\/\/difusao.tech\/blog\/wp-content\/uploads\/2024\/04\/image-118-300x251.png 300w\" sizes=\"auto, (max-width: 304px) 100vw, 304px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Bons estudos e at\u00e9 a pr\u00f3xima.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>O XAMPP \u00e9 um pacote com os principais servidores de c\u00f3digo aberto do mercado, incluindo FTP, banco de<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[236,237,96,83],"class_list":["post-434","post","type-post","status-publish","format-standard","hentry","category-banco-de-dados","tag-banco-de-dados","tag-mariadb","tag-mysql","tag-terminal"],"_links":{"self":[{"href":"https:\/\/difusao.tech\/blog\/wp-json\/wp\/v2\/posts\/434","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/difusao.tech\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/difusao.tech\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/difusao.tech\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/difusao.tech\/blog\/wp-json\/wp\/v2\/comments?post=434"}],"version-history":[{"count":1,"href":"https:\/\/difusao.tech\/blog\/wp-json\/wp\/v2\/posts\/434\/revisions"}],"predecessor-version":[{"id":448,"href":"https:\/\/difusao.tech\/blog\/wp-json\/wp\/v2\/posts\/434\/revisions\/448"}],"wp:attachment":[{"href":"https:\/\/difusao.tech\/blog\/wp-json\/wp\/v2\/media?parent=434"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/difusao.tech\/blog\/wp-json\/wp\/v2\/categories?post=434"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/difusao.tech\/blog\/wp-json\/wp\/v2\/tags?post=434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}