On Friday 16 June 2006 02:40, Ghaffar wrote: > The same limitation is also in 4.1.x versions. > You have to edit the source of the client library and recompile.
I thought so too but fortunately for me we are both wrong... version: 4.1.15-Debian_1ubuntu5-log mysql> SHOW FULL FIELDS FROM `user`; +-----------------------+--------------- | Field | Type +-----------------------+--------------- | Host | varchar(60) | User | varchar(64) | Password | varchar(41) Would anyone know why there is such a lame and arbitrary limitation for username length ? I distribute a system solution so I can't just do a one-off recompile of source for a single installation. > > # mysql -e "ALTER TABLE user CHANGE User User CHAR(64)" mysql > > # mysqladmin -u root password 'abc' > > mysqladmin: unable to change password; error: > > 'Can't find any matching row in the user table' > > > > I know what I am doing is non-standard but being limited to > > 16 char usernames is unacceptable. Would anyone know of a > > workaround other than using postgresql ? > > > > Are there any table fixing programs that don't require a > > running mysql server ? --markc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
