首页 > ThinkPHP框架连接不到本地数据库

ThinkPHP框架连接不到本地数据库

my.cnf的只兼听127.0.0.1已经注释掉.本地连接MySQL没问题.给的权限是正确的 确定sock位置在/var/lib/mysql/mysql.sock 监听端口3306 hosts.allow已经添加了ALL:ALLOW字段,my.cnf已经设置了skip-name-resolve
数据库服务器是127.0.0.1的错误代码如下:

Lost connection to MySQL server at 'reading initial communication packet', system error: 111
错误位置

FILE: /data1/www/htdocs/384/vaisyadmin/1/ThinkPHP/Library/Think/Db/Driver/Mysql.class.php  LINE: 56
TRACE

#0 /data1/www/htdocs/384/vaisyadmin/1/ThinkPHP/Library/Think/Db/Driver/Mysql.class.php(56): E('Lost connection...')
#1 /data1/www/htdocs/384/vaisyadmin/1/ThinkPHP/Library/Think/Db.class.php(208): Think\Db\Driver\Mysql->connect(Array, 0)
#2 /data1/www/htdocs/384/vaisyadmin/1/ThinkPHP/Library/Think/Db.class.php(161): Think\Db->multiConnect(true)
#3 /data1/www/htdocs/384/vaisyadmin/1/ThinkPHP/Library/Think/Db/Driver/Mysql.class.php(119): Think\Db->initConnect(true)
#4 /data1/www/htdocs/384/vaisyadmin/1/Application/Install/Controller/InstallController.class.php(81): Think\Db\Driver\Mysql->execute('CREATE DATABASE...')
#5 [internal function]: Install\Controller\InstallController->step2(Array, Array)
#6 /data1/www/htdocs/384/vaisyadmin/1/ThinkPHP/Library/Think/App.class.php(119): ReflectionMethod->invokeArgs(Object(Install\Controller\InstallController), Array)
#7 /data1/www/htdocs/384/vaisyadmin/1/ThinkPHP/Library/Think/App.class.php(159): Think\App::exec()
#8 /data1/www/htdocs/384/vaisyadmin/1/ThinkPHP/Library/Think/Think.class.php(117): Think\App::run()
#9 /data1/www/htdocs/384/vaisyadmin/1/ThinkPHP/ThinkPHP.php(131): Think\Think::start()
#10 /data1/www/htdocs/384/vaisyadmin/1/install.php(36): require('/data1/www/htdo...')
#11 {main}

更改数据库服务器为localhost时:

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
错误位置

FILE: /data1/www/htdocs/384/vaisyadmin/1/ThinkPHP/Library/Think/Db/Driver/Mysql.class.php  LINE: 56
TRACE

#0 /data1/www/htdocs/384/vaisyadmin/1/ThinkPHP/Library/Think/Db/Driver/Mysql.class.php(56): E('Can't connect t...')
#1 /data1/www/htdocs/384/vaisyadmin/1/ThinkPHP/Library/Think/Db.class.php(208): Think\Db\Driver\Mysql->connect(Array, 0)
#2 /data1/www/htdocs/384/vaisyadmin/1/ThinkPHP/Library/Think/Db.class.php(161): Think\Db->multiConnect(true)
#3 /data1/www/htdocs/384/vaisyadmin/1/ThinkPHP/Library/Think/Db/Driver/Mysql.class.php(119): Think\Db->initConnect(true)
#4 /data1/www/htdocs/384/vaisyadmin/1/Application/Install/Controller/InstallController.class.php(81): Think\Db\Driver\Mysql->execute('CREATE DATABASE...')
#5 [internal function]: Install\Controller\InstallController->step2(Array, Array)
#6 /data1/www/htdocs/384/vaisyadmin/1/ThinkPHP/Library/Think/App.class.php(119): ReflectionMethod->invokeArgs(Object(Install\Controller\InstallController), Array)
#7 /data1/www/htdocs/384/vaisyadmin/1/ThinkPHP/Library/Think/App.class.php(159): Think\App::exec()
#8 /data1/www/htdocs/384/vaisyadmin/1/ThinkPHP/Library/Think/Think.class.php(117): Think\App::run()
#9 /data1/www/htdocs/384/vaisyadmin/1/ThinkPHP/ThinkPHP.php(131): Think\Think::start()
#10 /data1/www/htdocs/384/vaisyadmin/1/install.php(36): require('/data1/www/htdo...')
#11 {main}

配置文件怎么写的


看一下php的配置信息 phpinfo(),应该是mysql.sock位置不对

【热门文章】
【热门文章】