Skip to content

Access denied for user after upgrade to MariaDB 11.4.5 on Ubuntu 24.04 using CLI command #404

@SolidSnakeGr

Description

@SolidSnakeGr

Hello, I have been using this script for a bunch of years now and suddenly, it seems that after upgrading to MariaDB 11.4.5. the CLI command stopped functioning and now returns this error:

db: SQLSTATE[HY000] [1045] Access denied for user '[user]'@'[IP address]' (using password: YES)

I tried PHP cli versions 7.4.33 and 8.1.31 with no difference.
I made sure the password is correct and connected successfully with the following methods:

mysql -u user -p (with a deprecation message but still worked)
mariadb -u user -p

And I can see the database I am trying to search and replace within, using the above credentials then executing:

SHOW DATABASES;

I've also checked in both php versions and both mysqli and PDO are available so these variables are true when called in db_setup():

$mysqli_available = class_exists( 'mysqli' );
$pdo_available    = class_exists( 'PDO' );

The web version worked fine but I need to make the CLI command work for automation purposes:
php srdb.cli.php -h host.domain.ext -n "db_name" -u "db_user" -p "password" -s "search_string" -r "replace_string"

I've also tried using localhost and 127.0.0.1 with no better luck.
Is there something I am missing?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions