Strapi build fails
When building a Strapi application using a mysql database, I am getting the following error:
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client.
Can anyone help?
7 Replies
Project ID:
N/AProject ID: N/A
Make sure you're using mysql v8+
I had the same problem earlier, was using quickdb.js which used a very old mysql under the hood
But how can I install a mysql v8+ version using Railway?
Railway already provides mysql for you as far as I'm aware, just make sure the library you're using uses mysql v8 +
I think, I'm not too sure myself - i'm new to databases and stuff 🤤
the strapi template from railway deploys just fine
https://github.com/railwayapp-templates/strapi
have a look at it and see what you're doing differently, and fragly is right, that error means the mysql client library is outdated
strapi uses postgre by default, postgre is more cost effective than mqsql (postgre doesnt typically use as much ram) so im not even sure why you would want to use mysql. if you already have strapi data in mysql then there are ways to import to postgre
ah okay. Well than I know enough, thank you guys for the help!