Error connecting to database since update

Wappler General Need Help
1

For some reason since the update I am now getting the following when I upload the site to the live server.

Error: ER_DBACCESS_DENIED_ERROR: Access denied for user 'thegunnery_*********'@'172.19.0.2' to database 'gunnery'\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/prot…les/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:66:18\n at new Promise ()\n at Client_MySQL.acquireRawConnection (/opt/node_app/node_modules/knex/lib/dialects/mysql/index.js:61:12)\n at create (/opt/node_app/node_modules/knex/lib/client.js:247:39)"

Just updated it on Docker and that now is doing the same thing, nothing has been changed and it was working perfectly before.

Urgent Issue for me .

2

Hi Peter,
The error says the user thegunnery_********* has permissions/access issues for the database gunnery running at 172.19.0.2 so maybe check these.

3

have checked them and they are fine and correct.
Was working perfectly and nothing has changed apart from the Wappler Update

4

It seems like it the DB connection the database was changed from Gunnery to gunnery. I have changed it back and hey presto everything is working again, not sure of this was the cause of the problem but it seems to be working again