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/
>
