I've read through many, many posts related to "Access Denied" for site administrators, and I cannot seem to find a solution.

My situation:
* All worked fine (I was able to log in without issues) until my client pointed their domain's A Record to my host
* I try to log in as the admin user, and I am routed to a page that says "Access denied. You are not authorized to access this page."
* I've updated the base_url and the cookie_domain in settings.php to www.mysite.com
* Everything is rendering fine on all pages (images are loading, etc.), I just can't log in as admin or any other user

Any ideas why this would change with the A Record change? How can I troubleshoot?

Thank you in advance!

Comments

renenee’s picture

renenee commented

OK, this may seem ridiculous (or at least it does to me), but I just went into phpMyAdmin, exported the database and then imported it. All works fine now ...

renenee’s picture

renenee commented
Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

crutch’s picture

crutch commented

Same issue with uber admin access denied after moving data from localhost to live server. Exporting database from live server and then reimporting fixed. Makes no sense to me but worked.

hschott’s picture

hschott commented

I just did a dns change on a site and now can't log in. It was being developed under a temporary url and now it's ready to go live. I tried export/import, but the import won't go. Do I have to drop or empty all of the tables before import?

Thanks!