Seen this error when using Docker for NodeJS and MySQL 8?
<pre><code>Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
</code></pre>It is most likely the wrong package is being used.
<ul>
<li><a target="_blank" href="https://www.npmjs.com/package/mysql">mysql</a> package does not support MySQL 8 authentication method (<a target="_blank" href="https://stackoverflow.com/a/56509065">More info here</a>)</li>
<li>Use <a target="_blank" href="https://www.npmjs.com/package/mysql2">mysql2</a> package</li>
</ul>
<h2 id="heading-note">Note</h2>
Make sure the MySQL server is fully running before trying to connect, otherwise an error like below
<pre><code>Error: connect ECONNREFUSED 172.17.0.1:3306
</code></pre>

Seen this error when using Docker for NodeJS and MySQL 8?
```
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
```
It is most likely the wrong package is being used.
- [mysql](https://www.npmjs.com/package/mysql) package does not support MySQL 8 authentication method ([More info here](https://stackoverflow.com/a/56509065))
- Use [mysql2](https://www.npmjs.com/package/mysql2) package

## Note
Make sure the MySQL server is fully running before trying to connect, otherwise an error like below
```
Error: connect ECONNREFUSED 172.17.0.1:3306
```

Docker, NodeJS, and MySQL 8

A logbook of developer notes on various things related to coding and servers. From Laravel Forge, Cloudflare, PHP, to Javascript, and more!