英文:
I setup WordPress as an app service on Azure. I want to edit locally on my PC; how do I connect the Azure MySql locally?
问题
我应该怎么做？
我已经通过VS Code连接到Azure。
我已经编辑了我的PHP文件，但是我无法在本地运行WP站点，因为我不知道如何连接数据库。
我希望能够在本地进行所有编辑，然后推送到线上站点。
英文:
What do I do?
I have connected to Azure via vs code
I have edited my php files; but I cannot run the WP site locally because I don't know how to connect database.
I want to be able to do all my edits locally and push to the live site.
答案1
得分: 0
我已创建了WordPress + MySQL Flexible Server。
在Azure App Service => Configuration Section中，默认情况下将保存与数据库相关的所有键值。
>我如何在本地连接Azure MySQL？
如MSDoc中所述使用MySQL Workbench连接并查询Azure Database for MySQL中的数据
-
我们可以使用
MySQL Workbench在本地连接Azure MySQL。 -
甚至您可以在
Azure MySQL DB中查看相同的内容。
您将找到不同的选项以在本地连接到数据库。
安装MySQL Workbench的最新版本并进行本地连接。
- 通过提供来自MySQL DB的详细信息设置新连接。
- 现在您可以通过此处查询/修改管理数据库。
英文:
I have created WordPress + MySQL Flexible Server .
In Azure App Service => Configuration Section, All the key-values related to Database will be saved by deafult.
>how do I connect the Azure MySql locally?
As mentioned in the MSDoc Use MySQL Workbench to connect and query data in Azure Database for MySQL
-
We can use
MySQL Workbenchto connectAzure MySQLLocally. -
Even you can check the same in the
Azure MySQL DB.
You will find different options to connect to DB Locally.
Install the MySQL Workbench latest version and connect locally.
- Setup a new connection by providing the details from MySQL DB.
- Now you can manage the DB by querying/modifying from here.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论