Not able to pull database using acquia acli

[rusapkar-cci]

unable to connect local database using credentials mysql:://drupal:drupal@localhost, It was working yesterday. Not sure why it takes user and password as drupal.

[Sen-Bounteous]

Had the exact same issue

Here's how I solved it,
Problem
I think the default username, password and db-name for connecting to the database has changed somehow. So when pulling from acquia, it was not able to connect to the database

Solution
Get the correct info from lando and update it in .lando.yml. Since the new database doesn't exists, we have to manually create it

Steps
I ran this command to get the info

lando info

Got back (username, password, db-name might be different for you)
creds: { database: <db-name>, password: <password>, user: <username> }

Then, get into DB docker container and create the database

lando mysql

create database <db-name>

In .lando.yml, add the credentials

services:
  database:
    portforward: true
    creds:
      user: '<username>'
      password: '<password>'
      database: '<db-name>'

once the configuration is updated, destroy lando and start it again. when db creds are changed, we have to do lando destroy and start it as mentioned here

lando destroy -y && lando start

[maskedjellybean]

I ran into this because I had overridden the database creds in .lando.yml to something other than "acquia". Apparently the only way lando pull works with the Acquia recipe is if the database creds in .lando.yml are:

services:
  database:
    creds:
      user: acquia
      password: acquia
      database: acquia

Also in your Drupal settings.php or settings.local.php:

/**
 * When using Lando, use Lando settings.
 * Prepare a LANDO_INFO constant.
 * See: https://jigarius.com/blog/drupal-with-lando
 */
$info = getenv('LANDO_INFO');
if ($info) {
  define('LANDO_INFO', json_decode($info, TRUE));
}

// Configure database for Lando.
if (defined('LANDO_INFO')) {
  if (!isset($databases))
    $databases = array();

  $databases['default']['default'] = [
    'driver' => 'mysql',
    'database' => LANDO_INFO['database']['creds']['database'],
    'username' => LANDO_INFO['database']['creds']['user'],
    'password' => LANDO_INFO['database']['creds']['password'],
    'host' => LANDO_INFO['database']['internal_connection']['host'],
    'port' => LANDO_INFO['database']['internal_connection']['port'],
    'prefix' => '',
  ];
}