php - 如何使用我的本地 IP 地址而不是使用 localhost 访问我的数据库 mysql 服务器

Question

使用我的本地IP地址访问我的数据库mysql服务器

<?php
    $col1='customerID';
    $col2='state';
    $conn = mysqli_connect('localhost','root','');
    $db = mysqli_select_db($conn,'dsuclass_gopi595');
    $sql = "select $col1,$col2 from customers";
    $result = mysqli_query($conn,$sql);
    echo "This is my local ip address 192.168.1.7";

?>

Answer 1

• 将 localhost 替换为连接调用中的 IP 地址
• Configure the database server to listen on that network interface
• Ensure that the user is GRANTed access when connecting via the network