Creating admin-user with phpMyAdmin [Beginner's Corner]

1

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 (http://www.smartsoftware.org).

CellphoneTuition - SMS Poems, articles, videos and more for your Cellular phone!

2

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 (http://www.smartsoftware.org).

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

define("XOOPS_VERSION","....

..

3

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

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

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

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

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

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

Stats
Goal:	$100.00
Due Date:	Nov 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Creating admin-user with phpMyAdmin

Re: Creating admin-user with phpMyAdmin

Re: Creating admin-user with phpMyAdmin

Re: Creating admin-user with phpMyAdmin

Re: Creating admin-user with phpMyAdmin

Re: Creating admin-user with phpMyAdmin

Re: Creating admin-user with phpMyAdmin

Re: Creating admin-user with phpMyAdmin

Login

Search

Recent Posts

XOOPS MyMenus 1.54.0 Beta 10

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}