WordPress.org

Ready to get started?Download WordPress

Forums

FG Joomla to WordPress
[resolved] [closed] Couldn't Connect to the Joomla Database (10 posts)

  1. patrickd
    Member
    Posted 9 months ago #

    [fgj2wp] Couldn't connect to the Joomla database. Please check your parameters. And be sure the WordPress server can access the Joomla database.
    SQLSTATE[28000] [1045] Access denied for user 'adminbird_iFcx9j'@'localhost' (using password: YES)

    I have triple checked the parameters and added the WordPress host to the list of allowed Access Hosts in my hosting control panel where Joomla is installed. Still, I get the above error. Any ideas?

    http://wordpress.org/plugins/fg-joomla-to-wordpress/

  2. Kerfred
    Member
    Plugin Author

    Posted 9 months ago #

    If WordPress is not on the same host as the Joomla database, you must not use "localhost" as the host. You must use the real MySQL host.

  3. patrickd
    Member
    Posted 9 months ago #

    Joomla is not on the same host as WordPress, but from what I can see in phpmyadmin localhost is the host. But to be sure I tried my domain name and I now get this error:

    [fgj2wp] Couldn't connect to the Joomla database. Please check your parameters. And be sure the WordPress server can access the Joomla database.
    SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'drollyankees.com' (110)
  4. patrickd
    Member
    Posted 9 months ago #

    I just found a variable in phpmyadmin called hostname and tried putting it's value in to the plugin as the host but I still get the same error as in my previous post.

  5. Kerfred
    Member
    Plugin Author

    Posted 9 months ago #

    You can find the database credentials in the Joomla file configuration.php.
    Please also read the FAQ for the workaround if your Joomla database is not accessible from WordPress.
    http://wordpress.org/plugins/fg-joomla-to-wordpress/faq/

  6. wsprja
    Member
    Posted 7 months ago #

    I went to the FAQ and I tried the workaround.
    At bullet Point:
    import this SQL file on the same database as WordPress
    I'm hung up as phpMyAdmin just fails miserably at importing this file. Can you provide a detailed explination of importing the .sql file to the WordPress installation?

  7. Kerfred
    Member
    Plugin Author

    Posted 7 months ago #

    With PHPMyAdmin on the Joomla database -> export the tables to a SQL file
    With PHPMyAdmin on the WordPress database -> import the SQL file

  8. wsprja
    Member
    Posted 7 months ago #

    Did that. Must be a problem at the host configuration. Will continue to google.

  9. thatguydustin
    Member
    Posted 7 months ago #

    How is this marked as resolved?

    I am encountering the same errors.

    With PHPMyAdmin on the Joomla database -> export the tables to a SQL file
    With PHPMyAdmin on the WordPress database -> import the SQL file

    Is not the solution as there is an error with credentials when importing the SQL file.

  10. traumahealing
    Member
    Posted 6 months ago #

    I found the easiest thing to do was to install an instance of wordpress through my host provider (specifically to a subfolder of the site, like "mywebsite.com/export".

    Then, you login to the WordPress backend (in this example, "mywebsite.com/export/wp-admin" and login with the credentials for the bs site.

    go to Tools>import and modify to your needs:

    Website: "http://mywebsite.com"
    Joomla Version
    hostname: "localhost"
    Port: 3306 (Contact your host provider for more info)
    Database (these come from the home/configuration.php file, as mentioned -
    var $host = 'localhost';
    var $user = 'This_value_is_your_database_username';
    var $db = 'This_value_is_your_database';
    var $dbprefix = 'This_is_the_Joomla_table_prefix_value';

    Also, you will need the DATABASE password (not the one you use to login to the Configuration Panel on your webhost provider's page. I lost the password that I created when I originally created the joomla database (back in 2009?). So I had to go back to my host Cpanel, and create a new Database user (with new username and password) and assign it to the Database for the Joomla install (give this user full rights). I then modified the Joomla import to reflect this new user. Bam. It works.

    Finally, went to export, and exported it as a xml file. It works on my local version using MAMP (or XAMPP).

    Also, I noticed that my import runs smoother when I import items as pages rather than posts. When I did them as posts, I noticed that it wouldn't import anything past a year ago.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic