MYSQL custom dbases

  • Resolved al9000nj

    (@al9000nj)


    7 years, 4 months ago

    How can we utilize our custom MYSQL database tables, not just the WP tables? Is this possible or upcoming? We created our own database which of course we use phpadmin to manage, but since the drop down only shows WP tables, I fear we have not capability to point to our own database. But wanted to ask. Thanks!

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Ian Sadovy

    (@iansadovy)

    Hello @al9000nj,

    Thank you for the question. It is not supported now, but I will take a closer look how to implement it as soon as possible and will let you know my findings.

    Regards,
    Ian

    Plugin Author Ian Sadovy

    (@iansadovy)

    Hello @al9000nj,

    I have just published an updated WPTables 1.2.10 that supports custom databases.
    Please note that it might be necessary to grant permissions for the WordPress database user to see the custom database in the list.

    Please update and let me know if it works for you.

    Regards,
    Ian

    Thread Starter al9000nj

    (@al9000nj)

    Not sure where that permission is located. I have that user setup for that database proper, but not sure what else I need to pick up to see the list. Is it in the app/plugin although I did not see anything there (edit). And not really supposed to edit the code.

    Thread Starter al9000nj

    (@al9000nj)

    Sorry, forgot to mention that I did not see the dbase in the list.

    Thread Starter al9000nj

    (@al9000nj)

    Additional thought, I added the user on my WP profile where I run the WP pages and plugin to the database with permissions to do all functions. The actual user dbase ID I never see logging in when I run the plugin so maybe I am not adding the right user?

    mobileyezusa_jcn80l

    Plugin Author Ian Sadovy

    (@iansadovy)

    Hello @al9000nj,

    Thank you for the answer.
    I am talking about DB_USER that is configured in wp-config.php.
    You should grant read permissions to this DB_USER user via PhpMyAdmin.
    When the user has access to your custom database, the database will appear on the Add Table screen (https://take.ms/kuKpd).

    Regards,
    Ian

    Thread Starter al9000nj

    (@al9000nj)

    Got it now, thanks. It comes out ok now, thanks Ian, nice job.

    Plugin Author Ian Sadovy

    (@iansadovy)

    Glad to hear it works! Let me know if you have any further questions.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘MYSQL custom dbases’ is closed to new replies.