blocks|key|1634955|text|检查并遵循以下指导方针：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1634956|1.查找与config.inc.php相关的PHPMyAdmin文件。|offset|length|style|CODE|1634957|2.定位行$cfg['Servers'][$i]['host']+--这一行在默认情况下可能已被注释掉，如果是，请取消注释。|1634958|3.将这一行改为：|1634959|$cfg['Servers'][$i]['host']+=+'127.0.0.1';|1634960|4.保存它并从XAMPP控制面板重新启动MySQL数据库。|1634961|5.将$host方法中的mysqli_connect()参数值更改为：|1634962|`$_connection+=+mysqli_connect(**"localhost:+3306"**,+$_mysql_username,+$_mysql_password,+$_database);`|code-block|syntax|javascript|1634963|注意事项：这3306是我的MySQL端口号，这是默认的。在执行以下步骤之前，最好先检查一下实际的MySQL端口号。|BOLD|1634964|有关更多细节，您可以参考这个类似的问题。|1634965|entityMap|0|LINK|mutability|MUTABLE|url|https://social.msdn.microsoft.com/Forums/azure/en-US/b7f1bcac-751a-4b5c-b6b8-d568bef707b3/i-have-a-problem-with-the-access-to-phpmyadmin-on-app-service-with-mysql-in-app-on-azure^0|0|5|E|M|A|0|5|R|0|0|0|16|0|0|C|G|0|0|0|4|0|H|2|0|0^^$0|@$1|2|3|4|5|6|7|19|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1A|8|@$D|1B|E|1C|F|G]|$D|1D|E|1E|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|1F|8|@$D|1G|E|1H|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|1I|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1J|8|@$D|1K|E|1L|F|G]]|9|@]|A|$]]|$1|N|3|O|5|6|7|1M|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1N|8|@$D|1O|E|1P|F|G]]|9|@]|A|$]]|$1|R|3|S|5|T|7|1Q|8|@]|9|@]|A|$U|V]]|$1|W|3|X|5|6|7|1R|8|@$D|1S|E|1T|F|Y]]|9|@]|A|$]]|$1|Z|3|10|5|6|7|1U|8|@]|9|@$D|1V|E|1W|1|1X]]|A|$]]|$1|11|3|-4|5|6|7|1Y|8|@]|9|@]|A|$]]]|12|$13|$5|14|15|16|A|$17|18]]]]

Check and follow below guidelines:

1.Locate your <code>config.inc.php</code> file which relates to <code>PHPMyAdmin</code>.

2.Locate the line <code>$cfg['Servers'][$i]['host']</code> mostly this line might have been commented out by default, if so please uncomment it.

3.And replace that line with following: 

<code>$cfg['Servers'][$i]['host'] = '127.0.0.1';</code>

4.Save it and restart the MySQL Database from your XAMPP control panel.

5.Change your $host parameter value in the <code>mysqli_connect()</code> method to following:

<pre><code>`$_connection = mysqli_connect(**"localhost: 3306"**, $_mysql_username, $_mysql_password, $_database);`
</code></pre>

Note: This 3306 is my MySQL port number which is its default. You should better check what's your actual MySQL Port number before going to follow these steps.

For more details you could refer to this similar <a href="https://social.msdn.microsoft.com/Forums/azure/en-US/b7f1bcac-751a-4b5c-b6b8-d568bef707b3/i-have-a-problem-with-the-access-to-phpmyadmin-on-app-service-with-mysql-in-app-on-azure" rel="nofollow noreferrer">issue</a>.

blocks|key|1634984|text|这很简单。如果您已经停止网站并再次启动它，您必须从浏览器连接到网站网址，然后才能使用phpMyAdmin。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1634985|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

It's simple.
If you have stopped the website and started it again, you must connect to the website URL from a browser, before you can use phpMyAdmin.

I created an Azure App Service and enabled MySql in App. I able to connect to MySql using phpMyAdmin from portal - go to app -> MySql in App -> click manage. It open another window with phpMyAdmin. 

But somehow now I am not able to connect to database. I get below error

<blockquote>
 MySQL said: Documentation
 
 2002 - An attempt was made to access a socket in a way forbidden by
 its access permissions. — The server is not responding (or the local
 server's socket is not correctly configured).
</blockquote>

Access denied error while connecting to MySQL in App in Azure App Service

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我创建了一个Azure应用程序服务，并在App中启用了MySql。我能够连接到MySql使用phpMyAdmin从门户-转到应用程序-> MySql在应用程序->点击管理。它用phpMyAdmin打开另一个窗口。但不知为何，现在我无法连接到数据库。我得到了以下错误MySQL说:文档2002年-试图以其访问权限所禁止的方...

问在Azure应用程序服务中连接应用程序中的MySQL时拒绝访问错误
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在Azure应用程序服务中连接应用程序中的MySQL时拒绝访问错误EN