blocks|key|4376882|text|在/etc/phpmyadmin/config.inc.php中将localhost更改为127.0.0.1|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4376883|$cfg['Servers'][$i]['host']+=+'127.0.0.1';|code-block|syntax|javascript|4376884|这是因为如果您使用本地主机，pma会尝试连接到mysql.socket。如果你使用127.0.0.1，PMA建立一个TCP连接，这应该可以工作。|4376885|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

change localhost to 127.0.0.1 in /etc/phpmyadmin/config.inc.php

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

The reason for this is that pma tries to connect to the mysql.socket if you use localhost. If you use 127.0.0.1 PMA makes a TCP connection which should work.

blocks|key|4376659|text|首先，确保mysql服务正在运行：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4376660|ps+elf%7Cgrep+mysql|code-block|syntax|javascript|4376661|如果正在运行，您将看到如下输出：|4376662|4+S+root++++++9642+++++1++0++80+++0+-++2859+do_wai+23:08+pts/0++++00:00:00+/bin/sh+/usr/bin/mysqld_safe+--datadir=/var/lib/mysql+--pid-file=/var/lib/mysql/tomcat-machine.local.pid
4+S+mysql+++++9716++9642++0++80+++0+-+200986+poll_s+23:08+pts/0+++00:00:00+/usr/sbin/mysqld+--basedir=/usr+--datadir=/var/lib/mysql+--plugin-dir=/usr/lib64/mysql/plugin+--user=mysql+--log-error=/var/lib/mysql/tomcat-machine.local.err+--pid-file=/var/lib/mysql/tomcat-machine.local.pid|4376663|然后在config.inc.php中将本地主机更改为127.0.0.1|4376664|$cfg['Servers'][$i]['host']+=+'127.0.0.1';|4376665|root“用户的默认密码为空"”请勿键入任何内容作为密码|4376666|如果不允许空密码，您需要重新编辑config.inc.php并更改：|4376667|$cfg['Servers'][$i]['AllowNoPassword']+=+true;|4376668|问题是配置设置和MySQL未运行的组合。这就是帮助我修复这个错误的原因。|4376669|entityMap^0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|10|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|14|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|15|8|@]|9|@]|A|$]]|$1|S|3|T|5|D|7|16|8|@]|9|@]|A|$E|F]]|$1|U|3|V|5|6|7|17|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|X|$]]

First of all, make sure the mysql service is running:

<pre><code>ps elf|grep mysql
</code></pre>

you will see an output like this if is running:

<pre><code>4 S root 9642 1 0 80 0 - 2859 do_wai 23:08 pts/0 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/tomcat-machine.local.pid
4 S mysql 9716 9642 0 80 0 - 200986 poll_s 23:08 pts/0 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/tomcat-machine.local.err --pid-file=/var/lib/mysql/tomcat-machine.local.pid
</code></pre>

then change localhost to 127.0.0.1 in config.inc.php

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

The default password for "root" user is empty "" do not type anything for the password

If it does not allow empty password you need to edit config.inc.php again and change:

<pre><code>$cfg['Servers'][$i]['AllowNoPassword'] = true;
</code></pre>

The problem is a combination of config settings and MySQL not running. This was what helped me to fix this error.

blocks|key|4377123|text|试一试|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4377124|sudo+service+mysql+restart|code-block|syntax|javascript|4377125|这对我很管用|4377126|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Try just
<pre><code>sudo service mysql restart
</code></pre>
It worked for me

blocks|key|4376806|text|我也有同样的问题。在我的/etc/mysql/my.cnf中，没有定义更多的mysqld.sock路径。所以我用：find+/+-type+s+%7C+grep+mysqld.sock开始搜索，但是找不到它。我用：apt+install+mysql-server-5.7重装了mysql+(请在执行当前sql-server-version之前检查)。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4376807|这解决了我的问题。|4376808|entityMap^0|C|H|12|B|1L|X|2X|S|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]|$9|M|A|N|B|C]|$9|O|A|P|B|C]|$9|Q|A|R|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|S|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|I|$]]

I had the same problem. In my <code>/etc/mysql/my.cnf</code> was no path more to <code>mysqld.sock</code> defined. So I started a search to find it with: <code>find / -type s | grep mysqld.sock</code> but it could not be found.
I reinstalled mysql with: <code>apt install mysql-server-5.7</code> (please check before execute the current sql-server-version).

This solved my problem.

