zl程序教程

您现在的位置是:首页 >  数据库

当前栏目

php不能连接数据库phperrorCan'tconnecttolocalMySQLserver

2023-06-13 09:14:28 时间
测试的php文件
<?php
$link=mysql_connect("localhost","root","zz")ordie(mysql_error());
mysql_select_db("test")ordie("nodb");
mysql_query("SETNAMESutf8");
echo99;
?>
运行后报错
Can"tconnecttolocalMySQLserverthroughsocket"/tmp/mysql.sock"
但在命令行中能进入mysql
[root@localhostlocal]#mysql-uroot-p
Enterpassword:
WelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis3Serverversion:5.5.2-m2Sourcedistribution
Type"help;"or"\h"forhelp.Type"\c"toclearthebuffer.
mysql>
解决办法
chown-Rroot/usr/local/mysql
chgrp-Rmysql/usr/local/mysql
chown-Rroot/usr/local/mysql/bin
chgrp-Rmysql/usr/local/mysql/bin
chgrp-Rmysql/var/lib/mysql
chmod777/var/lib/mysql
chown-Rroot/var/lib/mysql/mysql
chgrp-Rmysql/var/lib/mysql/mysql
chmod777/var/lib/mysql/mysql
chown-Rroot/var/lib/mysql/mysql/*
chgrp-Rmysql/var/lib/mysql/mysql/*
chmod777/var/lib/mysql/mysql/*
chmod777/usr/local/mysql/lib/mysql/libmysqlclient.a