Call or Whatsapp: 08086697100

Trendy:

SMS Solution Center

Blog

  • Written by Ebenezer Omotere

How To Add New User in Joomla Using PHPMyAdmin

If you need to create  new Joomla user, but for some reason can’t do it through Joomla administration, best option  is using phpMyAdmin.

1. Log into phpMyAdmin (username & password is in configuration.php file,  search for public $user and public $password ).

2.On top, click SQL. Change following code accordingly to your needs:
phpMyAdmin add Joomla user

  • change database to actual database name If you don’t know database name site’s using, it’s in configuration.php file, search for public $db.
  • change prefix_to database’s prefix
  • in this example, login name is user and password is  password ( password will be stored in database as 5f4dcc3b5aa765d61d8327deb882cf99. For another password, go to step 3)
INSERT INTO `database`.`prefix_users`
(`id`, `name`, `username`, `email`, `password`, `usertype`, `block`,
`sendEmail`, `registerDate`, `lastvisitDate`, `activation`, `params`)
VALUES ('62', 'Super User', 'user', ' This email address is being protected from spambots. You need JavaScript enabled to view it.',
'5f4dcc3b5aa765d61d8327deb882cf99',
'Super Administrator', '0', '1', '2012-08-06 00:00:00', '2012-08-06 00:00:00',
'', '{}');

For Joomla 1.7 and 2.5 also run this code:

INSERT INTO `database`.`prefix_users` (
`user_id` ,
`group_id`
)
VALUES (
'62', '8'
);

3. About passwords: as Joomla stores passwords in MD5 format, you need to convert password in MD5. Visit MD5 Converter , write password, hit button and copy generated MD5 string.
For example, MD5 version of password is 5f4dcc3b5aa765d61d8327deb882cf99

4. Congratulations, you’ve successfully added user via phpMyAdmin. You can now log into Joomla administration!

SMS PORTAL AND JOOMLA TUTORIAL

How to use Recaptcha in Joomla

09 December 2016 - 135 Views
...

Bulk SMS Portal Creator V4 Complete Manual

14 October 2016 - 757Views

SMS Portal Creator is the

...

How to fix it No installation plugin has been enabled - Joomla 3.6

09 September 2016 - 833 Views

Joomla 3.6 is a new

...

DND Policy - How to Deactivate it

13 August 2016 - 1078Views
...

Guest Level Members

28 July 2016 - 422Views

If you are interested in

...

How to Run a Successful SMS Marketing Campaign

12 June 2016 - 700 Views

SMS - invest in

...

Put a background image or color on an article

29 September 2015 - 1072Views
...

How to Fix jquery Issue in joomla

21 July 2015 - 1633Views

How to JQUERRY ISSUE in

...

How to Fix SMS Counters Issue

21 July 2015 - 1784 Views

How to JQUERRY ISSUE in

...

Accessing cPanel

07 February 2014 - 1654Views

To access

...

An Introduction to Branding cPanel for your users

07 February 2014 - 1586Views

How to Create a new

...

An introduction to reseller access within WHM

07 February 2014 - 2824 Views

What is reseller access

...

Automated database backup for SPC High Earner

06 February 2014 - 1432Views

SPC high earner comes

...

Creating MySQL Database and User

22 February 2014 - 1964 Views

Creating a MySQL database

...

Cron Settings for SMS Scheduling

06 February 2014 - 2003Views
  A
...

Download Now

09 March 2014 - 4022Views

Here is a PDF version of

...

HOW TO ADD MENU IN JOOMLA 2.5

05 February 2014 - 6772 Views

To create a

...

How To Add New User in Joomla Using PHPMyAdmin

15 March 2014 - 1917Views

If you need to create 

...