mysql - ThinkPHP框架连接不到本地数据库
大家讲道理
大家讲道理 2017-04-17 14:23:52
[MySQL讨论组]

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}
大家讲道理
大家讲道理

光阴似箭催人老,日月如移越少年。

全部回复(2)
PHP中文网

配置文件怎么写的

怪我咯

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

热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板
关于我们 免责申明 意见反馈 讲师合作 广告合作 最新更新 English
php中文网:公益在线php培训,帮助PHP学习者快速成长!
关注服务号 技术交流群
PHP中文网订阅号
每天精选资源文章推送
PHP中文网APP
随时随地碎片化学习
PHP中文网抖音号
发现有趣的

Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号