Azure mysql create database #mysql50# prefix

ff 1 Reputation point
2021-04-27T07:30:16.48+00:00

I created database xxx in Mysql Azure in the south of the UK, but the database name I created was
#mysql50#.xxx.

eg:
CREATE DATABASE xxx

   show databases;  
   #mysql50#.xxx  

mysql version:5.7

General purpose, 4 vCore, 256 GB

![91674-image.png

I can drop using the following statement, but create database is just the beginning of #mysql50#

   USE xxx;  
   DROP DATABASE xxx;  

I found my database name does not contain-is normal. Once added-the #mysql50# prefix is automatically added

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
986 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator
    2021-04-28T11:36:30.08+00:00

    Hello @ff Re-starting the server will help. Please let me know if that resolve the issue. Thanks

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.