Service limitations of MySQL Database on Azure
MySQL Database on Azure currently has the following limitations. If you have any questions, contact technical support.
- As MySQL Database on Azure uses customized user account authentication plug-ins, user accounts can only be created in the Azure portal. Users cannot directly create database user accounts using the SQL command line.
- You can create databases only by using the management portal. Directly creating databases by using the SQL command line is not supported.
- Users do not have shutdown permissions, so users cannot shut down MySQL database servers.
- Users do not have super permissions, and so cannot change any global variables, for example. Find out more about MySQL 5.5 user permissions
- Users do not have file permissions. Find out more about MySQL 5.5 user permissions.
The MySQL built-in system table does not support write permissions, and read/write permissions are currently not supported for the following tables:
Data replication currently supports only data syncing between local and cloud servers, a feature that makes it easier for users to build hybrid cloud scenarios.
- The MyISAM storage engine is currently not supported. Although other non-InnoDB engines (except MyISAM) are available, in some particular circumstances these non-InnoDB engines may have some problems.