{"id":9978,"date":"2018-05-24T14:07:43","date_gmt":"2018-05-24T17:07:43","guid":{"rendered":"https:\/\/blog.hostinger.io\/pt-tutoriais\/?p=9978"},"modified":"2023-07-28T16:34:40","modified_gmt":"2023-07-28T19:34:40","slug":"como-mudar-urls-no-wordpress-no-banco-de-dados-mysql-usando-phpmyadmin","status":"publish","type":"post","link":"\/pt\/tutoriais\/mudar-url-wordpress-mysql-phpmyadmin\/","title":{"rendered":"Como mudar URLs no WordPress no banco de dados MySQL usando phpMyAdmin"},"content":{"rendered":"<p class=\"wp-block-paragraph\"><span style=\"font-weight: 400\">O <strong>WordPress<\/strong> usa o banco de dados <strong>MySQL<\/strong> para armazenar todos os tipos de dados: posts, p&aacute;ginas, perfis e configura&ccedil;&otilde;es.&nbsp;<\/span><span style=\"font-weight: 400\">Se voc&ecirc; mudar seu site WordPress para um arquivo diferente ou o seu dom&iacute;nio mudar de nome, &eacute; necess&aacute;rio que voc&ecirc; mude as URLs do WordPress nas tabelas do banco de dados MySQL. Basicamente, voc&ecirc; vai <strong>mudar URL WordPress<\/strong>. E voc&ecirc; vai fazer isso usando a op&ccedil;&atilde;o <strong>phpMyAdmin<\/strong> do seu painel de controle de hospedagem de sites.&nbsp;<\/span><br><\/p><p>\n\n\n<div class=\"announcement-block announcement-block--important\">\n            <span class=\"announcement-block__heading\">\n                <svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                    <path fill-rule=\"evenodd\" clip-rule=\"evenodd\"\n                          d=\"M12 22.5C17.799 22.5 22.5 17.799 22.5 12C22.5 6.20101 17.799 1.5 12 1.5C6.20101 1.5 1.5 6.20101 1.5 12C1.5 17.799 6.20101 22.5 12 22.5ZM13.637 7.65198C13.637 6.74791 12.9041 6.01501 12 6.01501C11.0959 6.01501 10.363 6.74791 10.363 7.65198C10.5335 9.53749 10.875 13.383 10.875 13.383C10.875 14.0043 11.3787 14.508 12 14.508C12.6213 14.508 13.125 14.0043 13.125 13.383V13.38L13.637 7.65198ZM11.9927 15.714C11.3714 15.714 10.8677 16.2177 10.8677 16.839C10.8677 17.4603 11.3714 17.964 11.9927 17.964H12.0073C12.6286 17.964 13.1323 17.4603 13.1323 16.839C13.1323 16.2177 12.6286 15.714 12.0073 15.714H11.9927Z\"\n                          fill=\"#FEA419\"\/>\n                <\/svg>\n                Important\n            <\/span>\n            <p class=\"announcement-block__content\">\n                Quer sacar mais sobre bancos de dados? Acesse o conte&uacute;do <a href=\"https:\/\/blog.hostinger.io\/pt-tutoriais\/entenda-diferenca-entre-sql-e-mysql\/\" target=\"_blank\" rel=\"noopener\">Entenda a diferen&ccedil;a entre MySQL e SQL Server<\/a> e veja qual deles usar de acordo com seu perfil e as necessidades do seu site.\n            <\/p><\/div>\n\n\n\n<\/p><h2 class=\"wp-block-heading\" id=\"h-o-que-voce-vai-precisar\"><span style=\"font-weight: 400\">O que voc&ecirc; vai precisar<\/span><\/h2><p class=\"wp-block-paragraph\"><span style=\"font-weight: 400\">Antes de come&ccedil;ar este guia sobre <strong>mudar URL WordPress<\/strong>, voc&ecirc; vai precisar do seguinte:<\/span><\/p><ul class=\"wp-block-list\">\n<li><span style=\"font-weight: 400\">Acesso ao painel de controle da sua conta de hospedagem.<\/span><\/li>\n\n\n\n<li><span style=\"font-weight: 400\">Entendimento b&aacute;sico de phpMyAdmin<\/span><\/li>\n<\/ul><h2 class=\"wp-block-heading\" id=\"h-passo-1-determinando-o-nome-do-wordpress-no-banco-de-dados-mysql\"><span style=\"font-weight: 400\">Passo 1 &ndash; Determinando o Nome do WordPress no banco de dados MySQL<\/span><\/h2><p class=\"wp-block-paragraph\"><span style=\"font-weight: 400\">Voc&ecirc; pode pular esse passo se voc&ecirc; tiver apenas um banco de dados MySQL. Entretanto, se voc&ecirc; tiver mais de um e n&atilde;o tem certeza qual banco de dados est&aacute; conectado ao WordPress, voc&ecirc; precisa determinar o nome do banco de dados MySQL. &Eacute; assim que voc&ecirc; vai conseguir <strong>mudar URL WordPress<\/strong>.<\/span><\/p><p class=\"wp-block-paragraph\"><span style=\"font-weight: 400\">O WordPress armazena o nome e as credenciais do banco de dados MySQL no arquivo wp-config.php. Voc&ecirc; pode encontrar o wp-config.php na raiz do diret&oacute;rio do seu arquivo WordPress. Use o <\/span><b>File Manager<\/b><span style=\"font-weight: 400\"> ou um <\/span><b>cliente FTP <\/b><span style=\"font-weight: 400\">para acessar esse arquivo.<\/span><\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" width=\"1024\" height=\"742\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/26\/2018\/08\/filemanager-wpconfig-edit-highlighted-pt.png\/public\" alt=\"Gerenciador de arquivos do Hostinger. O bot&atilde;o de edi&ccedil;&atilde;o do arquivo wp-config.php est&aacute; destacado\" class=\"wp-image-34772\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/26\/2018\/08\/filemanager-wpconfig-edit-highlighted-pt.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/26\/2018\/08\/filemanager-wpconfig-edit-highlighted-pt.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/26\/2018\/08\/filemanager-wpconfig-edit-highlighted-pt.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/26\/2018\/08\/filemanager-wpconfig-edit-highlighted-pt.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div><p class=\"wp-block-paragraph\"><span style=\"font-weight: 400\">Abra o arquivo wp-config.php e procure pelo &lsquo;DB_NAME&rsquo;.<\/span><\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" width=\"1172\" height=\"488\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/26\/2018\/08\/wpconfig-databasedetails.png\/public\" alt=\"O conte&uacute;do do arquivo wp-config.php. Os detalhes do banco de dados s&atilde;o destacados\" class=\"wp-image-34774\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/26\/2018\/08\/wpconfig-databasedetails.png\/w=1172,fit=scale-down 1172w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/26\/2018\/08\/wpconfig-databasedetails.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/26\/2018\/08\/wpconfig-databasedetails.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/26\/2018\/08\/wpconfig-databasedetails.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/26\/2018\/08\/wpconfig-databasedetails.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1172px) 100vw, 1172px\" \/><\/figure>\n<\/div><p class=\"wp-block-paragraph\"><span style=\"font-weight: 400\">Neste caso, o nome do nosso banco de dados &eacute; <strong>u123456789_abcd<\/strong>.<\/span><\/p><h2 class=\"wp-block-heading\" id=\"h-passo-2-entrando-no-phpmyadmin-para-mudar-url-wordpress\"><span style=\"font-weight: 400\">Passo 2 &ndash; Entrando no phpMyAdmin para mudar URL WordPress<\/span><\/h2><p class=\"wp-block-paragraph\"><span style=\"font-weight: 400\">Este &eacute;, na verdade, o primeiro passo para conseguir<strong> mudar URL WordPress<\/strong>. Voc&ecirc; pode fazer isso acessando a op&ccedil;&atilde;o <\/span><b>phpMyAdmin<\/b><span style=\"font-weight: 400\"> dentro da op&ccedil;&atilde;o Banco de Dados do seu painel de controle.<\/span><\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" width=\"298\" height=\"333\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/26\/2023\/04\/hpanel-databases-management-sidebar-pt.png\/public\" alt=\"O bot&atilde;o de gerenciamento de bancos de dados no hPanel\" class=\"wp-image-34432\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/26\/2023\/04\/hpanel-databases-management-sidebar-pt.png\/w=298,fit=scale-down 298w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/26\/2023\/04\/hpanel-databases-management-sidebar-pt.png\/w=268,fit=scale-down 268w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/26\/2023\/04\/hpanel-databases-management-sidebar-pt.png\/w=134,fit=scale-down 134w\" sizes=\"(max-width: 298px) 100vw, 298px\" \/><\/figure>\n<\/div><h2 class=\"wp-block-heading\" id=\"h-passo-3-selecionando-o-banco-de-dados-apropriado\"><span style=\"font-weight: 400\">Passo 3 &ndash; Selecionando o banco de dados apropriado<\/span><\/h2><p class=\"wp-block-paragraph\"><span style=\"font-weight: 400\">Assim que entrar no<\/span><b> phpMyAdmin<\/b><span style=\"font-weight: 400\">, voc&ecirc; poder&aacute; acessar o banco de dados MySQL correspondente. Voc&ecirc; deve selecionar aquele que est&aacute; conectado com seu site WordPress.<\/span><\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" width=\"1024\" height=\"361\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/26\/2018\/05\/hpanel-databases-management-listofcurrentmysqldatabases-enterphpmyadmin-highlighted-pt.png\/public\" alt=\"A p&aacute;gina de gerenciamento de bancos de dados. O bot&atilde;o Enter phpMyAdmin &eacute; destacado\" class=\"wp-image-34803\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/26\/2018\/05\/hpanel-databases-management-listofcurrentmysqldatabases-enterphpmyadmin-highlighted-pt.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/26\/2018\/05\/hpanel-databases-management-listofcurrentmysqldatabases-enterphpmyadmin-highlighted-pt.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/26\/2018\/05\/hpanel-databases-management-listofcurrentmysqldatabases-enterphpmyadmin-highlighted-pt.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/26\/2018\/05\/hpanel-databases-management-listofcurrentmysqldatabases-enterphpmyadmin-highlighted-pt.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div><h2 class=\"wp-block-heading\" id=\"h-passo-4-formatando-o-sql-query\"><span style=\"font-weight: 400\">Passo 4 &ndash; Formatando o SQL Query<\/span><\/h2><p class=\"wp-block-paragraph\"><span style=\"font-weight: 400\">Clique na se&ccedil;&atilde;o<strong> SQL<\/strong> em <strong>phpMyAdmin<\/strong> e entre com o seguinte c&oacute;digo. &nbsp;<\/span><\/p><pre class=\"wp-block-preformatted\"><code>UPDATE wp_options SET option_value = replace(option_value, 'oldurl.com', 'newurl.com') WHERE option_name = 'home' OR option_name = 'siteurl';<\/code> <code>UPDATE wp_posts SET guid = replace(guid, 'oldurl.com','newurl.com');<\/code> <code>UPDATE wp_posts SET post_content = replace(post_content, 'oldurl.com', 'newurl.com');<\/code> <code>UPDATE wp_postmeta SET meta_value = replace(meta_value,'oldurl.com','newurl.com');<\/code><\/pre><p class=\"wp-block-paragraph\"><span style=\"font-weight: 400\">Esse c&oacute;digo vai substituir todas as inst&acirc;ncias <\/span><i><span style=\"font-weight: 400\">oldurl.com <\/span><\/i><span style=\"font-weight: 400\">para <\/span><i><span style=\"font-weight: 400\">newurl.com<\/span><\/i><span style=\"font-weight: 400\">. Por exemplo, se o endere&ccedil;o do seu site WordPress for <\/span><i><span style=\"font-weight: 400\">oldurl.com<\/span><\/i><span style=\"font-weight: 400\">, ele agora vai mudar para <\/span><i><span style=\"font-weight: 400\">oldurl.com<\/span><\/i><span style=\"font-weight: 400\">. <\/span><br><\/p><p>\n\n\n<div class=\"announcement-block announcement-block--important\">\n            <span class=\"announcement-block__heading\">\n                <svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                    <path fill-rule=\"evenodd\" clip-rule=\"evenodd\"\n                          d=\"M12 22.5C17.799 22.5 22.5 17.799 22.5 12C22.5 6.20101 17.799 1.5 12 1.5C6.20101 1.5 1.5 6.20101 1.5 12C1.5 17.799 6.20101 22.5 12 22.5ZM13.637 7.65198C13.637 6.74791 12.9041 6.01501 12 6.01501C11.0959 6.01501 10.363 6.74791 10.363 7.65198C10.5335 9.53749 10.875 13.383 10.875 13.383C10.875 14.0043 11.3787 14.508 12 14.508C12.6213 14.508 13.125 14.0043 13.125 13.383V13.38L13.637 7.65198ZM11.9927 15.714C11.3714 15.714 10.8677 16.2177 10.8677 16.839C10.8677 17.4603 11.3714 17.964 11.9927 17.964H12.0073C12.6286 17.964 13.1323 17.4603 13.1323 16.839C13.1323 16.2177 12.6286 15.714 12.0073 15.714H11.9927Z\"\n                          fill=\"#FEA419\"\/>\n                <\/svg>\n                Important\n            <\/span>\n            <p class=\"announcement-block__content\">\n                <span style=\"font-weight: 400\"><strong>IMPORTANTE:<\/strong> N&atilde;o se esque&ccedil;a de substituir o trecho <\/span><b>oldurl.com<\/b><span style=\"font-weight: 400\"> pelo endere&ccedil;o atual do seu site WordPress e o trecho<\/span><b> newurl.com<\/b><span style=\"font-weight: 400\"> com o novo endere&ccedil;o do seu site WordPress.<\/span><br>\n<img decoding=\"async\" class=\"size-full wp-image-9988 aligncenter\" src=\"https:\/\/blog.hostinger.io\/pt-tutoriais\/wp-content\/uploads\/sites\/26\/2018\/05\/wordpress-phpmyadmin-sql-query.png\" alt=\"sql query na op&ccedil;&atilde;o phpmyadmin para mudar url wordpress\" width=\"745\" height=\"283\" srcset=\"https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-content\/uploads\/sites\/26\/2018\/05\/wordpress-phpmyadmin-sql-query.png 745w, https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-content\/uploads\/sites\/26\/2018\/05\/wordpress-phpmyadmin-sql-query-150x57.png 150w, https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-content\/uploads\/sites\/26\/2018\/05\/wordpress-phpmyadmin-sql-query-300x114.png 300w\" sizes=\"(max-width: 745px) 100vw, 745px\" \/><br>\n\n            <\/p><\/div>\n\n\n\n<\/p><p class=\"wp-block-paragraph\">&Agrave;s vezes o prefixo de tabela pode ser diferente de wp_. Se voc&ecirc; vir erros de mensagem dizendo que as tabelas&nbsp;<strong>wp_options<\/strong>,&nbsp;<strong>wp_posts<\/strong>&nbsp;e&nbsp;<strong>wp_postmeta<\/strong>&nbsp;n&atilde;o podem ser encontradas, verifique o prefixo de tabela e atualize o c&oacute;digo do SQL Query. Voc&ecirc; o prefixo da tabela no lado esquerdo do&nbsp;<strong>phpMyAdmin<\/strong>, dentro do seu banco de dados WordPress.<\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" width=\"243\" height=\"278\" src=\"https:\/\/blog.hostinger.io\/pt-tutoriais\/wp-content\/uploads\/sites\/26\/2018\/05\/prefixo-de-tabela-sql-phpmyadmin-wordpress.png\" alt=\"prefixo de tabela sql no mysql para mudar url wordpress\" class=\"wp-image-9989\" srcset=\"https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-content\/uploads\/sites\/26\/2018\/05\/prefixo-de-tabela-sql-phpmyadmin-wordpress.png 243w, https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-content\/uploads\/sites\/26\/2018\/05\/prefixo-de-tabela-sql-phpmyadmin-wordpress-131x150.png 131w\" sizes=\"(max-width: 243px) 100vw, 243px\" \/><\/figure>\n<\/div><p class=\"wp-block-paragraph\"><span style=\"font-weight: 400\">Neste exemplo, o prefixo da tabela &eacute; <\/span><b>wpqc_<\/b><span style=\"font-weight: 400\">.<\/span><\/p><h2 class=\"wp-block-heading\" id=\"h-passo-5-executando-a-sql-query\"><span style=\"font-weight: 400\">Passo 5 &ndash; Executando a SQL Query<\/span><\/h2><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" width=\"83\" height=\"66\" src=\"https:\/\/blog.hostinger.io\/pt-tutoriais\/wp-content\/uploads\/sites\/26\/2018\/05\/botao-go-tabela-sql-phpmyadmin-wordpress.png\" alt=\"bot&atilde;o Go da tabela sql no phpmyadmin para mudar url wordpress\" class=\"wp-image-9991\"><\/figure>\n<\/div><p class=\"wp-block-paragraph\"><span style=\"font-weight: 400\">Assim que tiver substitu&iacute;do &nbsp;o prefixo da tabela voc&ecirc; poder&aacute; executar a sua query sem problemas. Para fazer isso, aperte no bot&atilde;o <\/span><b>GO<\/b><span style=\"font-weight: 400\">, localizado no canto direito inferior da p&aacute;gina. &nbsp;<\/span><\/p><h2 class=\"wp-block-heading\" id=\"h-passo-6-verificando-a-mudanca-bem-sucedida-das-urls\"><span style=\"font-weight: 400\">Passo 6 &ndash; Verificando a mudan&ccedil;a bem-sucedida das URLs<\/span><\/h2><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" width=\"560\" height=\"49\" src=\"https:\/\/blog.hostinger.io\/pt-tutoriais\/wp-content\/uploads\/sites\/26\/2018\/05\/mensagem-de-sucesso-phpmyadmin.png\" alt=\"mensagem de sucesso no phpmyadmim que indica mudar url wordpress \" class=\"wp-image-9993\" srcset=\"https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-content\/uploads\/sites\/26\/2018\/05\/mensagem-de-sucesso-phpmyadmin.png 560w, https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-content\/uploads\/sites\/26\/2018\/05\/mensagem-de-sucesso-phpmyadmin-150x13.png 150w, https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-content\/uploads\/sites\/26\/2018\/05\/mensagem-de-sucesso-phpmyadmin-300x26.png 300w, https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-content\/uploads\/sites\/26\/2018\/05\/mensagem-de-sucesso-phpmyadmin-550x49.png 550w, https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-content\/uploads\/sites\/26\/2018\/05\/mensagem-de-sucesso-phpmyadmin-559x49.png 559w\" sizes=\"(max-width: 560px) 100vw, 560px\" \/><\/figure>\n<\/div><p class=\"wp-block-paragraph\"><span style=\"font-weight: 400\">Se a query foi executada com sucesso, voc&ecirc; ver&aacute; uma mensagem em verde apontando o seu sucesso:<\/span><\/p><p class=\"wp-block-paragraph\"><span style=\"font-weight: 400\">Perceba que o n&uacute;mero de linhas (rows) ser&aacute; diferente para cada site feito no WordPress.<\/span><\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" width=\"847\" height=\"381\" src=\"https:\/\/blog.hostinger.io\/pt-tutoriais\/wp-content\/uploads\/sites\/26\/2018\/05\/verificar-sql-query-phpmyadmin-wordpress.png\" alt=\"forma de verificar a sql query no phpadmin para mudar url wordpress\" class=\"wp-image-9994\" srcset=\"https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-content\/uploads\/sites\/26\/2018\/05\/verificar-sql-query-phpmyadmin-wordpress.png 847w, https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-content\/uploads\/sites\/26\/2018\/05\/verificar-sql-query-phpmyadmin-wordpress-150x67.png 150w, https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-content\/uploads\/sites\/26\/2018\/05\/verificar-sql-query-phpmyadmin-wordpress-300x135.png 300w, https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-content\/uploads\/sites\/26\/2018\/05\/verificar-sql-query-phpmyadmin-wordpress-768x345.png 768w\" sizes=\"(max-width: 847px) 100vw, 847px\" \/><\/figure>\n<\/div><p class=\"wp-block-paragraph\"><span style=\"font-weight: 400\">Para verificar as mudan&ccedil;as que voc&ecirc; fez para alterar URL WordPress, abra a tabela<\/span><b> wp_options<\/b><span style=\"font-weight: 400\"> e verifique os valores dos campos <\/span><b>home<\/b><span style=\"font-weight: 400\"> e <\/span><b>siteurl<\/b><span style=\"font-weight: 400\">. Voc&ecirc; dever&aacute; ser capaz de ver as novas URLs do WordPress da SQL Query. Neste exemplo, as URLs do WordPress foram alteradas para <\/span><i><span style=\"font-weight: 400\">newurl.com<\/span><\/i><span style=\"font-weight: 400\">. <\/span><\/p><p class=\"wp-block-paragraph\"><span style=\"font-weight: 400\">Se voc&ecirc; tiver erros e a query n&atilde;o for estiver sendo executada, verifique o seu c&oacute;digo e procure por erros de sintaxe. Certifique-se de que voc&ecirc; esteja usando o prefixo de tabela correto. Se ainda tiver algum erro, contate o suporte do seu servi&ccedil;o de hospedagem de sites para assist&ecirc;ncia. Eles v&atilde;o ajudar voc&ecirc; a como mudar a URL do WordPress.<\/span><\/p><h2 class=\"wp-block-heading\" id=\"h-conclusao\"><span style=\"font-weight: 400\">Conclus&atilde;o<\/span><\/h2><p class=\"wp-block-paragraph\"><span style=\"font-weight: 400\">Viu como n&atilde;o &eacute; t&atilde;o complicado&nbsp;<strong>mudar URL WordPess<\/strong>? Neste tutorial, voc&ecirc; acabou de aprender, usando alguns passos, a como mudar as URLs do WordPress em um banco de dados <strong>MySQL<\/strong>. Tudo isso usando a op&ccedil;&atilde;o <strong>phpMyAdmin<\/strong>. <\/span><\/p><p class=\"wp-block-paragraph\">Esperamos que este conte&uacute;do tenha sido &uacute;til! Queremos que voc&ecirc; consiga usar melhor os recursos dispon&iacute;veis no banco de dados MySQL e tamb&eacute;m no seu site WordPress.<\/p><p class=\"wp-block-paragraph\">E lembre-se: se precisar de mais orienta&ccedil;&otilde;es ou dicas extras, estamos aqui para ajudar. Entre em contato conosco pela caixa de coment&aacute;rios abaixo, mande sua d&uacute;vida ou deixe um recado. Vamos adorar interagir com voc&ecirc;!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>O WordPress usa o banco de dados MySQL para armazenar todos os tipos de dados: posts, p&aacute;ginas, perfis e configura&ccedil;&otilde;es.&nbsp;Se voc&ecirc; mudar seu site WordPress para um arquivo diferente ou o seu dom&iacute;nio mudar de nome, &eacute; necess&aacute;rio que voc&ecirc; mude as URLs do WordPress nas tabelas do banco de dados MySQL. Basicamente, voc&ecirc; vai [&#8230;]<\/p>\n<p><a class=\"btn btn-secondary understrap-read-more-link\" href=\"\/pt\/tutoriais\/mudar-url-wordpress-mysql-phpmyadmin\/\">Read More&#8230;<\/a><\/p>\n","protected":false},"author":92,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"rank_math_title":"Como mudar URLs no WordPress pelo MySQL usando phpMyAdmin","rank_math_description":"Fez mudan\u00e7as no seu site WordPress e precisa alterar URLs? Sem problema: a gente te ajuda a mudar URL WordPress pelo banco de dados da sua pr\u00f3pria conta de hospedagem!","rank_math_focus_keyword":"mudar url wordpress","footnotes":""},"categories":[],"tags":[4833,5385,4857,5562,5565,5224,5564,4951,5563,4798],"class_list":["post-9978","post","type-post","status-publish","format-standard","hentry","tag-banco-de-dados","tag-banco-de-dados-mysql","tag-mysql","tag-phpmyadmin","tag-prefixo-de-tabela","tag-site-wordpress","tag-sql-query","tag-url","tag-url-wordpress","tag-wordpress"],"hreflangs":[],"acf":[],"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-json\/wp\/v2\/posts\/9978","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-json\/wp\/v2\/users\/92"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-json\/wp\/v2\/comments?post=9978"}],"version-history":[{"count":10,"href":"https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-json\/wp\/v2\/posts\/9978\/revisions"}],"predecessor-version":[{"id":38751,"href":"https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-json\/wp\/v2\/posts\/9978\/revisions\/38751"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-json\/wp\/v2\/media?parent=9978"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-json\/wp\/v2\/categories?post=9978"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/pt\/tutoriais\/wp-json\/wp\/v2\/tags?post=9978"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}