dongzangchui2072 2018-11-23 01:43
浏览 46

禁止其访问权限错误选择azure mysql中的数据库

I am using web app and azure mySQL database. I tried using a simple connection:

$host = 'xxxxx.mysql.database.azure.com';
$username = 'xxxxxxxx';
$password = 'xxxxxxxx';
$db_name = 'xxxxxxxx';

//Establishes the connection
$conn = mysqli_init();

mysqli_ssl_set($conn, NULL, NULL, "/cert/BaltimoreCyberTrustRoot.crt.pem", 
NULL, NULL);

mysqli_real_connect($conn, $host, $username, $password, $db_name, 3306, 
MYSQLI_CLIENT_SSL, MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT);
if (mysqli_connect_errno($conn)) {
die('Failed to connect to MySQL: '.mysqli_connect_error());
}

//Run the Select query
printf("Reading data from table: 
");
$res = mysqli_query($conn, 'SELECT * FROM tbl_xxxx');
while ($row = mysqli_fetch_assoc($res)) {
   echo $row["ID"]. " : " . $row["XXXX"]."<br>";
}

//Close the connection
mysqli_close($conn);

But when I use the connection string on my database class, I go this error: An attempt was made to access a socket in a way forbidden by its access permissions. on a client browser. My database class is:

public function open_connection() {
    $this->conn = mysqli_init();

    mysqli_ssl_set($this->conn, NULL, NULL, "/cert/BaltimoreCyberTrustRoot.crt.pem", NULL, NULL);

    mysqli_real_connect($this->conn, server, user, pass, database_name, 3306, MYSQLI_CLIENT_SSL, MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT);


    if(mysqli_connect_errno($this->conn)){
        echo "Problem in database connection:". mysqli_connect_error();
        exit();
    }else{
        $db_select = mysqli_select_db($this->conn, database_name);

        if (!$db_select) {
            echo "Problem in selecting database:". mysqli_connect_error();
            exit();
        }
    }

}

Please note that the server, user, pass, database_name is already defined with same value in the above code. Fyi, my test shows the echo for Problem in selecting database: so the connection is fine. Is there anything I can do to properly select a database by using this class? Thank you.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 winform的chart曲线生成时有凸起
    • ¥15 msix packaging tool打包问题
    • ¥15 finalshell节点的搭建代码和那个端口代码教程
    • ¥15 用hfss做微带贴片阵列天线的时候分析设置有问题
    • ¥15 Centos / PETSc / PETGEM
    • ¥15 centos7.9 IPv6端口telnet和端口监控问题
    • ¥20 完全没有学习过GAN,看了CSDN的一篇文章,里面有代码但是完全不知道如何操作
    • ¥15 使用ue5插件narrative时如何切换关卡也保存叙事任务记录
    • ¥20 海浪数据 南海地区海况数据,波浪数据
    • ¥20 软件测试决策法疑问求解答