Specified key was too long ...

Submitted by Tracy Mehlin on Wed, 11/23/2011 - 13:57
in

Using the Maintenance program I initiated a new MySQL database. This error was displayed after I entered User Information: "Specified key was too long; max key length is 1000 bytes."
The Maintenance program doesn't give any option to go Previous or Next or Finish, only cancel.

I can see a record created in the user table for the user name I entered and this for the password:
"[BLOB - 16 B]".

My password was 8 characters, with uppercase, lowercase, numbers and a symbol. Is this the cause of the error, or something else?

‹ Installing on Linux machine. There is a problem initializing hibernate. Please contact your system administrator. ›

Re: Specified key was too long ...

Submitted by annie_ucsd on Wed, 11/23/2011 - 16:03.

Hi, Tracy,

I believe this FAQ applies to the situation you describe:

http://archiviststoolkit.org/node/60

Best wishes,
Annie

What we're using is hosted by

Submitted by Tracy Mehlin on Wed, 11/23/2011 - 18:43.

What we're using is hosted by our University on the department web server (Apache) and we have a number of other databases running from it.
I will investigate to see what I can edit in config files for our MySQL Server. I know the recommended storage engine is MyISAM.