The manual says that starting from MySQL 3.23.6, any combination of characters is allowed for a database name (excluding '/', ASCII(0) and ASCII(255)). I created database that name consist only of numbers using mysqladmin tool, but I was unable to drop it using mysql command line client (neither I was able to create database with that kind of name):

ERROR 1064: You have an error in your SQL syntax near '12345' at line 1

mysqladmin create 12345 echo "drop database 12345" | mysql

on i386 TCX Datakonsult AB, by Monty

Server version 3.23.33 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 11 min 28 sec

Threads: 2 Questions: 399824 Slow queries: 0 Opens: 24 Flush tables: 1 Open tables: 12 Queries per second avg: 581.140

<machine, os, target, libraries (multiple lines)> System: FreeBSD commonwealth.interia.pl 4.2-RELEASE FreeBSD 4.2-RELEASE #1: Fri Feb 23 12:39:22 CET 2001 root@commonwealth.inter ia.pl:/usr/src/sys/compile/COMMONWEALTH i386

Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='cc' CFLAGS='-mcpu=pentiumpro -march=pentiumpro' CXX='c++' CXXFLAGS='-mcpu=pentiumpro -march=pentiumpro -fel ide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1169076 Nov 20 12:59 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 9 Feb 23 12:51 /usr/lib/libc.so -> libc.so.4 -r--r--r-- 1 root wheel 559196 Nov 20 12:59 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/home/mysqld/data --without-perl --without-debu g --without-readline --without-bench --with-mit-threads=no --with-libwrap --with-low-memory --enable-assembler -- with-charset=latin2 --prefix=/usr/local/mysql i386--free bsd4.2 Perl: This is perl, version 5.005_03 built for i386-freebsd