Text only | Text with Images

VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: Hiflo on July 14, 2013, 13:27:54 PM

Title: Login Problem MySQL
Post by: Hiflo on July 14, 2013, 13:27:54 PM
Hi,

Joomla V2.5.11 VM V2.0.0 Apache V2.2.21 PHP V5.2.17

Ummmm I went into VM Shopping, Vendors & deleted myself - yep I did  :-[

Didn't think much of it at the time but I can't login to my Joomla Back-End "Username and password do not match or you do not have an account yet."

So I went into MySQL database for Joomla - jos_users & I'm still listed there, I presumed I wouldn't be - Oh Dear!

Tried adding new username & password ie: admin2 / secret = d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199 which would normally get one out of trouble but no luck there either.

Looking for a short rope with a loop on one end & a high beam.

Hoping someone can help.

I do have a last resort, I pay extra to have my server do a back-up every weekend, I'll lose a weeks work but I deserve it for being stupid  :-\

Thank You
Title: Re: Login Problem MySQL
Post by: PRO on July 14, 2013, 13:55:39 PM
register,

then go to phpmyadmin

and set it to "Super Administrator" in "usertype "
Title: Re: Login Problem MySQL
Post by: Hiflo on July 14, 2013, 14:30:57 PM
Quote from: PRO on July 14, 2013, 13:55:39 PM
register,

then go to phpmyadmin

and set it to "Super Administrator" in "usertype "

Hi Pro

Thank you kindly for your time, followed your directions & that should have worked but of course didn't, I've screwed something up.
Title: Re: Login Problem MySQL
Post by: franzpeter on July 14, 2013, 16:15:52 PM
You may take a look at this page. Maybe it helps:  http://www.ostraining.com/support-forum/joomla-support/deleted-admin-account-by-accident/ (http://www.ostraining.com/support-forum/joomla-support/deleted-admin-account-by-accident/)
Or even Joomla gives some suggestions here how to recover lost admin: http://docs.joomla.org/How_do_you_recover_your_admin_password%3F (http://docs.joomla.org/How_do_you_recover_your_admin_password%3F)
Title: Re: Login Problem MySQL
Post by: Hiflo on July 14, 2013, 17:15:30 PM
Quote from: franzpeter on July 14, 2013, 16:15:52 PM
You may take a look at this page. Maybe it helps:  http://www.ostraining.com/support-forum/joomla-support/deleted-admin-account-by-accident/ (http://www.ostraining.com/support-forum/joomla-support/deleted-admin-account-by-accident/)
Or even Joomla gives some suggestions here how to recover lost admin: http://docs.joomla.org/How_do_you_recover_your_admin_password%3F (http://docs.joomla.org/How_do_you_recover_your_admin_password%3F)

Thank You,

I tried the later of your links earlier, I'll give the prior one a shot.

Reminds me of the times my missus locked me outside.

Thank You
Title: Re: Login Problem MySQL
Post by: Hiflo on July 14, 2013, 21:31:57 PM
Hi,

Thanks Guys, problem solved.

Cheers
The Flo'
Text only | Text with Images