From: Tauren Mills
Date: March 20 1999 3:38am
Subject: RE: Length of Database name field inconsistent
List-Archive: http://lists.mysql.com/mysql/677
Message-Id: <002801be7283$2ccf06c0$1ad7a2d1@yowza.easystreet.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hmmm.  Looks like I need to upgrade this server.  I've got 3.22.14-gamma
running on my Solaris box, but I haven't upgraded this Linux box yet.  Here
is the version info:

# mysqladmin version
mysqladmin  Ver 7.8 Distrib 3.22.13-beta, for pc-linux-gnu on i686
TCX Datakonsult AB, by Monty

Server version          3.22.13-beta
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 78 days 13 hours 19 min 7 sec

Threads: 3  Questions: 58513  Slow queries: 67  Opens: 263  Flush tables: 1
Open tables: 63


> -----Original Message-----
> From: Paul DuBois [mailto:paul@stripped]
> Sent: Friday, March 19, 1999 7:12 PM
> To: Tauren Mills; mysql@stripped
> Subject: RE: Length of Database name field inconsistent
>
>
> At 8:53 PM -0600 3/19/1999, Tauren Mills wrote:
> >> According to the manual, a database name can be up to 64 characters
> >> long (ch. 7):
> >>
> >> >@item
> >> >A database, table, index or column name can be up to 64
> >> characters long. An
> >> >alias name can be up to 256 characters long.
> >>
> >> ??? The Db field is not 32 characters long in any grant table.  How
> >> do you get that figure?  The field is 64 characters long in both the
> >> db and host tables:
> >
> >Hmmm.  Maybe I posted a little hastily (before looking it up in
> the manual).
> >Sorry.  I got that figure by doing a dump of the mysql database:
> >
> >mysqldump mysql > mysql.db
> >
> >Here is part of the file:
> >
> >CREATE TABLE db (
> >  Host char(60) DEFAULT '' NOT NULL,
> >  Db char(32) DEFAULT '' NOT NULL,
> >  User char(16) DEFAULT '' NOT NULL,
> >...
> >  PRIMARY KEY (Host,Db,User),
> >  KEY User (User)
> >);
> >
>
> Hm, that's odd.  Here's what I get:
>
> #
> # Table structure for table 'db'
> #
> CREATE TABLE db (
>   Host char(60) DEFAULT '' NOT NULL,
>   Db char(64) DEFAULT '' NOT NULL,
>   User char(16) DEFAULT '' NOT NULL,
>   Select_priv enum('N','Y') DEFAULT 'N' NOT NULL,
>   Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL,
>   Update_priv enum('N','Y') DEFAULT 'N' NOT NULL,
>   Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL,
>   Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,
>   Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL,
>   Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL,
>   References_priv enum('N','Y') DEFAULT 'N' NOT NULL,
>   Index_priv enum('N','Y') DEFAULT 'N' NOT NULL,
>   Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL,
>   UNIQUE Host (Host,Db,User),
>   KEY User (User)
> );
>
>
> What version of MySQL are you running?
>
> --
> Paul DuBois, paul@stripped
> Northern League Chronicles: http://www.snake.net/nl/
>