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?
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
The simplest way I can think that you can do what you say is by creating a user with an empty string as a password. You can do that directly in your RDMBS administrator.
However, from my personal point of view, that is a really dumb thing to do:
Besides that, instead of asking others to test your code, do it yourself. If you have any specific questions regarding specific problems, then feel free to ask.
Final note: Your question shows that you are using SQL server... but you are tagging as MySQL... was that accidental, or deliberate?