Examples/Sample_InstallMySQL_Default.ps1
|
configuration SQLInstanceInstallationConfiguration { param ( [parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] [String] $MySQLInstancePackagePath, [parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] [String] $MySQLInstancePackageName ) Import-DscResource -Module xMySql node $AllNodes.NodeName { xPackage mySqlInstaller { Path = $MySQLInstancePackagePath ProductId = $Node.PackageProductID Name = $MySQLInstancePackageName } xMySqlServer MySQLInstance { Ensure = "Present" RootPassword = $global:cred ServiceName = "MySQLServerInstanceName" DependsOn = "[xPackage]mySqlInstaller" } } } <# Sample use (parameter values need to be changed according to your scenario): #> $global:pwd = ConvertTo-SecureString "pass@word1" -AsPlainText -Force $global:usrName = "administrator" $global:cred = New-Object -TypeName System.Management.Automation.PSCredential ($global:usrName,$global:pwd) SQLInstanceInstallationConfiguration ` -MySQLInstancePackagePath "http://dev.mysql.com/get/Downloads/MySQLInstaller/mysql-installer-community-5.6.17.0.msi" ` -MySQLInstancePackageName "MySQL Installer" -ConfigurationData .\nodedata.psd1 |