欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  后端开发

碰到个问题,用网上提供的方法都不好用,求教

程序员文章站 2022-05-29 17:09:19
...
Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in


回复讨论(解决方案)

提供的信息太少

For some reason mysql on OS X gets the locations of the required socket file a bit wrong, but thanks to a veritable wizard I know (that's you, Gavin) the solution is as simple as setting up a symbolic link.

You may have a socket (appearing as a zero length file) as /tmp/mysql.sock or /var/mysql/mysql.sock but 1 or more apps is looking in the other location for it.

Rather than move the socket and have to edit config files and remember to keep edited files local and away from servers where the paths are correct, simply create a symbolic link so your mac finds the required socket, even when it's looking in the wrong place!

If you have /tmp/mysql.sock but no /var/mysql/mysql.sock then...

cd /var sudo mkdir mysqlsudo chmod 755 mysqlcd mysqlln -s /tmp/mysql.sock mysql.sock


If you have /var/mysql/mysql.sock but no /tmp/mysql.sock then

cd /tmpln -s /var/mysql/mysql.sock mysql.sock


You will need permissions to create the directory and link, so just prefix the commands above with sudo if necessary.