Hello,

after moving my website to a new server, I can not login to my Joomla Backend. The table k2_users is empty, when I look into my MySQL database.

How can I insert a new admin user via MySQL into this table? Or can I do something else?

Do you have any ideas?

Thank you!

Mik

Hi,
Try this.

first execute this SQL command to add a new user to the users table

Write down the new user id created and then we add that user to the mapping table where assign it to the admin user group, by default id = 8. Change XX for the user id created.


Remember to change the #_ value for the prefix used in your joomla DB in both querys.

After that you can access with the following data:
user: newadmin
pass: admin

Hope it helps
Regards

Dear Olsen,

thank you for your answer. Unfortunately it is not working. When I want to login I get the message that I don't have access to the administration area of this website.

When I try to login with my admin data from my old server, I get the message that the user or the password is wrong or that this user does not exist...
:( Do you have any other ideas?

Thank you!

Do you have a backup of your old DB?

You can try either restoring an older backup or moving the user related DB tables.

Yes I have, but after the import, the user tables are empty. I created a new Joomla User, but with this user I even can't log in. I think I have to set up a k2 user manually into the database...

Open the old DB first to check if these tables are empty as well before entering new users.
It is important that you maintain the same DB structure.

PS. You will have to update your K2 items if they do no have an author. Which in this case applies to all of your items, since your DB does not have any users.

I don't know why, but the user table of the old database is empty. I don't have access to the old database anymore, so I have to deal with this situation :( The website is running, but I can not login :-/

Well that's a sticky situation indeed.
You can try backing up and then importing the user tables ( xx_users, xx_usergroups etc)
from a new Joomla! installation.

If you run those querys correctly a new user should be created and you gain access to your joomla administration.

Just saying, Did you check if is set the right DB in your configuration.php file?? Maybe you are trying to edit the wrong DB.

Your ideas did not work either :(

But now I inserted public $root_user='admin'; into the last row of the configuration.php

Now I can login with the emergency mode. I created a new super user, but when I log out and delete the root_user row from the config and want to login with this new super user (or the old one from the emergency mode) it doesn't work.

I have no idea what's going on here :(

Do you have some other ideas?