remote database connection/ Found 0 tables on remote host

  • Martin von Arx

    (@martinvax)


    5 years, 6 months ago

    Hello,

    I am trying to add a remote database connection.
    On testing the connection the following result I get:

    Preparing connection…
    Establishing connection…
    Connection established…
    Counting tables…
    Found 0 tables on remote host…

    Remote database connection valid

    The problem is: “Found 0 tables ..” but there exists tables.

    The MySQL database is hosted on the same hosting account as my wordpress website.

    For MySQL host I have tried both ‘localhost’, and the ip address provided by my webhost’s. This is 194.150.248.215.

    For username, and password I use the correct info (which I use from an other application where it works).

    For port, 3306 which is the port used for mysql as shown in PHPMyAdmin.

    Can someone help me and tell me what I’m doing wrong.

    thanks,
    Martin

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years, 6 months ago

    Hi Martin,

    Usually you see this message when a connection can be established but the user does not have the necessary rights. Please make sure you enter a valid MySQL Schema and the user has the rights to read that schema. The plugin uses $wpdb to connect to a remote database and $wpdb needs to connect to a specific schema.

    Does this help?

    Best regards,
    Peter

    Thread Starter Martin von Arx

    (@martinvax)

    5 years, 6 months ago

    Hi Peter,

    the problem was, I had entered the wrong scheme the first time. What I had not noticed is that the “Delete remote database connection” function does not work. it always remains and when I then re-enter the data and run a test, the old settings are still used and not the ones I just entered. I noticed that when I looked in “Settings – WP Data Access”. there are namely under “Remote Database Connection” looked up. If I then change the settings there, the connection works.

    regards Martin

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years, 6 months ago

    Hi Martin,

    When the plugin cannot connect to a remote database, the Data Explorer will not always allow you to change the selected database. This subject is on my to do list! As a workaround you can start the plugin settings page and temporarily disable or completely delete the remote database. After that you can select another schema in the Data Explorer and add the remote database again when the problem is fixed.

    I checked the delete remote database action. It works on my server. What went wrong?

    Is your remote connection working now?

    Best regards,
    Peter

    Thread Starter Martin von Arx

    (@martinvax)

    5 years, 6 months ago

    Changing the connection-data directly under “Einstellungen – WP Data Access – Remote database connections” fixes the problem and the connection is working now.

    Deleting the connection under “WP Data Access – Data Explorer – delete remote database connection” did not work.

    Regards Martin

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years, 6 months ago

    Hi Martin,

    Thank you for your feedback! What happens if you try to delete a remote connection? Are there any messages?

    Thanks,
    Peter

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘remote database connection/ Found 0 tables on remote host’ is closed to new replies.