Title: Problem connecting to remote database Last modified: November 14, 2020 --- # Problem connecting to remote database * [caleno76](https://wordpress.org/support/users/caleno76/) * (@caleno76) * [5 years, 6 months ago](https://wordpress.org/support/topic/problem-connecting-to-remote-database/) * Hello, * I am trying to add a remote database connection but have been unsuccessful so far. * The MySQL database is hosted on the same hosting account as my wordpress website. * The database name is cycadlis_worldlist, but in the data explorer it is prefixed by rdb:, so it turns into rdb:cycadlis_worldlist * For MySQL host I have tried both ‘localhost’, and an ip address provided by my webhost’s ‘remoteMySQL’ app in CPANEL as an ‘Access Host’. This is 66.198.240.10. * For username, I put my MySQL username, which is in this format cycadlist_username * For password, the password for this database * For port, 3306 which is the port used for mysql as shown in PHPMyAdmin. * For MySQL schema, I’m not quite sure. If I leave it blank, it says ‘preparing connection’ and then does not advance beyond that. If I put the database name there (cycadlis_worldlist) or information_schema, then I get the error message‘ Remote database connection invalid’. * This should be very straightforward, but I am obviously doing something wrong. If anyone could provide some advice as how to move forward it would be much appreciated. * thanks, Michael * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fproblem-connecting-to-remote-database%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 4 replies - 1 through 4 (of 4 total) * Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/) * (@peterschulznl) * [5 years, 6 months ago](https://wordpress.org/support/topic/problem-connecting-to-remote-database/#post-13663920) * Hi Michael, * Is your MySQL hosted on the same plysical server? If so, you can connecto to ip 127.0.0.1. If not, use your public server ip. * Make sure your username is accessible from the ip adress you are connecting from. If the database is on the same physical server, this would be something like:‘ cycadlist_username’@’127.0.0.1’ or ‘cycadlist_username’@’localhost’. If you are connecting from another physical server, you need to add the ip of the server you are connecting from. * You must enter a valid MySQL schema name. The plugin will not be able to connect without it. This is the name of the database to witch you want to connect. * Does this help? Peter * Thread Starter [caleno76](https://wordpress.org/support/users/caleno76/) * (@caleno76) * [5 years, 6 months ago](https://wordpress.org/support/topic/problem-connecting-to-remote-database/#post-13664737) * Hi Peter, * I greatly appreciate you taking the time to look into this issue. * I had a chat with my webhost’s support team and they confirm that all the settings I am using are correct. * Using either 127.0.0.1 or ‘localhost’ should be fine, the username is fine (cycadlis_caleno) and doesn’t require the @ with the IP, and the database name (put into the MYSQL schema field) is correct: cycadlis_worldlist. * He suggested removing the rdb: from the Database name field ‘since it’s already defined as a remote connection’, but I realize this isn’t an option in the plugin. This shouldn’t matter, right? This is the name the plugin uses for the database( with the rdb prefix) and I don’t actually have to rename my database with that prefix, correct? * Any other ideas of what I can try? I still get the same error message. * thanks! * Michael * Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/) * (@peterschulznl) * [5 years, 6 months ago](https://wordpress.org/support/topic/problem-connecting-to-remote-database/#post-13667014) * Hi Michael, * The rdb prefix is used within the plugin to identify the remote database only. The plugin uses the MySQL Schema value to connect to the database. * Can you give me temporarily access to your server? You can use the contactform on the plugin website to send me a message. I’ll reply with my private email, which can use to send the necessary information. * Thanks, Peter * Thread Starter [caleno76](https://wordpress.org/support/users/caleno76/) * (@caleno76) * [5 years, 6 months ago](https://wordpress.org/support/topic/problem-connecting-to-remote-database/#post-13668677) * Hi Peter, * Appreciate your willingness to help, I will contact you privately via the contact form. * regards, Michael Viewing 4 replies - 1 through 4 (of 4 total) The topic ‘Problem connecting to 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/) * 4 replies * 2 participants * Last reply from: [caleno76](https://wordpress.org/support/users/caleno76/) * Last activity: [5 years, 6 months ago](https://wordpress.org/support/topic/problem-connecting-to-remote-database/#post-13668677) * Status: not resolved