Title: Data Explorer: Remote Database Last modified: March 17, 2021 --- # Data Explorer: Remote Database * Resolved [rvwill48](https://wordpress.org/support/users/rvwill48/) * (@rvwill48) * [5 years, 2 months ago](https://wordpress.org/support/topic/data-explorer-remote-database/) * Hi Peter, How do I refresh the backend data explorer page to show the three new tables I’ve added to the remote database since setting up the connection? The page currently shows 25 tables/views but the database now contains 28. Thanks in anticipation of your help. Richard - This topic was modified 5 years, 2 months ago by [rvwill48](https://wordpress.org/support/users/rvwill48/). Viewing 8 replies - 1 through 8 (of 8 total) * Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/) * (@peterschulznl) * [5 years, 2 months ago](https://wordpress.org/support/topic/data-explorer-remote-database/#post-14199648) * Hi Richard, * Did you create the table you designed in the Data Designer? When you save a table design in the Data Designer the physical table is not created immediately. The plugin lets you work on your design until you are ready. After that you need to explicitly create the table (click on button CREATE TABLE). This is different from tools like phpMyAdmin where changes are directly reflected in your physical database. Please let me know if this helps. * Best regards, Peter * Thread Starter [rvwill48](https://wordpress.org/support/users/rvwill48/) * (@rvwill48) * [5 years, 2 months ago](https://wordpress.org/support/topic/data-explorer-remote-database/#post-14199984) * > Did you create the table you designed in the Data Designer? * No I didn’t. I’m using MySQL Workbench to manage my database. When I started using your Data Access plugin I created a connection to the remote database and upon doing so the tables and views already present in the DB appeared in the Data Designer. I was then able to display the content of a specific view which is what I wanted. All great so far. A couple of weeks later I went ahead and created three new tables via Workbench thinking that it would be possible to have these tables show up in the Data Access page by ‘refreshing’ the connection but no, hence my original question. Can I achieve what I want by removing the original remote connection and creating a new one? * Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/) * (@peterschulznl) * [5 years, 2 months ago](https://wordpress.org/support/topic/data-explorer-remote-database/#post-14200707) * Hi Richard, * >>> Can I achieve what I want by removing the original remote connection and creating a new one? * That should not make any difference. WP Data Access does not save your data dictionary. It reads the dictionary in real time. * >>> A couple of weeks later I went ahead and created three new tables via Workbench thinking that it would be possible to have these tables show up in the Data Access page by ‘refreshing’ the connection but no, hence my original question. * That is what I would expect as well. Were the tables create with the same user account? If not, you might need to give the user access rights. Can you check that please? * Thanks, Peter * Thread Starter [rvwill48](https://wordpress.org/support/users/rvwill48/) * (@rvwill48) * [5 years, 2 months ago](https://wordpress.org/support/topic/data-explorer-remote-database/#post-14200968) * > Were the tables create with the same user account? If not, you might need to > give the user access rights. * All the tables were created using the database administrator account. However, the plugin connects to the DB with an user account that only has CRUD access. I’ll change the connection string to see what happens. Thanks for the head’s up on this. * Thread Starter [rvwill48](https://wordpress.org/support/users/rvwill48/) * (@rvwill48) * [5 years, 2 months ago](https://wordpress.org/support/topic/data-explorer-remote-database/#post-14202595) * Hi Peter, I’ve resolved this problem. All I had to do was to edit the connection( I just changed the connection name), clicked ‘save’, then ‘test’ and all 29 tables were displayed. * Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/) * (@peterschulznl) * [5 years, 2 months ago](https://wordpress.org/support/topic/data-explorer-remote-database/#post-14203343) * Thanks for your update Richard! * Just to be sure, did you recreate the remote database connection with the same user account and credentials? * Thanks, Peter * Thread Starter [rvwill48](https://wordpress.org/support/users/rvwill48/) * (@rvwill48) * [5 years, 2 months ago](https://wordpress.org/support/topic/data-explorer-remote-database/#post-14206578) * Please accept my apologies for raising an issue when there was none. I’ve since had an Eureka! moment remembering that when I first installed the WPDA plugin I had checked ‘Show only selected tables’ in the ‘Table access’ options (please see the pic in the link below). Changing it to ‘Show all tables’ displayed the‘ missing’ tables. [Data Access Settings: Select tables](https://www.amazon.co.uk/photos/share/K9tocshpX8y1rWeZgNSU1XpE9Lj1uOE8W7vE42qj4su) * I’m still finding my way around the plugin which is taking me a while because there are so many clever facets to it. Best wishes, Richard * Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/) * (@peterschulznl) * [5 years, 2 months ago](https://wordpress.org/support/topic/data-explorer-remote-database/#post-14209949) * No problem Richard, I’m glad it is solved! 🙂 * Have a nice weekend, Peter Viewing 8 replies - 1 through 8 (of 8 total) The topic ‘Data Explorer: Remote Database’ is closed to new replies. * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063) * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/) * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/) * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/) * 8 replies * 2 participants * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/) * Last activity: [5 years, 2 months ago](https://wordpress.org/support/topic/data-explorer-remote-database/#post-14209949) * Status: resolved