Call or Whatsapp: +2348086697100

Trendy:

Start The Online Business of Your Dream, Get Free SMS Website!

    • Premium

    • Setup Fee N25,000 Subsequent Renewal N15,000

      • Site Setup Within 24 Hours
      • Buy SMS as low as N0.90kobo
      • 25GB Web Disk
      • Unlimited Monthly Bandwidth
      • SEO Optimized Website
      • Responsive SMS Website
      • Free Custom API
      • Free Marketing Tools
      • Free Instant Support
      • Free 500 SMS Credit
      • cPanel/WHM TO RESELL/HOST SITES
      • Sell to Resellers
      • One Free Domain .com.ng, .net.ng, .mobi.ng Only.
    • SIGNUP
    • ADVANCE

    • Setup N15,000 Subsequent Renewal N10,000

      • Site Setup Within 24 Hours
      • Buy SMS as low as N0.90kobo
      • 2GB Web Disk
      • 30GB Monthly Bandwidth
      • SEO Optimized Website
      • Responsive SMS Website
      • Free Custom API
      • Free Marketing Tools
      • Free Instant Support
      • Free 500 SMS Credit
      • Sell to Resellers
      • One Free Domain .com.ng, .net.ng, .mobi.ng Only.
    • SIGNUP
responsive pricing table joomla

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!