2 years ago
MYSQL Workbench still allows us to connect and run Queries, but our server is unable to connect. The log is saying:
{
sqlMessage: "Plugin 'mysql_native_password' is not loaded",
sqlState: 'HY000',
fatal: true,
originalUrl: 'mainCronJob',
Error: ER_PLUGIN_IS_NOT_LOADED: Plugin 'mysql_native_password' is not loaded
at Handshake.ErrorPacket (/app/node_modules/mysql/lib/protocol/sequences/Handshake.js:123:18)
at Parser._parsePacket (/app/node_modules/mysql/lib/protocol/Parser.js:433:10)
at Parser.write (/app/node_modules/mysql/lib/protocol/Parser.js:43:10)
at Protocol.write (/app/node_modules/mysql/lib/protocol/Protocol.js:38:16)
at Socket.emit (node:events:517:28)
at Socket.emit (node:domain:489:12)
at Protocol._enqueue (/app/node_modules/mysql/lib/protocol/Protocol.js:144:48)
at PoolConnection.connect (/app/node_modules/mysql/lib/Connection.js:116:18)
at new Promise ()
at YourCustomTransport. (/app/dist/src/logger.js:102:61)
sqlMessage: "Plugin 'mysql_native_password' is not loaded",
23 Replies
We've tried to run: ALTER USER 'your_user'@'%' IDENTIFIED WITH mysql_native_password BY 'your_password';
FLUSH PRIVILEGES;
but it responds with: Error Code: 1524. Plugin 'mysql_native_password' is not loaded
Can anyone help us? This happened on both our production site and our development site at the same time, we've made no recent code changes.
After the initial error, we tried redeploying both databases, and this is where we currently are.
2 years ago
Can you send me a screenshot of your database deployments?
2 years ago
Thank you, finally could you send me a screenshot of the image that the MySQL database is connected to?
2 years ago
Click on the Settings button
2 years ago
and then just send a screenshot of the top-most thing on the page
2 years ago
oh perfect, has it always been pinned to version 8?
2 years ago
Let's hope it was, could you try appending --mysql-native-password=ON to your database start command?
You can find that on the same settings page if you scroll down a bit
It is working, thank you. What caused this issue? It is scary for us, as we sometimes have large events going on with a few hundred people on site; it is dangerous for our business to have outages; we want to bulletproof as much as possible.
2 years ago
Railway uses the mysql_native_password plugin for authentication (which is somewhat popular), although it seems MySQL databases on Railway doesn't load that plugin by default so when it redeploys then it has to manually enabled by adding that flag
Ok, that could explain what caused the issue for the redployment, but why did it need to be redeployed? This has been working fine for 9 months
2 years ago
There was an incident where one of Railway's hosts restarted
You can read more about that here: https://status.railway.app/cm2f8s2p2003vdwesikpxm96a
2 years ago
your database was indeed on that host
2 years ago
we are sorry for the inconvenience here
2 years ago
and thank you fragly for getting them up and running so quickly