{"action":"created","issue":{"url":"https://api.github.com/repos/drush-ops/drush/issues/965","labels_url":"https://api.github.com/repos/drush-ops/drush/issues/965/labels{/name}","comments_url":"https://api.github.com/repos/drush-ops/drush/issues/965/comments","events_url":"https://api.github.com/repos/drush-ops/drush/issues/965/events","html_url":"https://github.com/drush-ops/drush/issues/965","id":48119716,"number":965,"title":"Mysql SSL / Certificate Support","user":{"login":"drupalmodule","id":464457,"avatar_url":"https://avatars.githubusercontent.com/u/464457?v=3","gravatar_id":"","url":"https://api.github.com/users/drupalmodule","html_url":"https://github.com/drupalmodule","followers_url":"https://api.github.com/users/drupalmodule/followers","following_url":"https://api.github.com/users/drupalmodule/following{/other_user}","gists_url":"https://api.github.com/users/drupalmodule/gists{/gist_id}","starred_url":"https://api.github.com/users/drupalmodule/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/drupalmodule/subscriptions","organizations_url":"https://api.github.com/users/drupalmodule/orgs","repos_url":"https://api.github.com/users/drupalmodule/repos","events_url":"https://api.github.com/users/drupalmodule/events{/privacy}","received_events_url":"https://api.github.com/users/drupalmodule/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/drush-ops/drush/labels/area-sql","name":"area-sql","color":"d4c5f9"},{"url":"https://api.github.com/repos/drush-ops/drush/labels/pri-low","name":"pri-low","color":"bfdadc"},{"url":"https://api.github.com/repos/drush-ops/drush/labels/stat-needs-work","name":"stat-needs-work","color":"d4c5f9"},{"url":"https://api.github.com/repos/drush-ops/drush/labels/type-feature","name":"type-feature","color":"fad8c7"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2014-11-07T19:17:22Z","updated_at":"2015-06-12T17:23:39Z","closed_at":null,"body":"What is the proper way to configure drush to use mysql SSL and certificates.  I am able to connect to my database from drupal but not with drush. Drush seems to be omitting the certs.\r\n\r\nI have the following database entry in settings.php:\r\n```\r\n$databases = array (\r\n  'default' =>\r\n  array (\r\n    'default' =>\r\n    array (\r\n      'driver' => 'mysql',\r\n      'database' => $database,\r\n      'username' => $dbuser,\r\n      'password' => $dbpasswd,\r\n      'host' => $mysql_server,\r\n      'prefix' => '',\r\n      'pdo' => array(\r\n          PDO::MYSQL_ATTR_SSL_KEY => '/etc/mysql/client-key.pem',\r\n          PDO::MYSQL_ATTR_SSL_CERT => '/etc/mysql/client-cert.pem',\r\n          PDO::MYSQL_ATTR_SSL_CA => '/etc/mysql/server-ca.pem',\r\n          PDO::MYSQL_ATTR_COMPRESS => true,\r\n          ),\r\n      'port' => '3306',\r\n    ),\r\n  ),\r\n);\r\n```\r\nI am using drush 6.4 and drupal 7.31"},"comment":{"url":"https://api.github.com/repos/drush-ops/drush/issues/comments/111565274","html_url":"https://github.com/drush-ops/drush/issues/965#issuecomment-111565274","issue_url":"https://api.github.com/repos/drush-ops/drush/issues/965","id":111565274,"user":{"login":"chriscroome","id":1788560,"avatar_url":"https://avatars.githubusercontent.com/u/1788560?v=3","gravatar_id":"","url":"https://api.github.com/users/chriscroome","html_url":"https://github.com/chriscroome","followers_url":"https://api.github.com/users/chriscroome/followers","following_url":"https://api.github.com/users/chriscroome/following{/other_user}","gists_url":"https://api.github.com/users/chriscroome/gists{/gist_id}","starred_url":"https://api.github.com/users/chriscroome/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chriscroome/subscriptions","organizations_url":"https://api.github.com/users/chriscroome/orgs","repos_url":"https://api.github.com/users/chriscroome/repos","events_url":"https://api.github.com/users/chriscroome/events{/privacy}","received_events_url":"https://api.github.com/users/chriscroome/received_events","type":"User","site_admin":false},"created_at":"2015-06-12T17:23:39Z","updated_at":"2015-06-12T17:23:39Z","body":"I just ran into this issue:\r\n\r\n    drush sqlc\r\n    ERROR 1045 (28000): Access denied for user 'user'@'server' (using password: YES)\r\n\r\nAnd one thing just occurred to me -- if Drush is trying to connect over the network without SSL then it is transmitting the MySQL account details unencrypted -- this is a security issue."}}