Joomla database parameters

I am migrating from one host to another.

[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 ‘root’@’localhost’ (using password: NO)

The help file suggests “If Joomla and WordPress are not installed on the same host, you can do this:
> export the Joomla database to a SQL file (with phpMyAdmin for example)
> import this SQL file on the same database as WordPress
> run the migration by using WordPress database credentials (host, user, password, database) instead of the Joomla ones in the plugin settings.”

So, I imported the sql file to WordPress database and used the wordpress database login info. but It didn’t worked for me. I’m still getting the Connection failed error.

Please provide any further help available. Thank you.

I try too but the connection to the database failed. I think we need that the complete Joomla site is in ours database if not we can’t transfer anything…

Hi,

I imported the joomla db sql file to wordpress and used the wp login info as parameters. but didn’t worked

You don’t need to transfer the whole Joomla site to the WordPress server.
You just need to copy the Joomla database on the same database as WordPress.
Then you need to use the WordPress credentials (host, login, password) in the plugin settings and enter the Joomla database name and prefix.
You can find the WordPress credentials in the wp-config.php file.

I hope this will help both of you.

Thank you very much. The problem cause the Table Prefix name. I thought it’s not necessary to connect to db. Thanks so much again:)

I do all the operation you have listed but the plugin doesn’t transfer anything. What I have done in order:
1- export the joomla database with the article, the server is in aruba.it
2- import in the database of the destination site (that is in register.it)
3- in the plugin I test the database connection with the following value: URL of the live Joomla web site: joomla web site (that is in another server), Hostname: the register host , port: 3306, Database: the database of Joomla site in aruba server, username: login of register database, password: password of database register, Joomla table prefix: jos_ .
how you say, this operation would work… but I don’t understand why in my site doesn’t work… How is it possible?

You must put:
– Joomla web site: xxx.aruba.it
– Hostname: the DB_HOST value found in wp-config.php
– Port: 3306
– Database: the DB_NAME value found in wp-config.php
– Username: the DB_USER value found in wp-config.php
– Password: the DB_PASSWORD value found in wp-config.php
– Joomla Table Prefix: the $dbprefix value found in the Joomla file configuration.php

Okay, it’s run! Thank’s a lot Kerfred for helping me