我在使用Azure上的MySQL In App的App Service上访问phpmyadmin时遇到问题 [英] I have a problem with the access to phpmyadmin on App Service with MySQL In App on Azure

问题描述

我在App中创建了一个带有MySQL的App Services，我可以使用我的php代码访问BD，但是如果我尝试使用phpmyadmin访问系统就会启动错误

错误

MySQL说：

＃2002 - 尝试以其访问权限禁止的方式访问套接字。

- 服务器没有响应（或者本地服务器的套接字未正确配置）。

解决方案

有时  mysqli_connect 方法
需要数据库的工作套接字（数据库主机的IP地址和端口号）。所以如果你注释掉了




cfg ['Servers']




i] ['host']
='127.0.0.1 ';  行或将'localhost'设置为其中的值，它会忽略端口号。但如果你想要
来使用套接字，那么你必须使用'127.0.0.1'或真实的主机名。 

检查并遵循以下指南：

1.找到您的  config.inc.php  文件
与PHPMyAdmin有关。

2.找到该行 

I create a App Services with MySQL in App, and i can access to BD with my php code, but if I try access with phpmyadmin the system launch a error

Error

MySQL said:

#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).

解决方案

Sometimes the mysqli_connectmethod requires a working socket (IP Address of the DB Host along with the Port number) of the database. So if you have commented out the 




cfg['Servers']




i]['host'] = '127.0.0.1'; line or have set 'localhost' as the value in it, it ignores the port number. But if you want to use a socket, then you have to use '127.0.0.1' or the real hostname. 

Check and follow below guidelines:

1. Locate your config.inc.php file which relates to PHPMyAdmin.

2. Locate the line 

这篇关于我在使用Azure上的MySQL In App的App Service上访问phpmyadmin时遇到问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！