First published on MSDN on Jun 26, 2017
The SUPER privilege is not supported on Azure Database for MySQL. The closest you can get is to create another admin level user with the same rights as the server admin you created to do this you can run:
[code language="sql"]CREATE USER 'testuser'@'%' <span>IDENTIFIED </span>BY 'your_password_here';[/code]
[code language="sql"]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 ON *.* TO 'testuser'@'%' WITH GRANT OPTION;[/code]
You can get the privileges the admin account has by logging in as the admin account and running:
[code language="sql"]SHOW GRANTS FOR CURRENT_USER;[/code]
This does mean you cannot run things like SET GLOBAL, to set global level settings please use the properties items in the portal.
The SUPER privilege is not supported on Azure Database for MySQL. The closest you can get is to create another admin level user with the same rights as the server admin you created to do this you can run:
[code language="sql"]CREATE USER 'testuser'@'%' <span>IDENTIFIED </span>BY 'your_password_here';[/code]
[code language="sql"]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 ON *.* TO 'testuser'@'%' WITH GRANT OPTION;[/code]
You can get the privileges the admin account has by logging in as the admin account and running:
[code language="sql"]SHOW GRANTS FOR CURRENT_USER;[/code]
This does mean you cannot run things like SET GLOBAL, to set global level settings please use the properties items in the portal.
Updated Mar 14, 2019
Version 2.0
cbattlegear
Microsoft
Microsoft