Posted by
Unknown
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/downloadThen 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