{"id":55,"date":"2025-08-13T16:30:52","date_gmt":"2025-08-13T16:30:52","guid":{"rendered":"https:\/\/ayoocloud.com.br\/blog\/?p=55"},"modified":"2025-08-14T21:17:55","modified_gmt":"2025-08-14T21:17:55","slug":"erro-plugin-caching_sha2_password-otserv-8-60","status":"publish","type":"post","link":"https:\/\/ayoocloud.com.br\/blog\/2025\/08\/13\/erro-plugin-caching_sha2_password-otserv-8-60\/","title":{"rendered":"Erro Plugin caching_sha2_password otserv 8.60"},"content":{"rendered":"

MySQL Error Message: Plugin caching_sha2_password could not be loaded: The specified module could not be found. Library path is ‘caching_sha2_password.dll’
\nERROR: Failed to connect to database.<\/p><\/blockquote>\n

 <\/p>\n

indica que o cliente MySQL (ou a extens\u00e3o que voc\u00ea est\u00e1 usando para conectar ao banco) est\u00e1 tentando usar o plugin de autentica\u00e7\u00e3o\u00a0caching_sha2_password<\/strong>,\u00a0<\/span>mas n\u00e3o consegue carregar a biblioteca (DLL) necess\u00e1ria no seu ambiente.<\/p>\n

Por que isso acontece?<\/span><\/span><\/h3>\n
    \n
  • A partir do\u00a0MySQL 8.0<\/span>, o m\u00e9todo padr\u00e3o de autentica\u00e7\u00e3o \u00e9 o\u00a0caching_sha2_password<\/strong>.<\/li>\n
  • Alguns clientes, drivers ou extens\u00f5es PHP (ex:mysqli<\/span><\/strong>,\u00a0pdo_mysql<\/span><\/strong>) antigos ou mal configurados n\u00e3o suportam esse m\u00e9todo e precisam do plugin para se autenticar.<\/li>\n
  • O erro aponta que o arquivo\u00a0caching_sha2_password.dll<\/strong>\u00a0<\/span>n\u00e3o est\u00e1 dispon\u00edvel ou acess\u00edvel na pasta de plugins do MySQL cliente ou do PHP.<\/li>\n<\/ul>\n

    Como corrigir?<\/span><\/span><\/h3>\n

    Op\u00e7\u00e3o 1 \u2014 <\/span>Mudar o plugin de autentica\u00e7\u00e3o do usu\u00e1rio MySQL para\u00a0mysql_native_password.<\/span><\/strong><\/p>\n

    No servidor MySQL, rode:<\/p>\n

    ALTER USER ‘seu_usuario’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘sua_senha’;
    \nFLUSH PRIVILEGES;<\/p><\/blockquote>\n

    Isso faz o usu\u00e1rio usar o m\u00e9todo antigo, mais compat\u00edvel.<\/p>\n

     <\/p>\n

    Op\u00e7\u00e3o 2 \u2014 Atualizar seu cliente\/driver MySQL<\/strong><\/span><\/p>\n

      \n
    • Se estiver usando PHP, atualize para a vers\u00e3o mais recente do PHP e das extens\u00f5es\u00a0mysqli\u00a0<\/span><\/strong>e\u00a0pdo_mysql<\/span><\/strong>.<\/li>\n
    • Se estiver usando outro cliente, atualize para vers\u00e3o que suporte\u00a0caching_sha2_password<\/strong>.<\/span><\/li>\n<\/ul>\n

      Op\u00e7\u00e3o 3 \u2014 Instalar o plugin no seu sistema<\/span><\/strong><\/p>\n

        \n
      • Baixe a\u00a0DLL caching_sha2_password.dll<\/strong><\/span>\u00a0compat\u00edvel com seu sistema e coloque no diret\u00f3rio correto (ext do PHP, ou plugins do MySQL).<\/li>\n
      • Configure o\u00a0my.ini<\/span>\/my.cnf<\/span><\/strong>\u00a0para apontar para o diret\u00f3rio correto dos plugins.<\/li>\n<\/ul>\n

        Resumo r\u00e1pido para maioria dos casos:<\/span><\/p>\n

        Se voc\u00ea tem acesso ao banco, rode o comando de troca para\u00a0mysql_native_password<\/span>.\u00a0Isso resolve a conex\u00e3o de imediato e evita a DLL:<\/p>\n

        ALTER USER ‘seu_usuario’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘sua_senha’;
        \nFLUSH PRIVILEGES;<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

        MySQL Error Message: Plugin caching_sha2_password could not be loaded: The specified module could not be found. Library path is ‘caching_sha2_password.dll’ ERROR: Failed to connect to database.   indica que o […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49,29,11,22],"tags":[],"class_list":["post-55","post","type-post","status-publish","format-standard","hentry","category-ot-server","category-servidor-dedicado","category-servidor-vps","category-tibia"],"_links":{"self":[{"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/posts\/55","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/comments?post=55"}],"version-history":[{"count":2,"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/posts\/55\/revisions"}],"predecessor-version":[{"id":88,"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/posts\/55\/revisions\/88"}],"wp:attachment":[{"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/media?parent=55"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/categories?post=55"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/tags?post=55"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}