没有密码访问数据库？ [关闭]

Question

I am new to SQL database and was wondering If a user can have access to a database without providing a password. Or do I have to pass in an empty password field 'PWD' => ''

Sample code with password filed removed:

    $connInfo = array(
            'Database' => 'mystore',
            'UID' => 'admin_user',
            /*password field removed*/
            'ReturnDatesAsStrings' => true 
             );
    $connectString = sqlsrv_connect('some.sever.name', $connInfo) or die("Can't connect to the database");


    $query = 'SELECT * FROM products';
        $data = sqlsrv_query($connectString, $query) or die(print_r(sqlsrv_errors(SQLSRV_ERR_ALL), true));

        while ($row = sqlsrv_fetch_array($data))
        {
        //Graduate
        echo "<tr>";
            echo "  " .$row['NAME'] ."  -  " .$row['EMAIL'] ." ";
        echo "</tr><br>";   
        }
    sqlsrv_free_stmt($data);
    sqlsrv_free_stmt($query);
    ?>

I am doing this for a testing purposes and not going to upload this in to a website without a password. Can you please tell me if the syntax of the above code is valid?

Answer 1

There are only two ways to connect to SQL Database:

1) Using SQL Password where you need to specified the credentials

2) or using domain authentication, where the credentials are same as you logged in your pc: Option 1: Data source=localhost; initial catalog=master;trusted connection = true Option 2: Data source=localhost; initial catalog=master;Integrated security=SSPI

But you can check the following link where you will find any connection string to most databases and all variants of connection:

http://www.connectionstrings.com/

Regards. Majahide