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

Question

Accessing my database mysql server using my local ip address

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

• Replace localhost with the IP address in the connect call
• Configure the database server to listen on that network interface
• Ensure that the user is GRANTed access when connecting via the network