ER_ACCESS_DENIED_ERROR on localhost - docker + save emojis

Hey there :wave:

After changing the charset of my database as mentioned here, I can’t use my local docker development environment anymore:
{"status":"500","code":"ER_ACCESS_DENIED_ERROR","message":"ER_ACCESS_DENIED_ERROR: Access denied for user 'xxxxx_usr'@'172.19.0.3' (using password: YES)","stack":"Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'xxxxx_usr'@'172.19.0.3' (using password: YES)\n at Handshake.Sequence._packetToError (/opt/node_app/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)\n at Handshake.ErrorPacket (/opt/node_app/node_modules/mysql/lib/protocol/sequences/Handshake.js:123:18)\n at Protocol._parsePacket (/opt/node_app/node_modules/mysql/lib/protocol/Protocol.js:291:23)\n at Parser._parsePacket (/opt/node_app/node_modules/mysql/lib/protocol/Parser.js:433:10)\n at Parser.write (/opt/node_app/node_modules/mysql/lib/protocol/Parser.js:43:10)\n at Protocol.write (/opt/node_app/node_modules/mysql/lib/protocol/Protocol.js:38:16)\n at Socket.<anonymous> (/opt/node_app/node_modules/mysql/lib/Connection.js:88:28)\n at Socket.<anonymous> (/opt/node_app/node_modules/mysql/lib/Connection.js:526:10)\n at Socket.emit (events.js:315:20)\n at addChunk (internal/streams/readable.js:309:12)\n --------------------\n at Protocol._enqueue (/opt/node_app/node_modules/mysql/lib/protocol/Protocol.js:144:48)\n at Protocol.handshake (/opt/node_app/node_modules/mysql/lib/protocol/Protocol.js:51:23)\n at Connection.connect (/opt/node_app/node_modules/mysql/lib/Connection.js:116:18)\n at /opt/node_app/node_modules/knex/lib/dialects/mysql/index.js:68:18\n at new Promise (<anonymous>)\n at Client_MySQL.acquireRawConnection (/opt/node_app/node_modules/knex/lib/dialects/mysql/index.js:63:12)\n at create (/opt/node_app/node_modules/knex/lib/client.js:290:39)"}

I’ve only changed this and even after trying to revert it, it’s not working. I tried to restart everything, re-deploy everything, same issue… The production environment is working perfectly though… :sweat_smile:

  1. Any idea how I could fix it? The error message is pretty straightforward, but if I need to change the database password, i simply don’t know how to achieve this with Docker… And why it happened suddenly, I just changed the charset, nothing else…
    For information, I still can access and make some changes on my local database by using the visual database manager.

  2. How to convert the database to get the emojis working? Changing it in Wappler is not enough I guess and I still get the error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD. With PhpMyAdmin I would do this easily but we don’t have any visual access to the database except the visual Database manager and it doesn’t allow us to change it yet. I simply don’t know how to do it with Docker and I don’t want to break anything else. :sweat_smile:

Thanks for your help!

Community Page
Last updated: