amp config issue "Connection failed" when entering mysql_dsn

[lolas]

The subject says it all. I have double and triple checked the credentials using the mysql client but I am getting the error message "Connection failed" in ./amp config when entering the value for mysql_dsn at the prompt. I am entering in the form mysql://root:passwordforroot@localhost:3306.
Any ideas?

[totten]

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

[lolas]

Sorry I forgot to mention that I already also tried mysql://root:passwordforroot@127.0.0.1:3306 with the same result.

[totten]

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?

Code: [Select]

<?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";


[lolas]

Thanks!

I had a problem with PDO which your test code showed me. I forgot that I hadn't tested this machine in a while. I thought it was all setup but it had been re-installed and was missing some drivers.