Just in the last day, whenever I create a new database, it is prepending the database name with:
#mysql50#
And I am unable to connect to this database. Im having real issues on our PROD server as we create a new database often. Please see the image below.
We're running the following command:
CREATE DATABASE IF NOT EXISTS `bru_1111-userId`;
Im unsure what to do? Its a hosted MYSQL with Azure - so I have no idea how to login and delete folders as suggested here:
https://dba.stackexchange.com/questions/34385/strange-mysql-database-that-i-cant-select
Please help!
So our fix for this was to make sure databases werent created with any hyphens in them. My suspicion here is the DB was upgraded and this rule of no hyphens enforced on our Azure Mysql servers. Now we use underscores instead.