Im facing this error when trying to enable MySQL on a existing virtual server on a VirtualMin, this is also happening if I delete and recreate the virtualserver from the scratch.
Im using a remote MySQL server configured in System Settings > MySQL servers. Im using a remote Google SQL with a MySQL 5.7 version. This is the exact error Im receiving when creating a new virtual server:
Creating MySQL login …
… MySQL database failed! : mysql::execute_sql_logged failed : SQL delete from user where user = 'crust’and host = ‘localhost’ failed : Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Is remote SQL servers still not very supported under Virtualmin GPL version?
OS version: CentOS 7.9
Webmin version: 1.960
Virtualmin version: 6.13
I presume VirtualMin is trying to run some SQL queries that requires SUPER privileges in MySQL but this privilege isnt supported on Google SQL. Any advice how to fix this will be appreciated.