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:
PHP Code:
DELETE FROM PREFIX_admin WHERE admin_name 'Admin'
INSERT INTO PREFIX_admin (admin_nameadmin_emailadmin_passadmin_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.