Trying to reset password

I am running this queiry assuming the prefix is this part PREFIX_database to reset the password as resending it to our email didnt work:

DELETE FROM PREFIX_admin WHERE admin_name = 'Admin'; 
INSERT INTO PREFIX_admin (admin_name, admin_email, admin_pass, admin_level) 
VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);
```Nothing is happening and I still am logged out. I had siteground transfer the site which was working fine on another host but everything is going wrong and i am regretting the move. We have been unable to get into the admin for days and they are slow to respond.

I am guessing you are using:
PREFIX_admin

to mean you may have prefixed your tables with:
fred

so your table name is really
fred_admin

and your command is just set that for example purposes ...

If not, there is a problem right there, as that PREFIX_admin needs to be whatever is in the two configure.php files in:
/includes/configure.php
/admin/includes/configure.php

Make sure that your two configure.php files are setup with the proper information to reflect the change to your new server ...

Often times this is an issue with the database name, username or password ...

Sometimes if can be with the paths etc. that might be still set for the old server vs the new server ...

Does the Catalog work right now?

If so, compare the files:
/includes/configure.php
/admin/includes/configure.php

Next, browse your admin table via phpMyAdmin and check that the information that you are inserting into the admin table is actually there ...

Are you getting any errors when you run the SQL commands?

How many rows (admins) do you see when you browse the admin table?

Thanks Linda,
They have fixed it just now so I assume that was what was wrong. I have copied the information to my PC for use later if I have the same problem at a later date.

Thanks for all your help everyone. Without the forum it would be hard to learn and troubleshoot that is for sure.:hug:

Thanks for the update that you have things working once again ... :smile: