Issue Ubuntu 20 to 22 upgrade fails with RDS db

[Aldemir Akpinar]

Server operating system version

Ubuntu 22.04

Plesk version and microupdate number

18.0.77 Update #2

Hi,
My upgrade failed because I'm using an RDS server. On RDS you can't have SUPER users, anyway here's my ERROR output:

ERROR: Upgrade step 2025-11-05-09-56-08_FixGrantPrivileges.php failed with code 1 and output:
INFO: Executing upgrade task: 2025-11-05-09-56-08
[2026-05-04 09:35:21.008] 10351:69f8685901d72 ERR [panel] SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'remote-rds-user'@'%' to database 'mysql':
0: /opt/psa/admin/plib/Upgrade/upgrade.php:46
ERROR: Plesk\Upgrade\Exception: SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'remote-rds-user'@'%' to database 'mysql' (upgrade.php:46)

Here are the grants for my user:

MySQL [(none)]> SHOW GRANTS FOR 'remote-rds-user'@'%';
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for remote-rds-user@%                                                                                                                                                                                                                                                                                                                                      |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 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 `remote-rds-user`@`%` WITH GRANT OPTION |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.002 sec)

 

[Sebahat.hadzhi]

Hi, @Aldemir Akpinar . An in-place upgrade is not the best option if you store websites databases in AWS RDS. In such a scenario, the recommended approach is a migration.

 

[Aldemir Akpinar]

Hi, @Aldemir Akpinar . An in-place upgrade is not the best option if you store websites databases in AWS RDS. In such a scenario, the recommended approach is a migration.

Thanks for the prompt reply, could you point me to do the docs for migration? Also how is my system impacted right now? Eveything apart from the problem above looks ok, and I can't restart my process now.
So If I understand correctly, is the problem with db server being elsewhere (not local) or RDS?