如何管理在 Azure 中创建的 mysql 数据库？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/12190067/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to manage mysql databases created in Azure?
提问by Moisés Brise?o Estrello
Azure websites let us configure our site using a new MySQL Database instead of SQL Azure. But after creation it's never visible in admin panel. I beleive that it's because is hosted in a third party server, but I have no idea how to reach it, any tip?
Azure 网站让我们可以使用新的 MySQL 数据库而不是 SQL Azure 来配置我们的站点。但在创建后，它在管理面板中永远不可见。我相信这是因为托管在第三方服务器中，但我不知道如何访问它，有什么提示吗？
回答by Jim O'Neil
For managing it from an external tool check out my response here.
要从外部工具管理它，请在此处查看我的回复。
Though the database is hosted by a third party (ClearDB), you should see it listed as a "linked resource" on the dashboard for your Web Site in the Windows Azure portal. When you delete the Web Site, it asks if you also want to delete the linked resource.
尽管该数据库由第三方 (ClearDB) 托管，但您应该会在 Windows Azure 门户网站的仪表板上看到它列为“链接资源”。当您删除网站时，它会询问您是否还想删除链接的资源。
If you choose not to or you unlink the MySQL resource explicitly, it's still there and you'll see it a list of existing resources when you subsequently do an explicit link. (I haven't found a way to see a list of the unlinked MySQL databases, but will update this response when I hear).
如果您选择不这样做或明确取消链接 MySQL 资源，它仍然存在，并且当您随后执行显式链接时，您将看到现有资源的列表。（我还没有找到查看未链接的 MySQL 数据库列表的方法，但我会在听到时更新此响应）。
So I'd say to delete the MySQL database you can
所以我会说你可以删除MySQL数据库
Delete the entire Web Site and, when prompted, select the MySQL database to be deleted too
Unlink the MySQL database from the Web Site you want to keep; create a new temp Web Site, and add the existing MySQL database as a Linked Resource to it. Then delete the new, temp Web Site along with the linked database. Not elegant, but seems to work in my testing.
删除整个网站，并在提示时选择要删除的 MySQL 数据库
从您要保留的网站上取消 MySQL 数据库的链接；创建一个新的临时网站，并将现有的 MySQL 数据库作为链接资源添加到它。然后删除新的临时网站以及链接的数据库。不优雅，但似乎在我的测试中有效。
回答by astaykov
Currently you can't manage the MySQL Server.
目前您无法管理 MySQL 服务器。
As for being third party - yes, the service (MySQL-as-a-Service) is provided by a third party byt lives in Azure! It is not on other servers, it is on the Azure servers. Most probably (just my guess) worker roles. But as the feature is still preview, the management is missing.
至于第三方——是的，服务（MySQL-as-a-Service）是由第三方提供的 byt 住在 Azure 中！它不在其他服务器上，而是在 Azure 服务器上。最有可能（只是我的猜测）工人角色。但是由于该功能仍然是预览版，因此缺少管理。
The third party vendor is ClearDB. They provide MySQL as a service on top of Windows Azure. so no worries, your data is in the same Data Center (of course if you chose same) as your web site. But you can't directly manage it, unless you install something like PhpMyAdminon your website.
第三方供应商是ClearDB。他们在 Windows Azure 之上提供 MySQL 作为服务。所以不用担心，您的数据与您的网站位于同一个数据中心（当然，如果您选择相同）。但是你不能直接管理它，除非你在你的网站上安装了类似PhpMyAdmin 的东西。
回答by Jim Wang
I had a slightly different issue where Jim O'Neil's #2 didn't fully work because the database that was orphaned was created through the "Add-On" gallery. To work around this, you can link the orphaned database to the new temporary site as suggested, and then click on the "Manage" link in the Linked Resources tab with the database selected. This will take you to ClearDB's management for the databases.
我有一个稍微不同的问题，即 Jim O'Neil 的 #2 没有完全工作，因为孤立的数据库是通过“附加”库创建的。要解决此问题，您可以按照建议将孤立的数据库链接到新的临时站点，然后单击“链接资源”选项卡中的“管理”链接并选择数据库。这将带您进入 ClearDB 对数据库的管理。
From there, you can click on the first tab, and then click "Delete" to manually delete the database from ClearDB. This is an async operation so it may take some time, and you may also have to refresh the portal because the entries are cached.
从那里，您可以单击第一个选项卡，然后单击“删除”以从 ClearDB 中手动删除数据库。这是一个异步操作，因此可能需要一些时间，并且您可能还必须刷新门户，因为条目已缓存。
回答by Brian Ogden
You can also add the ClearDB Add-on and create either the Free tier or the 9.99 a month Venus 1gb tier. The Free tier is only 20mb so that isn't much. For the database name, you can type in the existing MySQL database, and ClearDB Add-on will link to that.
您还可以添加 ClearDB 附加组件并创建免费层或每月 9.99 的 Venus 1GB 层。免费层只有 20mb，所以这并不多。对于数据库名称，您可以输入现有的 MySQL 数据库，ClearDB Add-on 将链接到该数据库。
回答by WearySky
I know this is a super old question, but it's the first result that came up when I did a Google search for deleting mysql azure databases. You canmanage your MySql databases from the management portal now, via the Linked Resources page. Either click on the name of the mysql DB directly, or select the row and click manage down at the bottom.
我知道这是一个非常古老的问题，但这是我在谷歌搜索删除 mysql azure 数据库时出现的第一个结果。您可以管理从管理你的MySQL数据库现在的门户网站，通过链接的资源页面。或者直接点击mysql数据库的名称，或者选择行并点击底部的manage down。
回答by runningmark
i know that this is a late answer but i followed them to gain the exact access
我知道这是一个迟到的答案，但我跟着他们获得了确切的访问权限
- Select Your web app
- Clicked linked resources
- Click on mysql db name (It will redirect you to cleardb website for your account)
- Install mysql workbench
- click on endpoint information
- in mysql workbench give the value of hostname, and access credentials i.e. username, password
- 选择您的网络应用
- 单击链接的资源
- 单击 mysql db 名称（它会将您重定向到您帐户的 cleardb 网站）
- 安装mysql工作台
- 点击端点信息
- 在 mysql 工作台中给出主机名的值，并提供访问凭据，即用户名、密码
and you are good to go :)
你很高兴去:)
回答by Brad Wulf
Resuscitating a year old thread, but it still showed up in google search. Anyway, I've done a step by step overview of how to configure MySQL on Azure to allow external connections and connect to it via your favorite DB tool. It is product specific, but works for any tool. link
复苏了一年前的线程，但它仍然出现在谷歌搜索中。无论如何，我已经逐步概述了如何在 Azure 上配置 MySQL 以允许外部连接并通过您最喜欢的数据库工具连接到它。它是特定于产品的，但适用于任何工具。 关联
