求imc裝mariadb數據庫腳本

以下是在Windows Server操作係統上使用管理員權限的PowerShell腳本來安裝MariaDB數據庫並創建相應的數據庫和用戶的示例： 

# 確保以管理員權限運行此腳本
if (-not ([Security.Principal.WindowsPrincipal][Security.Principal.WindowsIdentity]::GetCurrent()).IsInRole([Security.Principal.WindowsBuiltInRole] "Administrator")) {
Write-Warning "請以管理員權限運行此腳本"
exit
}

# 設置變量以便於後續使用
$mariaDbVersion = "10.5.12"
$mariaDbRootPassword = "YourMariaDBRootPassword"
$imcDbName = "imcdb"
$imcDbUser = "imcuser"
$imcDbPassword = "YourIMCDatabasePassword"

# 下載MariaDB二進製文件並安裝
Invoke-WebRequest -Uri "***.***/interstitial/mariadb-$($mariaDbVersion)/win32-packages/mariadb-$($mariaDbVersion)-winx64.zip/from/https%3A//***.***/mariadb/?serve" -OutFile "mariadb-$($mariaDbVersion)-winx64.zip"
Expand-Archive -Path "mariadb-$($mariaDbVersion)-winx64.zip" -DestinationPath "C:\Program Files\MariaDB"
Set-Location "C:\Program Files\MariaDB\mariadb-$($mariaDbVersion)\bin"
.\mysql_install_db.exe --datadir="C:\ProgramData\MariaDB\data"

# 啟動MariaDB服務並設置根密碼
Start-Service MariaDB
.\mysql.exe -u root -e "ALTER USER 'root'@'localhost' IDENTIFIED BY '$($mariaDbRootPassword)'"
.\mysql.exe -u root -p"$($mariaDbRootPassword)" -e "FLUSH PRIVILEGES"

# 創建IMC所需的數據庫和用戶
.\mysql.exe -u root -p"$($mariaDbRootPassword)" -e "CREATE DATABASE $imcDbName CHARACTER SET utf8 COLLATE utf8_general_ci;"
.\mysql.exe -u root -p"$($mariaDbRootPassword)" -e "CREATE USER '$imcDbUser'@'localhost' IDENTIFIED BY '$imcDbPassword';"

.\mysql.exe -u root -p"$($mariaDbRootPassword)" -e "GRANT ALL PRIVILEGES ON $imcDbName.* TO '$imcDbUser'@'localhost';" 

在上述示例中，我們首先設置了一些變量以便於後續使用，例如MariaDB的版本、根密碼、IMC所需的數據庫名稱、用戶名和密碼等。然後，我們使用Invoke-WebRequest cmdlet下載Mariadb二進製文件，並使用Expand-Archive cmdlet將其解壓到“C:\Program Files\MariaDB”目錄下。接下來，我們啟動MariaDB服務並使用mysql.exe命令行工具設置根密碼。最後，我們創建了IMC所需的數據庫和用戶，並授予該用戶訪問相應數據庫的所有權限