shibe23

<p data-line="0" class="code-line">MySQL 8.0 以降ではmysql_native_passwordではなくcaching_sha2_password がデフォルトになっている。</p>
<p data-line="2" class="code-line">SHA-256 認証だが、パフォーマンス向上のためにキャッシュを用いる。</p>
<p data-line="4" class="code-line">MySQL8.4ではデフォルトでプラグインが<code>DISABLED</code>になっており、 <code>my.cnf</code>に<code>mysql_native_password=on</code>を追加しないと有効化できない。</p>


<h1 id="%E5%8F%82%E8%80%83" data-line="0" class="code-line">
<a class="header-anchor-link" href="#%E5%8F%82%E8%80%83" aria-hidden="true"></a> 参考</h1>
<p data-line="1" class="code-line"><span class="embed-block zenn-embedded zenn-embedded-card"><iframe id="zenn-embedded__9f1e3116144e5" src="https://embed.zenn.studio/card#zenn-embedded__9f1e3116144e5" data-content="https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F8.0%2Fja%2Fcaching-sha2-pluggable-authentication.html" frameborder="0" scrolling="no" loading="lazy"></iframe></span><a href="https://dev.mysql.com/doc/refman/8.0/ja/caching-sha2-pluggable-authentication.html" style="display:none" target="_blank" rel="nofollow noopener noreferrer">https://dev.mysql.com/doc/refman/8.0/ja/caching-sha2-pluggable-authentication.html</a><br style="display:none">
<span class="embed-block zenn-embedded zenn-embedded-card"><iframe id="zenn-embedded__c4877b36e1dea" src="https://embed.zenn.studio/card#zenn-embedded__c4877b36e1dea" data-content="https%3A%2F%2Fblog.s-style.co.jp%2F2024%2F05%2F11793%2F" frameborder="0" scrolling="no" loading="lazy"></iframe></span><a href="https://blog.s-style.co.jp/2024/05/11793/" style="display:none" target="_blank" rel="nofollow noopener noreferrer">https://blog.s-style.co.jp/2024/05/11793/</a></p>
