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 - 69 Views
...

Bulk SMS Portal Creator V4 Complete Manual

14 October 2016 - 462Views

SMS Portal Creator is the

...

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

09 September 2016 - 575 Views

Joomla 3.6 is a new

...

DND Policy - How to Deactivate it

13 August 2016 - 770Views
...

Guest Level Members

28 July 2016 - 368Views

If you are interested in

...

How to Run a Successful SMS Marketing Campaign

12 June 2016 - 667 Views

SMS - invest in

...

Put a background image or color on an article

29 September 2015 - 1038Views
...

How to Fix jquery Issue in joomla

21 July 2015 - 1596Views

How to JQUERRY ISSUE in

...

How to Fix SMS Counters Issue

21 July 2015 - 1741 Views

How to JQUERRY ISSUE in

...

Accessing cPanel

07 February 2014 - 1626Views

To access

...

An Introduction to Branding cPanel for your users

07 February 2014 - 1556Views

How to Create a new

...

An introduction to reseller access within WHM

07 February 2014 - 2790 Views

What is reseller access

...

Automated database backup for SPC High Earner

06 February 2014 - 1397Views

SPC high earner comes

...

Creating MySQL Database and User

22 February 2014 - 1911 Views

Creating a MySQL database

...

Cron Settings for SMS Scheduling

06 February 2014 - 1957Views
  A
...

Download Now

09 March 2014 - 3905Views

Here is a PDF version of

...

HOW TO ADD MENU IN JOOMLA 2.5

05 February 2014 - 6548 Views

To create a

...

How To Add New User in Joomla Using PHPMyAdmin

15 March 2014 - 1879Views

If you need to create 

...