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

Bulk SMS Portal Creator V4 Complete Manual

14 October 2016 - 153Views

SMS Portal Creator is the

...

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

09 September 2016 - 292Views

Joomla 3.6 is a new

...

DND Policy - How to Deactivate it

13 August 2016 - 413 Views
...

Guest Level Members

28 July 2016 - 304Views

If you are interested in

...

How to Run a Successful SMS Marketing Campaign

12 June 2016 - 626Views

SMS - invest in

...

Put a background image or color on an article

29 September 2015 - 1003 Views
...

How to Fix jquery Issue in joomla

21 July 2015 - 1544Views

How to JQUERRY ISSUE in

...

How to Fix SMS Counters Issue

21 July 2015 - 1694Views

How to JQUERRY ISSUE in

...

Accessing cPanel

07 February 2014 - 1571 Views

To access

...

An Introduction to Branding cPanel for your users

07 February 2014 - 1510Views

How to Create a new

...

An introduction to reseller access within WHM

07 February 2014 - 2691Views

What is reseller access

...

Automated database backup for SPC High Earner

06 February 2014 - 1346 Views

SPC high earner comes

...

Creating MySQL Database and User

22 February 2014 - 1845Views

Creating a MySQL database

...

Cron Settings for SMS Scheduling

06 February 2014 - 1864 Views
  A
...

Download Now

09 March 2014 - 3681Views

Here is a PDF version of

...

HOW TO ADD MENU IN JOOMLA 2.5

05 February 2014 - 6220Views

To create a

...

How To Add New User in Joomla Using PHPMyAdmin

15 March 2014 - 1825 Views

If you need to create 

...

How to Choose the Best Web Hosting Provider

07 February 2014 - 1520Views
...