From: Paul DuBois Date: March 20 1999 3:12am Subject: RE: Length of Database name field inconsistent List-Archive: http://lists.mysql.com/mysql/676 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" 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/