Is it possible to access an Aiven MySQL user with root access? We need to use some DBA-only roles to administer our database, but the default user (avnadmin) does not have these permissions
Specifically, I need to make some modifications (add entries) to the mysql.time_zone tables + add some foreign key relationships there.
I don’t believe this is possible, although you can set the default time zone (you probably already saw this list in the console). Aiven tends to lock down superuser access because it can be used to mess with e.g. on disk setup.
Ah that’s unfortunate, this will prevent us from using Aiven in prod
As of my knowledge, default user (avnadmin) does not have root access to MySQL. To make modifications to system tables like mysql.time_zone or add foreign key relationships, you should contact Aiven’s support team for assistance.
Best Regard
Danish hafeez | QA Assistant
ICTInnovations