Comments

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:
http://sourceforge.net/projects/adminer/files/Adminer/Adminer%203.3.4/adminer-3.3.4-mysql-en.php/download
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