Support » Plugin: FG Joomla to WordPress » Still can’t connect to local database

  • Resolved bkkcanuck

    (@bkkcanuck)


    I have been tinkering with your plugin for a couple of hours now and tried everything online suggested on how to make it work, of course taking special care to follow the instructions you posted below:

    1. With phpMyAdmin, export the Joomla database into a SQL file.

    *done with no problem*

    2. Still with phpMyAdmin but on the WordPress host, import this SQL file. So you will have both the Joomla and the WordPress databases on the same host.

    *not fully clear if you are saying create a NEW database on the same hosting account as your WP install OR to import the tables from your Joomla install into the existing WP database you are trying to import to. I tried it both ways*

    3. Then on the plugin screen, you must fill in the database settings: Hostname, Port, Database, Username, Password, Joomla Table Prefix. You can find them in the WordPress file wp-config.php, except the table prefix that stays the Joomla one.

    *I have done 3 over and over again and nothing allows me to connect to the database, even with both on the same server. Yes make sure the table prefix was the original*

    I was considering buying the Premium version wondering if that might fix it, but don’t really want to spend the money if I can’t even get the free version to connect.

    FYI when I created a new database locally I used the same creds as on my Joomla install, still no luck.

    When I import the tables in the existing WP database I used the creds from the WP-config file.. again no luck.

    Log output.

    === START test_database 2018-05-18 17:59:24 ===
    [ERROR] Couldn’t connect to the Joomla database. Please check your parameters. And be sure the WordPress server can access the Joomla database.

    SQLSTATE[HY000] [1045] Access denied for user ‘jjjinc_wp41’@’localhost’ (using password: YES)

    Please read the FAQ for the solution.
    === END test_database 2018-05-18 17:59:24 ===

    Help??

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

    (@kerfred)

    You can import the Joomla database on a new database on the same server as WordPress or on the same database as WordPress.

    If you need some help, please open a ticket on https://www.fredericgilles.net/support/ and provide the WordPress URL, credentials and the wp-config.php file.

    Plugin Author Kerfred

    (@kerfred)

    The connection is successful now on your site.
    It was probably a typo in the password.

    Thread Starter bkkcanuck

    (@bkkcanuck)

    Very scary considering I copy and pasted it… maybe I got a blank space in there some how.

    Either way, thank you very much, very impressed with your speed and quality of support.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Still can’t connect to local database’ is closed to new replies.