List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 20 1999 3:12am
Subject:RE: Length of Database name field inconsistent
View as plain text  
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/
Thread
Length of Database name field inconsistentTauren Mills20 Mar
  • Re: Length of Database name field inconsistentPaul DuBois20 Mar
    • RE: Length of Database name field inconsistentTauren Mills20 Mar
      • RE: Length of Database name field inconsistentPaul DuBois20 Mar
        • RE: Length of Database name field inconsistentTauren Mills20 Mar
RE: Length of Database name field inconsistentTauren Mills26 Mar
  • RE: Length of Database name field inconsistentMichael Widenius28 Mar
Re: Length of Database name field inconsistentEd Carp28 Mar