Azure PowerShell – MariaDB
This section provides cmdlet reference and usage examples for managing Azure Database for MariaDB with Azure PowerShell.
Cmdlet Overview
| Cmdlet | Description | Link |
|---|---|---|
Get-AzMariaDbServer | Retrieve information about MariaDB servers. | Details |
New-AzMariaDbServer | Create a new MariaDB server. | Details |
Remove-AzMariaDbServer | Delete an existing MariaDB server. | Details |
Set-AzMariaDbServer | Update properties of a MariaDB server. | Details |
Get-AzMariaDbDatabase | List databases within a MariaDB server. | Details |
New-AzMariaDbDatabase | Create a database in a MariaDB server. | Details |
Remove-AzMariaDbDatabase | Delete a database from a MariaDB server. | Details |
Set-AzMariaDbDatabase | Update database settings. | Details |
Get-AzMariaDbFirewallRule | Retrieve firewall rules for a server. | Details |
New-AzMariaDbFirewallRule | Create a new firewall rule. | Details |
Remove-AzMariaDbFirewallRule | Delete a firewall rule. | Details |
Sample Scripts
# Create a MariaDB server
$resourceGroup = "MyResourceGroup"
$serverName = "my-mariadb-server"
$location = "EastUS"
$adminUser = "mariadbadmin"
$adminPassword = "P@ssw0rd!"
New-AzMariaDbServer -ResourceGroupName $resourceGroup `
-Name $serverName -Location $location `
-AdministratorLogin $adminUser -AdministratorLoginPassword (ConvertTo-SecureString $adminPassword -AsPlainText -Force) `
-SkuName "GP_Gen5_2" -Version "10.3"
# Add a firewall rule
New-AzMariaDbFirewallRule -ResourceGroupName $resourceGroup -ServerName $serverName `
-Name "AllowAll" -StartIpAddress "0.0.0.0" -EndIpAddress "255.255.255.255"
# Create a database
New-AzMariaDbDatabase -ResourceGroupName $resourceGroup -ServerName $serverName `
-Name "sampledb"