Simple way to connect a PHP Script to a MySQL Server and select a MySQL Database

Simple way to connect a PHP Script to a MySQL Server and select a MySQL Database.

<?php
 
 
        //Define properties
        $db_hostname="localhost";
        $db_user="root";
        $db_passwd="adminmysqlcasa";
        $db_name="family";
 
        //Procedure MySQL connect
        mysql_connect($db_hostname, $db_user, $db_passwd) or die(mysql_error());
        echo "<p>Connected to MySQL host " . $db_hostname . "</p>";
 
 
        //Procedure Select & Use database
        mysql_select_db($db_name) or die(mysql_error());
        echo "<p>Connected to MySQL database " . $db_name . "</p>";
 
 
?>

Tags: , , , ,

categories MySQL, PHP | | datetime March 17, 2011 7:57 pm | comments Comments (0)

Alter Active Directory user properties with Powershell QAD Tools Get-QADUser Set-QADUser PasswordNeverExpires User-Change-Password

Follow these instructions:

Firstly load the powershell console from the commandline cmd>Powershell
Next one…

set-Location c:\
Add-PSSnapin Quest.ActiveRoles.ADManagement
Get-PSsnapin
Set-QADPSSnapinSettings -DefaultSizeLimit 0
Get-Command Get-QAD*

List users

Get-QADUser | select-object ClassName, Name, SamAccountName, PrimarySMTPAddress, whenCreated, LastLogon, PasswordNeverExpires, AccountIsDisabled | Where { $_.PasswordNeverExpires -match "True" } | Format-Table
Disable password never expire user property from an active directory
Get-QADUser -Identity &lt;sAMAccountName&gt; | Set-QADUser -passwordNeverExpires $false

Disable user can not change password user property from an active directory

Get-QADUser &lt;sAMAccountName&gt; | Get-QADPermission -Account SELF,Everyone -ExtendedRight 'User-Change-Password' | Remove-QADPermission

Tags: , , , , , , , ,

categories Active Directory, Powershell | | datetime 7:47 pm | comments Comments (0)

WordPress Themes