CiviCRM Community Forums (archive)

Could you try changing "localhost" to "127.0.0.1"? It makes a difference in some environments (for reasons that escape me).

If you run "amp config:get", what value shows up for "mysql_type"?

You can try setting the parameters via CLI ("amp config:get --mysql_type=dsn --mysql_dsn=mysql://user:pass@localhost:3306") then running "amp test". (Although, if "amp config" fails to connect to the DSN, then "amp test" should fail too.)

Dumb question: Is there any chance that your terminals/network/SSH/VM setup has you running the mysql client and amp in different environments?

When you connect via mysql client, are you explicitly setting the port - or letting the client pick a default connection mechanism? Different MySQL/PHP stacks twiddle the defaults in awkward ways. (Sometimes you get TCP; sometimes sockets; sometimes a standard port; sometimes a non-standard port.) For apples-to-apples comparison, try pass all connection criteria to mysql cli. (e.g. "mysql -h 127.0.0.1 -u myuser -pmypassword -P 3306 mydb")

What happens if you run this script?

<?php
$pdo = new PDO('mysql:host=localhost;dbname=FIXME_DB;port=3306;charset=utf8', 'FIXME_USER', 'FIXME_PASS');
foreach ($pdo->query('select 99 as value') as $row) {
  if ($row['value'] == 99) {
    echo "OK\n";
  } else {
    echo "Bad value\n";
  }
  exit();
}
echo "Missing response";