blocks|key|4376847|text|mysqli_connect():+(HY000/2002):+No+such+file+or+directory|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|4376848|我在debian9虚拟机上遇到了同样的问题，我试图重启MySQL，但没有解决问题，之后我增加了内存(我被减少了)，它工作了。|unstyled|4376849|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>mysqli_connect(): (HY000/2002): No such file or directory
</code></pre>

I was facing same issue on debian9 VM, I tried to restart MySQL but it didn't solve the issue, after that I increased the RAM (I was reduced) and it worked.

blocks|key|4377340|text|如果您使用的是SELinux，请查看以下内容。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4377341|我也有同样的问题。我运行的是带有SELinux强制的CentOS+8，尽管所有的配置都得到了正确的修复，但我还是得到了问题(mysqli_real_connect():+(HY000/2002):+No+such+file+or+directory)中提到的错误。后来，在允许通过SELinux进行MySQL连接后，我摆脱了麻烦。|offset|length|style|CODE|4377342|使用以下命令检查SELinux状态：|4377343|sestatus|code-block|syntax|javascript|4377344|允许Apache通过SELinux连接数据库|4377345|setsebool+httpd_can_network_connect_db+1|4377346|Use+-P选项使更改永久化。如果没有此选项，布尔值将在重新启动时重置为0。|4377347|setsebool+-P+httpd_can_network_connect_db+1|4377348|entityMap^0|0|1Q|1Q|0|0|0|0|0|4|2|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@$D|10|E|11|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|12|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|13|8|@]|9|@]|A|$M|N]]|$1|O|3|P|5|6|7|14|8|@]|9|@]|A|$]]|$1|Q|3|R|5|L|7|15|8|@]|9|@]|A|$M|N]]|$1|S|3|T|5|6|7|16|8|@$D|17|E|18|F|G]]|9|@]|A|$]]|$1|U|3|V|5|L|7|19|8|@]|9|@]|A|$M|N]]|$1|W|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|X|$]]

<h2>If you are using SELinux, check this out.</h2>
I had the same problem. I was running CentOS 8 with SELinux enforcing, and I was getting the error mentioned in the question (<code>mysqli_real_connect(): (HY000/2002): No such file or directory</code>) despite having all the configurations fixed correctly. I later got out of trouble after allowing MySQL connections through SELinux.
Check SELinux status using this command:
<pre class="lang-sh prettyprint-override"><code>sestatus
</code></pre>
Allow Apache to connect database through SELinux
<pre><code>setsebool httpd_can_network_connect_db 1
</code></pre>
Use <code>-P</code> option makes the change permanent. Without this option, the boolean would be reset to 0 at reboot.
<pre><code>setsebool -P httpd_can_network_connect_db 1
</code></pre>

blocks|key|4377092|text|如果您使用的是Mac+OS和Brew，请尝试以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4377093|mkdir+/usr/local/etc/my.cnf.d|code-block|syntax|javascript|4377094|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If you used Mac OS and Brew try this: 

<pre><code>mkdir /usr/local/etc/my.cnf.d
</code></pre>

blocks|key|4376926|text|在linux中，只需这样做|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4376927|sudo+systemctl+stop+mysql

sudo+systemctl+start+mysql|code-block|syntax|javascript|4376928|对我很管用|4376929|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

In linux just do
<pre><code>sudo systemctl stop mysql

sudo systemctl start mysql
</code></pre>
worked for me

blocks|key|4376606|text|如果上述解决方案不起作用，请尝试将默认por从3306更改为另一个(即3307)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4376607|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|$]]

If above solutions doesn't work, try to change the default por from 3306, to another one (i.e. 3307)

blocks|key|4376921|text|您只需要将ib_logfile0和ib_logfile1重命名为ib_logfile_0和ib_logfile_1，问题就解决了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4376922|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|$]]

You just need to rename ib_logfile0 and ib_logfile1 as ib_logfile_0 and ib_logfile_1. Then your problem would be solved.

<pre><code>mysqli_real_connect(): (HY000/2002): No such file or directory
</code></pre>

PhpMyAdmin error on MacOS. I want answer I really have no idea what I need to do to resolve this.

mysqli_real_connect(): (HY000/2002): No such file or directory

数据库

虚拟机

CentOS

MySQL

MacOS

mysqli_real_connect(): (HY000/2002): No such file or directoryMacOS上出现PhpMyAdmin错误。我想要答案我真的不知道我需要做什么来解决这个问题。

问mysqli_real_connect()：(HY000/2002)：没有这样的文件或目录
EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问mysqli_real_connect()：(HY000/2002)：没有这样的文件或目录EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问mysqli_real_connect()：(HY000/2002)：没有这样的文件或目录
EN