Remote Connection 0 Tables?

  • Resolved grungyape

    (@grungyape)


    5 years, 5 months ago

    First time testing WP Data Access, have wpDataTable installed and working on same system.

    Perhaps it is a term misunderstanding.

    Database name: rdb:(my actual database name)
    …
    MySQL schema: ?? Without this it fails, but if I add anything I get the following

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

    Remote database connection valid”

    I’m not sure where to go, as this same connection (user/pass, etc) works from wpDataTables, so I know the user/pass is good and connection from this box is permitted.

    Any assistance is appreciated.

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

    (@peterschulznl)

    5 years, 5 months ago

    Hi @grungyape,

    This looks like a unfortunate coincidence. WP Data Access uses the prefix rdb: to identify remote databases. Is it possible to rename your database?

    Thanks,
    Peter

    Thread Starter grungyape

    (@grungyape)

    5 years, 5 months ago

    Oh geez, I am so sorry. What I meant was rdb: + (my database name), not that rdb WAS my database name.

    I should have just used a bogus name like rdb:mydatabase

    I’m an idiot.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years, 5 months ago

    Hi @grungyape,

    Sorry, looks like I misunderstood your question:
    – Please enter any name into field Database name (rdb:mydatabase is okay)
    – Field MySQL schema needs the real database (or schema) name you want to connect to

    The rdb:mydatabase is just for your own administration to identify your remote database.

    Does this help?

    Best regards,
    Peter

    Thread Starter grungyape

    (@grungyape)

    5 years, 5 months ago

    And bingo, I am connected!

    If I missed this in the instructions, my apology.
    If not, might not hurt to add this to the instruction page.

    I appreciate the help regardless!

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years, 5 months ago

    Great! 🙂

    This was missing on the instruction page. I updated the instructions. Thanks for reminding!

    Best regards,
    Peter

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

The topic ‘Remote Connection 0 Tables?’ is closed to new replies.