Gets a MySQL database.
Syntax
Parameter Set: Default
Get-MgmtSvcMySqlDatabase [-AdminUri] <Uri> [-Token]
<String> [-HostingServerId] <String> [[-Name]
<String> ] [-Descending] [-DisableCertificateValidation]
[-First <Int32> ] [-Skip <Int32> ] [
<CommonParameters>]
The Get-MgmtSvcMySqlDatabase cmdlet gets MySQL databases. By default, all MySQL databases for a hosting server are returned. To get a specific MySQL database, use the Name parameter.
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 |
Indicates that the returned databases are displayed in descending order.
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
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 |
Gets only the specified number of MySQL databases.
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
True (ByPropertyName) |
Accept Wildcard Characters? |
false |
Specifies the ID of a MySQL hosting server.
Aliases |
none |
Required? |
true |
Position? |
3 |
Default Value |
none |
Accept Pipeline Input? |
True (ByPropertyName) |
Accept Wildcard Characters? |
false |
Specifies the name of a MySQL hosting server.
Aliases |
none |
Required? |
false |
Position? |
4 |
Default Value |
none |
Accept Pipeline Input? |
True (ByPropertyName) |
Accept Wildcard Characters? |
false |
Skips the specified number of MySQL databases.
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
True (ByPropertyName) |
Accept Wildcard Characters? |
false |
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 |
This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see about_CommonParameters.
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 gets the database named MYSQLDB01 on the hosting server with the ID v48l25.
PS C:\> Get-MgmtSvcMySqlDatabase -AdminUri "https://Computer01:30004" -Token $Token -HostingServerId "v48l25" -Name "MYSQLDB01"