# No WP Dashboard after clicking on Admin Button

**URL:** <https://community.localwp.com/t/no-wp-dashboard-after-clicking-on-admin-button/26258>\
**Category:** WordPress Questions\
**Tags:** hosts-file\
**Created:** [July 1, 2021, 9:02am UTC](https://community.localwp.com/t/no-wp-dashboard-after-clicking-on-admin-button/26258 "2021-07-01T09:02:37Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![ronninet](https://avatars.discourse-cdn.com/v4/letter/r/e36b37/32.png) [@ronninet](https://community.localwp.com/u/ronninet)\
**Post date:** [July 1, 2021, 9:02am UTC](https://community.localwp.com/t/no-wp-dashboard-after-clicking-on-admin-button/26258/1 "2021-07-01T09:02:37Z")

</div>

After importing a life website - content folder and sql file that was zipped.  
All works except when trying to access the WP Dashboard throught local Admin, I see the website  
but no WP dashboard for me to do changes etc.

any help would be great

---

<div class="post-metadata">

**Author:** ![haroldg12](https://avatars.discourse-cdn.com/v4/letter/h/ea666f/32.png) [@haroldg12](https://community.localwp.com/u/haroldg12)\
**Post date:** [October 15, 2021, 5:15am UTC](https://community.localwp.com/t/no-wp-dashboard-after-clicking-on-admin-button/26258/2 "2021-10-15T05:15:51Z")

</div>

did you figure out the problem? i’m having same issue

---

<div class="post-metadata">

**Author:** ![ronninet](https://avatars.discourse-cdn.com/v4/letter/r/e36b37/32.png) [@ronninet](https://community.localwp.com/u/ronninet)\
**Post date:** [October 15, 2021, 9:51am UTC](https://community.localwp.com/t/no-wp-dashboard-after-clicking-on-admin-button/26258/3 "2021-10-15T09:51:19Z")

</div>

Yes I found a Solution by chance.

Solution

1. Go into Local Dashboard
2. Click on ADMIN
3. Still in Local dashboard - go the the Menu - DATABASE
4. Then Click on Open Adminer
5. Click on Select wp—usermeta
6. Then in the menu above - click on Select Data
7. Change all wp---- name to the same as your original SQL database

Example your sql data base was wpuser\_ users  
but local is wpUser\_user - click on edit and change it back to wpuser\_user

Make sure you change all the wp to match your sql database

Hope this works for you.  
Cheers  
Ronninet

---

<div class="post-metadata">

**Author:** ![haroldg12](https://avatars.discourse-cdn.com/v4/letter/h/ea666f/32.png) [@haroldg12](https://community.localwp.com/u/haroldg12)\
**Post date:** [October 23, 2021, 10:12pm UTC](https://community.localwp.com/t/no-wp-dashboard-after-clicking-on-admin-button/26258/4 "2021-10-23T22:12:03Z")

</div>

so do I have to go into my Wordpress website and see what my sql database names are and change it on local to the same names as my wordpress database?

---

<div class="post-metadata">

**Author:** ![ronninet](https://avatars.discourse-cdn.com/v4/letter/r/e36b37/32.png) [@ronninet](https://community.localwp.com/u/ronninet)\
**Post date:** [November 11, 2021, 2:08am UTC](https://community.localwp.com/t/no-wp-dashboard-after-clicking-on-admin-button/26258/5 "2021-11-11T02:08:29Z")

</div>

Sorry for this late Reply, unfortunately I dont get flagged with local there is a message for me.  
The Answer is YES

---

<div class="post-metadata">

**Author:** ![pirla](https://avatars.discourse-cdn.com/v4/letter/p/977dab/32.png) [@pirla](https://community.localwp.com/u/pirla)\
**Post date:** [March 8, 2023, 1:35pm UTC](https://community.localwp.com/t/no-wp-dashboard-after-clicking-on-admin-button/26258/6 "2023-03-08T13:35:29Z")

</div>

Thanks for this hidden trick !  
I don’t understand why. (Maybe a case pb in local, nginx, db or wpress or php … to investigate ).

As I find difficult to change each _nnE\ __to _nne\__ (nne is the prefix of my db as define in wp-config.php $table\_prefix ) by hand, i do the following :  
With VSC i copy/paste from the global sql the part relative to _nne\_usermeta_ starting at _CREATE TABLE `nne_usermeta`_ into a new _user\_meta.sql_ file .  
With vscode i replace all “nnE\_” by “nne\_” .  
Then i go to adminer within local .  
SQL request : _DROP TABLE `nne_usermeta`_  
Import .file user\_meta.sql  
execute  
And all my dashboard is back !

HTH  
Thanks again .

---

<div class="post-metadata">

**Author:** ![sambrockway](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/sambrockway/32/18726_2.png) [@sambrockway](https://community.localwp.com/u/sambrockway)\
**Post date:** [March 10, 2023, 7:20pm UTC](https://community.localwp.com/t/no-wp-dashboard-after-clicking-on-admin-button/26258/7 "2023-03-10T19:20:03Z")

</div>

Hi @pirla - welcome to the Local community! 👋

Glad you got this sorted with the solution shared by another Local user!

Sam

---

<div class="post-metadata">

**Author:** ![system](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/system/32/1_2.png) [@system](https://community.localwp.com/u/system)\
**Post date:** [March 12, 2023, 7:20am UTC](https://community.localwp.com/t/no-wp-dashboard-after-clicking-on-admin-button/26258/8 "2023-03-12T07:20:54Z")

</div>

This topic was automatically closed 36 hours after the last reply. New replies are no longer allowed.
