Setting up a Remote MySQL Database Connection

  • Resolved ohiorick

    (@ohiorick)


    4 years, 7 months ago

    Setting up a Remote MySQL Database Connection
    My server says I need to whitelist the IP address of the plugin which is trying to access my databases on their server.
    Is there such an animal?
    Does anyone know how to deal with this?
    I’m told the default port (3306) is not open to this IP or something like that. Anyway, can I get the IP to whitelist it on my server?
    Thanks in advance for any help,
    rick

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Kerfred

    (@kerfred)

    It depends on your provider. But generally they don’t allow the remote MySQL connections.
    Another solution is to export the Joomla database to a SQL file with phpMyAdmin and import it on the same server as WordPress.

    Thread Starter ohiorick

    (@ohiorick)

    So, they’re both on the same server already. Imported the Joomla DB into the new WP installation’s DB. Not sure where to go from here. Haven’t been able to get it to work with the plugin so far.

    WordPress info:
    Plugin URL: https://wvwaterfalls.com/newwp/wp-admin/admin.php?import=fgj2wp
    Site URL: https://wvwaterfalls.com/newwp
    Home URL: https://wvwaterfalls.com/newwp
    WP version: 5.4
    WP Memory limit: 40M
    Multisite: no
    Permalink structure: /%year%/%monthnum%/%day%/%postname%/
    Media in year/month folders: yes
    Active theme: Twenty Twenty 1.2
    Active plugins:
    Classic Editor 1.5
    FG Joomla to WordPress 3.65.1
    Jetpack by WordPress.com 8.0

    PHP info:
    PHP version: 7.3.11
    Web server info: Apache
    memory_limit: 512M
    max_execution_time: 7200
    max_input_time: 60
    post_max_size: 128M
    upload_max_filesize: 128M
    allow_url_fopen: 1
    PDO: mysql, pgsql, sqlite

    MySQL info:
    MySQL version: 5.5.5
    max_allowed_packet: 268435456

    Plugin info:
    FG Joomla to WordPress 3.65.1
    Add-ons:
    Options:
    automatic_empty: 1
    url: https://www.wvwaterfalls.com/
    hostname: localhost
    port: 3306
    database: ohiova7_wp174
    username: ohiova7_wp174
    password: ***
    prefix: jos_4rwhrm_
    introtext: in_content
    archived_posts: not_imported
    skip_media:
    featured_image:
    only_featured_image:
    remove_first_image:
    remove_accents:
    import_external: 1
    import_duplicates:
    force_media_import:
    meta_keywords_in_tags: 1
    import_as_pages: 1
    timeout: 15
    logger_autorefresh: 1

    ### END DEBUG INFO ###

    Plugin Author Kerfred

    (@kerfred)

    You should not write private data on this public forum (username, database name). Hopefully, the password is hidden.

    Please contact us via https://www.fredericgilles.net/support/ and provide the WordPress access. We’ll try to see what’s wrong on your installation.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Setting up a Remote MySQL Database Connection’ is closed to new replies.