>From the 'user' table in the 'mysql' database:
mysql> describe user;
+-----------------+---------------+------+-----+---------+-------+
| Field           | Type          | Null | Key | Default | Extra |
+-----------------+---------------+------+-----+---------+-------+
| Host            | char(60)      |      | PRI |         |       |
| User            | char(16)      |      | PRI |         |       |
| password        | char(16)      |      |     |         |       |
.....

Looks like it is 16? :)
(You might be able to alter this yourself, BUT I will not guarantee that
it won't break anything)


Atle

On Wed, 28 Feb 2001, Tyrone Mills wrote:

> My apologies if this is an easy question. I've looked at the docs in the
> privilege section and haven't found a mention of the max length of password
> for MySQL. I want to set a fairly long one for each of my web servers that
> will be hitting my database server. Incase it is important, I'm running
> 3.23.33 on Redhat 7.0.
> 
> Anyone know how long they can go?
> 
> Thanks,
> 
> Tyrone
> ___________
> 
> ____________________________________________________
> UNIX is user-friendly, it's just picky about who its friends are... 
> 
> 
> 


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to