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/
