如何在Azure门户中查找Web应用使用的ClearDB MySQL数据库？

Hey there, I’ve dealt with this exact issue before when working with ClearDB and Azure App Service—let’s break down the most reliable ways to find that missing database:

• Use the Azure Portal Search Bar
  The fastest shortcut: Head to the top search bar in the Azure Portal and type either "ClearDB" or the specific name of your database (if you remember it). ClearDB resources often live outside the immediate resource group of your App Service, so a direct search cuts through the noise.

• Check Your App Service’s Configuration Settings
  Navigate to your Web App’s dashboard, then go to Configuration > Application settings. Look for an app setting named CLEARDB_DATABASE_URL—this string contains your database’s connection details, including the resource name. Copy that name and paste it into the portal search to jump straight to the database.

• Query via Azure CLI/Cloud Shell
  If you prefer command-line tools, open the Azure Cloud Shell (the >_ icon in the portal top bar) and run these commands:

  1. First, get your App Service’s app settings to locate the ClearDB connection info:

     az webapp config appsettings list --name <your-webapp-name> --resource-group <your-resource-group-name>
     

  2. Or, search directly for all ClearDB resources in your subscription:

     az resource list --query "[?type=='ClearDB.MySQL/databases']"
     

• Navigate to ClearDB’s Dedicated Portal Section
  In the Azure Portal, click on All services (the hamburger menu in the top left), then search for "ClearDB MySQL Databases" under the Databases category. This will take you to a dedicated page listing all your ClearDB instances across subscriptions.

• Adjust Resource Group Filters
  If you’re looking in your App Service’s resource group and not seeing the database, check the filter at the top of the resource group page. Make sure All types is selected, or manually check the "ClearDB MySQL Database" option—sometimes default filters hide non-standard resource types.

A quick note: The "Linked Resources" section mentioned in older guides has been phased out in the updated Azure Portal, so you don’t need to worry about not finding that option anymore.

内容的提问来源于stack exchange，提问作者Ryan