Databases with weird character names break queries

[Znuff]

As per title, one of my users has a database called: dragon_Ul)e@k!#dERs$_OLD.

This in turn breaks MySQL Tuner:

-------- Storage Engine Statistics -----------------------------------------------------------------
[--] Status: +Aria +CSV +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA +SEQUENCE
[--] Data in MyISAM tables: 18.1G (Tables: 27599)
[--] Data in InnoDB tables: 18.4G (Tables: 52391)
[--] Data in MEMORY tables: 0B (Tables: 250)
[OK] Total fragmented tables: 0
[!!] Failed to execute: SHOW TABLE STATUS FROM \`dragon_Ul)e@k!#dERs$_OLD\`
[!!] FAIL Execute SQL / return code: 256

[jmrenouard]

Hi @Znuff
Nice name for a database

I try to find what going wrong with that !

[Znuff]

Well, the DB name seems to actually be valid.

I know, I couldn't believe it myself.

Yes, it's a terrible name.

[jmrenouard]

hi @Znuff
Can you send me a show create database result ?

[Znuff]

Sure:

MariaDB [(none)]> show create database `dragon_Ul)e@k!#dERs$_OLD` \G
*************************** 1. row ***************************
       Database: dragonpc_Ul)e@k!#dERs$_OLD
Create Database: CREATE DATABASE `dragon_Ul)e@k!#dERs$_OLD` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci */
1 row in set (0.000 sec)

[Znuff]

Still happening with mysqltuner 2.5.0 (same DB).