[debian-mysql] Bug#461646: mysql-server-5.0: allowed to create database with reserved keyword, cannot drop

Logan Attwood attwood at cs.dal.ca
Sun Jan 20 05:04:11 UTC 2008

Package: mysql-server-5.0
Version: 5.0.32-7etch4
Severity: important

On a fresh mysql install, I used mysqladmin to create a database, but 
inadvertantly used "mysqladmin create database blah", and ended up 
creating a database called database. Once realized I fired up mysql (the 
interactive one), and attempted to drop it using "drop database 
database;", and was met with a syntax error. It appears as though you 
can create databases with reserved keywords, but you are unable to 
delete them.


-- System Information:
Debian Release: 4.0
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-5-686
Locale: LANG=en_CA.UTF-8, LC_CTYPE=en_CA.UTF-8 (charmap=UTF-8)

Versions of packages mysql-server-5.0 depends on:
ii  adduser                3.102             Add and remove users and groups
ii  debconf [debconf-2.0]  1.5.11etch1       Debian configuration management sy
ii  libc6                  2.3.6.ds1-13etch4 GNU C Library: Shared libraries
ii  libdbi-perl            1.53-1etch1       Perl5 database interface by Tim Bu
ii  libgcc1                1:4.1.1-21        GCC support library
ii  libmysqlclient15off    5.0.32-7etch4     mysql database client library
ii  libncurses5            5.5-5             Shared libraries for terminal hand
ii  libreadline5           5.2-2             GNU readline and history libraries
ii  libstdc++6             4.1.1-21          The GNU Standard C++ Library v3
ii  libwrap0               7.6.dbs-13        Wietse Venema's TCP wrappers libra
ii  lsb-base               3.1-23.2etch1     Linux Standard Base 3.1 init scrip
ii  mysql-client-5.0       5.0.32-7etch4     mysql database client binaries
ii  mysql-common           5.0.32-7etch4     mysql database common files (e.g. 
ii  passwd                 1:      change and administer password and
ii  perl                   5.8.8-7etch1      Larry Wall's Practical Extraction 
ii  psmisc                 22.3-1            Utilities that use the proc filesy
ii  zlib1g                 1:1.2.3-13        compression library - runtime

Versions of packages mysql-server-5.0 recommends:
pn  mailx                         <none>     (no description available)

-- debconf information excluded

More information about the pkg-mysql-maint mailing list