Topic: Joomla admin user not working

[Bud]

one more problem

i'm trying to get access as joomla admin. when i type in my Joomla admin/password i get an error:

Username and password do not match

any help greatly appreciated

[cactus]

i'm trying to get access as joomla admin. when i type in my Joomla admin/password i get an error:

Username and password do not match

That really is a Joomla related error, which indicates that your username and password are incorrect. You should try and recreate your admin user or reset it's password I guess.

You could try and reset it by using something like this on your SME Server command line:

Code: [Select]

mysql -e "USE your_joomla_db_here; UPDATE jos_users SET password=MD5('enter your desired password here') WHERE user='admin';"
Replace the inidicated parameters with the appropriate values and retry.

Edit: Adjusted query to be specific

[Stefano]

You could try and reset it by using something like this on your SME Server command line:

Code: [Select]

mysql -e "USE your_joomla_db_here; UPDATE jos_users SET password=MD5('enter your desired password here');"Replace the inidicated parameters with the appropriate values and retry.

I'm not a joomla fan/guru, but I suspect that you should put a "where" condition in a "update" query, otherwise you'll change the password of ALL users in jos_users

my 2€c

[cactus]

I'm not a joomla fan/guru, but I suspect that you should put a "where" condition in a "update" query, otherwise you'll change the password of ALL users in jos_users

Oops, thanks for pointing that out... to quick to jump the gun I guess. I corrected my original post.

my 2€c

Now that's value for money...

[Bud]

thanks for the help guys

just to make sure i get you right

mysql -e "USE your_joomla_db_here; UPDATE jos_users SET password=MD5('enter your desired password here');"

the password=MD5 - must this be a MD5 password or can i use my password being eg. " password "

also when i look at my " jos_users " table in phpmyadmin it almost seems as if there are no user names
how do i check this

sorry for the noob questions

[cactus]

Code: [Select]

mysql -e "USE your_joomla_db_here; UPDATE jos_users SET password=MD5('enter your desired password here');"

Please use the corrected one, with the WHERE clause.

the password=MD5 - must this be a MD5 password or can i use my password being eg. " password "

Yes you can use your plain text password as it will encrypt it for you.

also when i look at my " jos_users " table in phpmyadmin it almost seems as if there are no user names
how do i check this

If that is the case you might have done something wrong during or after installation, normally during installation a admin user is created with a password you choose. Did you run some sort of setup?

[cactus]

Bud, I have taken the liberty to split the thread and to give it a matching subject. Please make a habit of creating separate threads for separate problems with a proper subject so it is easier for readers to indicate whether they are interested or not. Thanks in advance.

[Bud]

cactus thanks for your help

yes i did do an fresh install and it seems that there is no admin user (using a joomla template)

what to do?

any help greatly appreciated

[cactus]

yes i did do an fresh install and it seems that there is no admin user (using a joomla template)

I think you need to get your facts straight. Templates have noting to do with authentication and authorisation AFAICT. They are for layouts and looks.

Please try and explain how and using what steps you used to install joomla, so we can try and diagnose what you might have forgotten or done wrong.

If you followed the steps from this page your username and password should have both been admin according to the Use section.

[Bud]

cactus thanks for the help

i have uninstalled joomla and reinstalled joomla

phpmyadmin is working fine

joomla is wokring however

i just cannot seem to get admin access into joomla

what can i do to reset the admin password for joomla?

thanks again