[Mediawiki-l] No sysop user got created after installation

[Tim Starling]

Rob Church wrote:
> On 06/07/07, Tim Starling <tstarling at wikimedia.org> wrote:
>> You probably chose the "MySQL 5 binary" schema. Ha ha, tricked you. If so,
>> it should be fixed in 1.11.
> 
> Yes...
> 
> Anyway, to sort out the problem for now, create a new user in the
> normal method, check the user's identifier in Special:Preferences, and
> then insert a couple of rows into the `user_groups` table in the
> database, like so:
> 
> INSERT INTO `user_groups` ( `ug_user`, `ug_group` ) VALUES ( 1,
> "sysop" ), ( 1, "bureaucrat" );

In the MySQL 5 binary schema in 1.10.0, the ug_group column will be
zero-padded, so "sysop" becomes "sysop\0\0\0\0\0\0...". This causes it to
not match the sysop group in the configuration. The way to fix this is to
reinstall the wiki with the MySQL 5 UTF-8 schema if possible, or the 4.0.x
compat schema if not.

If there is a need to preserve data in the broken wiki, you can create a
new fixed wiki in a separate DB, drop the old broken user_groups table,
and rename the new one into the old one's place.

-- Tim Starling