This is an automated archive.
The original was posted on /r/mysql by /u/vanke on 2023-08-11 11:39:14+00:00.
Sorry if AWS RDS related stuff doesn't belong here but I guessed, oh well it's still MYSQL right?
Nonetheless here's what's happening
I was just trying to running a migration as usual when I encountered the following error
Syntax error or access violation: 1044 Access denied for user 'admin'@'%' to database 'mydatabase'
Started yesterday after an minor upgrade to mysql 8.0.2.9 to 8.0.3.3, might be a coincidence but nothing was changed on rds and or it's users.
I started to think that this minor upgrade led to loss of privileges but I ran SHOW GRANTS for admin and it came back like this:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE ROLE, DROP ROLE ON *.* TO \admin\@% WITH GRANT OPTION;`
Apparently it should be working just fine, tried to create a new user with the same grants, came back the same error, flushed privileges and even rebooted RDS to no avail.
Prior to that (the minor upgrade) my rds instance was running low on storage, which I increased but the problem still persists.
Any ideas what could be happening?