如何使用PDO ssl连接到azure mysql数据库

I am using PDO to connect to Azure Mysql database. I have got the file i was instructed to download.

 array(
    PDO::MYSQL_ATTR_SSL_CA => '/BaltimoreCyberTrustRoot.crt.pem.txt',$port

)

But i get an error The Connection failed: SQLSTATE[HY000] [2002]

I have looked at the connection strings provided by AZURE for PHP and i didnt find one of PDO using SSL_CA like others Thanks for the help

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

1条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
dtzhfb4869 2018-05-14 03:12
关注
Which PHP version are you using? Try to use the latest one. If you enabled “peer verification”, disable it and try again. Also, try to generate a new SSL Certificate and test an endpoint on the server to ensure that it is working properly. As per this SO thread: How do I connect to a MySQL database over SSL with Laravel 5.3, If you require to use "--ssl-mode=VERIFY_IDENTITY", then you can ping your server name to resolve the regional server name, such as westeurope1-a.control.database.windows.net, and use that regional server name in the connection until this issue is resolved. Change the DB_HOST to that region and try it again.

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

报告相同问题？

关注问题

PDO不连接到远程mysql数据库 mysql php
2017-07-31 06:30

回答 1 已采纳 Assuming your database contains tables, try running the following: $statement = $DBH->query('S
如何使用PHP函数使用PDO连接到MySQL [关闭] mysql php
2019-08-19 17:03

回答 1 已采纳 1) As referenced by HTMHell, your $config array is local here and I believe this should be delete
在外部PHP文件中使用PDO连接mysql数据库[重复] mysql php
2015-07-17 10:18

回答 2 已采纳 In your code, you first create a connection to the database, then you set it to null. Whenever you
laravel 5连接MySQL,如何使用Laravel 5.3通过SSL连接到MySQL数据库
2021-01-27 04:18

乌其多梦的博客 I've been searching all over the internet and haven't had any success.I'm trying to connect to an azure mysql database over ssl from my laravel application.I've confirmed I can connect to the database...
php使用PDO连接数据库后查询不到数据 php 数据库
2017-10-21 03:55

回答 2 已采纳用query()试一下，然后打印一下查询出来的数组是怎样的，
使用PDO从PHP无法连接到MySQL mysql php
2014-05-24 13:49

回答 1 已采纳 mysql:host=localhost;dbname=;pizzadb3 Needs to be: mysql:host=localhost;dbname=pizzadb3;
使用PDO使用php从mysql数据库中提取特定值 mysql php
2017-02-23 16:57

回答 1 已采纳 SELECT userID, userName, userProfession, userPic FROM tbl_users WHERE userProfession = "Teacher" O
微软云数据库连接SSL问题
2023-06-07 16:10

上海菜鸡毛的博客【代码】微软云数据库连接SSL问题。
使用类中的PDO连接数据库 mysql php
2017-03-16 08:36

回答 1 已采纳 I finally made it out. I made few changes in both files. database.php class Connection{ pri
无法使用PDO连接到MySQL服务器[重复] mysql php
2015-07-19 18:13

回答 1 已采纳 You're using the wrong variable for $stmt = $dbh->prepare which should be $conn and not $dbh
使用PDO将数据插入MySQL数据库 database mysql php
2014-03-13 04:07

回答 2 已采纳 You have two different variable names. You're checking $user to make sure it's not empty() but the
Windows Azure上PHP和MySQL：Git入门和部署
2020-08-16 09:52

culi4814的博客 By now, I'm sure you've heard of SitePoint's and Windows Azure's Push The Web Forward contest. If not, it's a contest that requires you to sign up for a trial account on Windows Azure, and deploy any ...
无法使用PDO连接到数据库 php
2015-04-07 07:00

回答 1 已采纳 It seems like your paths for autoloading your classes is wrong, please try the following: spl_aut
php 管理mysql 应用,教程：将 PHP 应用与 MySQL 配合使用 - Azure App Service | Microsoft Docs...
2021-04-26 13:00

weixin_39719427的博客您现在访问的是微软AZURE全球版技术文档网站，若需要访问由世纪互联运营的MICROSOFT AZURE中国区技术文档网站，请访问 https://docs.azure.cn.教程：在 Azure 应用服务中生成 PHP 和 MySQL 应用Tutorial: Build a ...
使用docker制作nginx，mysql，php容器，实现lamp
2021-12-04 02:10

凤箫声动.的博客 # chown -R mysql.mysql mysql //初始化数据库 [root@a7b294ded843 local]# /usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --datadir=/opt/data/ 2021-12-03T17:22:31.377436Z 0 [Warning] ...
lamp架构一、源码安装nginx、mysql、php及建立连接
2021-03-28 12:59

ninimino的博客 数据库连接 /etc/init.d/mysqld start [root@server1 ~]# vim .bash_profile PATH=$PATH:$HOME/bin:/usr/local/nginx/sbin:/usr/local/mysql/bin:/usr/local/php/bin [root@server1 ~]# source .bash_profile vim /...
LAMP部署（二进制安装mysql）
2022-07-05 22:10

长街听风594的博客 LAMP部署（二进制安装mysql）编译安装httpd 二进制安装mysql 编译安装php
基于容器的方式制作一个nginx镜像、mysql镜像、php镜像
2021-12-04 00:33

晶核高手的博客 # useradd -r -M -s /sbin/nologin mysql [root@0fa25df5a003 local]# chown -R mysql.mysql /usr/local/mysql [root@0fa25df5a003 local]# echo 'export PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql....
owin 怎么部署在云中_在云中部署PHP应用程序的终极指南
2020-08-31 22:38

culi4814的博客 Database, Caching & Cron Jobs 数据库，缓存和Cron作业 IBM BlueMix IBM BlueMix Database, Caching & Cron Jobs 数据库，缓存和Cron作业 Microsoft Azure 微软Azure Database, Caching & Cron Jobs 数据库，缓存和...
lnmp架构的工作原理介绍及lnmp架构搭建操作流程展示
2020-05-15 14:09

Burie的博客 1、一、lnmp（lamp）的定义 apache一般是把php当做自己的一个模块来启动；而ngnix则是把http请求变量转发给php进程，即php独立... ... lamp=linux+apache+mysql+php lnmp=linux+nginx+mysql+php LNMP代表的就是:L...
没有解决我的问题, 去提问

悬赏问题

¥15 如何在scanpy上做差异基因和通路富集？
¥20 关于#硬件工程#的问题，请各位专家解答！
¥15 关于#matlab#的问题：期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707，使系统具有较小的超调量
¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
¥30 截图中的mathematics程序转换成matlab
¥15 动力学代码报错，维度不匹配
¥15 Power query添加列问题
¥50 Kubernetes&Fission&Eleasticsearch
¥15 報錯：Person is not mapped，如何解決？
¥15 c++头文件不能识别CDialog

如何使用PDO ssl连接到azure mysql数据库

1条回答 默认 最新

悬赏问题

1条回答默认最新