Media Wiki Admin Account

[Labmonkey]

I recently installed mediawiki on my hosting thing, and when I finished, and tried to log in with the admin account, it did not let me, saying that no such account existed. I checked the mysql database, and assumed that accounts would be under "users". There was no information there. I created a new account, and it let me use the same username/password of the admin account. Now I do not know how to make that account have admin access. Can anyone help?

[cowctcat]

Reinstall
Thats all i can say i recently installed mediawiki and it worked fin for me

[Labmonkey]

Well does anyone know how i can make my existing account an admin account through the mysql?

[diabolo]

I have not seen the mysql db, but from what I think they might have done.

try finding a column that has 'membergroup' or similar, and admin rights should be '1' or '0'. Also make sure you backup your db, because I am not totally sure

[shaiaqua]

Mediawiki's installer has fields for admin username and password. If you don't remember what you put there, you need to reinstall. If you want to do it from the mysql database, you need to look in _user for your username, and remember the user_id. Then, insert ug_user: USER_ID and ug_group: bureaucrat into _user_groups. That will let you change user permissions from mediawiki.

[Labmonkey]

Thanks i will try it. Sorry I didn't reply earlier, I was very busy with other things and sort of forgot...

[MaestroFX1]

I don't remember it exactly but did once...
Go to phpmyadmin-->select your database
type
**********
UPDATE user SET user_password =
md5(CONCAT('123-',md5('newpassword'))) WHERE user_id=123;
**********
This updates your administrator's password and hence letting you in.