1
Haakon
Creating admin-user with phpMyAdmin
  • 2008/3/25 11:58

  • Haakon

  • Just popping in

  • Posts: 45

  • Since: 2002/1/25


What are the steps to create a new admin-user with phpMyAdmin?

My original admin can't access the site, so I can't access the admin-page at all...

I am not quite certain which version I am on. Where can I find the version-number? It says 2.0 at the bottom of the page (www.smartsoftware.org).
CellphoneTuition - SMS Poems, articles, videos and more for your Cellular phone!

2
stefan88
Re: Creating admin-user with phpMyAdmin
  • 2008/3/25 13:01

  • stefan88

  • Community Support Member

  • Posts: 1086

  • Since: 2004/9/20


Quote:
I am not quite certain which version I am on. Where can I find the version-number? It says 2.0 at the bottom of the page (www.smartsoftware.org).


go to your include folder and look in version.php file - should have something like"

define("XOOPS_VERSION","....
..

3
Haakon
Re: Creating admin-user with phpMyAdmin
  • 2008/3/25 16:05

  • Haakon

  • Just popping in

  • Posts: 45

  • Since: 2002/1/25


Thank you. I am at 2.0.16.

Would appreciate any help I can get to be able to use my site...
CellphoneTuition - SMS Poems, articles, videos and more for your Cellular phone!

4
Anonymous
Re: Creating admin-user with phpMyAdmin
  • 2008/3/25 16:18

  • Anonymous

  • Posts: 0

  • Since:


1. If you don't don'y know your user-id (uid) number then, using phpmyadmin, navigate to the yourprefix_users table and find it there.

Then:

2. navigate to the yourprefix_groups_users_link table, find your userid number and edit your details so that your uid has an entry of 1 in the groupid column.

This should give you admin rights so that when you login you can get to the admin panel from the User Menu.

As always, backup your database before editing it just in case......

HTH

5
Haakon
Re: Creating admin-user with phpMyAdmin
  • 2008/3/25 18:05

  • Haakon

  • Just popping in

  • Posts: 45

  • Since: 2002/1/25


My UID is 1, and groupid is set to 1 as well... :(

Any other suggestions?
CellphoneTuition - SMS Poems, articles, videos and more for your Cellular phone!

6
stefan88
Re: Creating admin-user with phpMyAdmin
  • 2008/3/25 19:27

  • stefan88

  • Community Support Member

  • Posts: 1086

  • Since: 2004/9/20


If you have protector, you may be blocked - check if that is the case (readme of protector).

You may request new pasword for the admin to be send to mail adress.

You may register new user and put it admin group - set group id to 1.
..

7
Haakon
Re: Creating admin-user with phpMyAdmin
  • 2008/3/26 18:54

  • Haakon

  • Just popping in

  • Posts: 45

  • Since: 2002/1/25


Thanks a lot to you all. I created a new user and edited the groupid in the groups_users_link-table. That did the trick! :)
CellphoneTuition - SMS Poems, articles, videos and more for your Cellular phone!

8
Anonymous
Re: Creating admin-user with phpMyAdmin
  • 2008/3/26 19:36

  • Anonymous

  • Posts: 0

  • Since:


Excellent

You are now in control.......so anything that goes wrong is your fault

Login

Who's Online

225 user(s) are online (148 user(s) are browsing Support Forums)


Members: 0


Guests: 225


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits