Get-MgmtSvcMySqlHostingServer

Gets a MySQL hosting server.

Syntax

Parameter Set: Default
Get-MgmtSvcMySqlHostingServer [-AdminUri] <Uri> [-Token] <String> [[-Name] <String> ] [-Descending] [-DisableCertificateValidation] [-First <Int32> ] [-Skip <Int32> ] [ <CommonParameters>]

Detailed Description

The Get-MgmtSvcMySqlHostingServer cmdlet gets a MySQL hosting server. By default, all hosting servers are returned. To get a specific hosting server, use the Name parameter. You can also get a specified number of servers by using the First and Skip parameters.

Parameters

-AdminUri<Uri>

Specifies the URI of the Windows Azure Pack administrator API. Use the following format: https://<computer>:<port>, where <computer> is the computer on which the administrator API is installed.

Aliases	none
Required?	true
Position?	1
Default Value	none
Accept Pipeline Input?	True (ByPropertyName)
Accept Wildcard Characters?	false

-Descending

Indicates that the returned servers are displayed in descending order.

Aliases	none
Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

-DisableCertificateValidation

Disables certificate validation for the Windows Azure Pack installation.

If you specifiy this parameter, you can use self-signed certificates.

Aliases	none
Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

-First<Int32>

Gets only the specified number of SQL hosting servers.

Aliases	none
Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	True (ByPropertyName)
Accept Wildcard Characters?	false

-Name<String>

Specifies the name of a SQL hosting server.

Aliases	none
Required?	false
Position?	3
Default Value	none
Accept Pipeline Input?	True (ByPropertyName)
Accept Wildcard Characters?	false

-Skip<Int32>

Skips the specified number of SQL hosting servers.

Aliases	none
Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	True (ByPropertyName)
Accept Wildcard Characters?	false

-Token<String>

Specifies an identity token. To create a token, use the Get-MgmtSvcToken cmdlet.

Aliases	none
Required?	true
Position?	2
Default Value	none
Accept Pipeline Input?	True (ByPropertyName)
Accept Wildcard Characters?	false

<CommonParameters>

This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see about_CommonParameters.

Examples

Example 1: Get a specific MySQL hosting server by name

NOTE: This example assumes that you have created a token by using Get-MgmtSvcToken and have stored it in a variable named $Token.

This command gers the MySQL hosting server named MySQLServer01.Contoso.com.

PS C:\> Get-MgmtSvcMySqlHostingServer -AdminUri "https://Computer01:30004" -Token $Token -Name "MySQLServer01.Contoso.com"

Get-MgmtSvcMySqlHostingServer