Create Administrator User Joomla via phpMyAdmin or MySql Query

Posted by Ridley Scott 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