Is it possible to CREATE DATABASE in MariaDB on the Swisscom Cloud? I know I can do this on Amazon RDS, but I'm not sure if this is possible on the Swisscom Cloud. If not: it would be an important feature to add.
Sorry this is not possible. You receive database space on a shared Galera Cluster (MariaDB) where you are granted all privileges in your own database.
Galera Cluster for MySQL is a true Multimaster Cluster based on synchronous replication. Galera Cluster is an easy-to-use, high-availability solution, which provides high system uptime, no data loss and scalability for future growth.
> SHOW GRANTS FOR CURRENT_USER();
+----------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for 2RQGCnSeAmJTWYwX@% |
+----------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO '2RQGCnSeAmJTWYwX'@'%' IDENTIFIED BY PASSWORD '$HASH' WITH MAX_USER_CONNECTIONS 10 |
| GRANT ALL PRIVILEGES ON `CF_32FD02B6_9B18_473D_A4D8_C84E19EC6F2C`.* TO '2RQGCnSeAmJTWYwX'@'%' |
+----------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.01 sec)
Here the error (Access denied) when creating a new database
MariaDB [CF_32FD02B6_9B18_473D_A4D8_C84E19EC6F2C]> create database rokfor;
ERROR 1044 (42000): Access denied for user '2RQGCnSeAmJTWYwX'@'%' to database 'rokfor'
Please subscribe to our newsletter for new feature announcements.