26 Juli 2012

Create Administrator User Joomla via phpMyAdmin or MySql Query

Posted by at 13.48 Read our previous post
How To Create Administrator User in Joomla via phpMyAdmin or MySQL Query?
This is some step that very easy:
Login to your Cpanel >> Select menu phpMyAdmin

Enter to phpMyAdmin joomla database

But I get this error on IdHostinger Cpanel
Then I will use adminer >> goto FileManager

Select Upload on Top Menu Net2ftp File Manager
Download adminer here:
Then Upload adminer 3.3.4
Open adminer in the browser
Enter MySql Login Details, you can find on the configuration.php

Then on adminer select joomla database, that on configuration.php is declared by $db

Maybe not same name with your database name

then select jos_users, or can defferent prefix like this

Your joomla prefix can you see in configuratiom.php declared by $dbprefix

then on adminer clone the user data

But I get this error CPU EXEEDED one some web hosting then use adminer

No problem I will continued
Change the ID with 9999, change username with admin9999, change password with 433903e0a9d6a712e00251e44d29bf87:UJ0b9J5fufL3FKfCc0TLsYJBh2PFULvT
and change usertype with Super Administrator
then on adminer, select jos_core_acl_aro

clone some data or insert new data and in the id and value column, change with 9999
then select jos_core_acl_groups_aro_map

clone some data or insert, then change group_id with 25 and aro_id with 9999

Completed, Then goto yoursite/administrator
Login with
username: admin9999
Password: admin

Then taraaa... success login as administrator again in your joomla site

Supported by Android App Download! ©2012 Ramnul All Content Copyrighted and may not reproduced on other website