Resolved SQLSTATE[HY000] [1045] Access denied for user 'example_user'@'127.0.0.1' (using password: YES)

Hello,

The exports use a new database driver because there was an issue running exports in Joomla 4. If you change the 127.0.0.1 to localhost in your database configuration, does the export run then?

Under the database type, do you see the PDO option there?

Hello,

The exports use a new database driver because there was an issue running exports in Joomla 4. If you change the 127.0.0.1 to localhost in your database configuration, does the export run then?

Under the database type, do you see the PDO option there?

Hi,

changing from 127.0.0.1 to Localhost the problem persists.
my provider allows me to connect to the Mysql database only with user "localhost"

this is my config in "PHP Information" section of my Joomla 3.10:

=============
PDO
=============
PDO support: enabled
PDO drivers: mysql, odbc, pgsql, sqlite

=============
pdo_mysql
=============
PDO Driver for MySQL: enabled
Client API version: mysqlnd 7.4.28

=============
pdo_mysql.default_socket
=============
Local Value: xxxxxx
Master Value: xxxxxx

=============
PDO_ODBC
=============
PDO Driver for ODBC (unixODBC): enabled
ODBC Connection Pooling: Enabled, strict matching

=============
pdo_pgsql
=============
PDO Driver for PostgreSQL: enabled
PostgreSQL(libpq) Version: 9.2.24

=============
pdo_sqlite
=============
PDO Driver for SQLite 3.x: enabled
SQLite Library: 3.7.17

=============
mysqlnd
mysqlnd enabled
Version mysqlnd 7.4.28
Compression supported
core SSL supported
extended SSL supported
Command buffer size 4096
Read buffer size 32768
Read timeout 86400
Collecting statistics Yes
Collecting memory statistics No
Tracing n/a
Loaded plugins mysqlnd, debug_trace, auth_plugin_mysql_native_password, auth_plugin_mysql_clear_password, auth_plugin_caching_sha2_password, auth_plugin_sha256_password
API Extensions mysqli, pdo_mysql


is there a solution to fix the problem?
Many thanks.

Hello,

So your information looks good, what surprises me is the error in general because the export uses the same credentials as Joomla uses to connect to the database. Could you post login details for the site and (S)FTP access? I will take a look to see what the issue is.

Hello,

So your information looks good, what surprises me is the error in general because the export uses the same credentials as Joomla uses to connect to the database. Could you post login details for the site and (S)FTP access? I will take a look to see what the issue is.

hi, for security reasons I cannot share access data to the site / ftp server.
We are talking about a site in production and not a test!

Tell me what to check and I'll provide you with updates.

Hello,

for security reasons I cannot share access data to the site / ftp server.

That is fine, just will take longer to figure things out.

We are talking about a site in production and not a test!

I did not assume you are talking about a test site.

Tell me what to check and I'll provide you with updates.

What details have you set for the database connection in the global settings (without the password)? If you use the MySQL PDO driver here, does that work?

my provider allows me to connect to the Mysql database only with user "localhost"

The error is not talking about the user but about the name of the server connecting to the database. The name localhost is an alias for 127.0.0.1.

What details have you set for the database connection in the global settings (without the password)? If you use the MySQL PDO driver here, does that work?

you will find attached with the configurations of the database settings of my joomla 3.10.6 (they have never been modified)

Hello,

So that looks OK, as expected because the site is running. However I did some testing and cannot reproduce the issue you see. Which is also logical as it completely depends on the server settings. What is happening is that MySQL is not accepting connections coming from 127.0.0.1 which is fine but I really do not understand why your MySQL server thinks we want to connect from 127.0.0.1. The credentials used are exactly the same as configured in Joomla.

Could your hosting provider explain why 127.0.0.1 is not allowed or why MySQL thinks why the connection is coming from 127.0.0.1. In my testing I see no difference and so far this is only the first report of such error.

This sounds similar to this:
https://rolandd.com/support/ro-csvi/export-problem-after-update-to-vers-8-0-0

Hello,

That issue is different because that user can connect to the database. In this issue the database connection is not even allowed. The other issue has already been resolved in the current release.

Hello,

So that looks OK, as expected because the site is running. However I did some testing and cannot reproduce the issue you see. Which is also logical as it completely depends on the server settings. What is happening is that MySQL is not accepting connections coming from 127.0.0.1 which is fine but I really do not understand why your MySQL server thinks we want to connect from 127.0.0.1. The credentials used are exactly the same as configured in Joomla.

Could your hosting provider explain why 127.0.0.1 is not allowed or why MySQL thinks why the connection is coming from 127.0.0.1. In my testing I see no difference and so far this is only the first report of such error.

I request a verification of the problem from my provider.

I keep you updated. Thank you all