Tables are not Showing in phpmyadmin

This is common problem when you are importing database in phpmyadmin, you can see these tables on workbench but not in phpmyadmin view. This problem due to user access of database. Your database has some views which has privilege of user which is not existing in your phpmyadmin.

You can solve above problem following ways:

1- Identify user of view and create in your database:
The user @% was available on the original server from where We’ve exported the database, but not on my localhost computer.

2-Alter Views of import database : You can find Alter view here

3-Delete all views and recreate all views: You can delete view(‘DROP VIEW view2’).

How to get all view in database:

SHOW FULL TABLES IN database_name WHERE TABLE_TYPE LIKE 'VIEW'

  • GrantLopresti

    Pretty! This was an extremely wonderful article. Thanks for this information.