VPS侦探论坛

标题: 安装lnmp1.3后mysql无法登陆 [打印本页]

作者: hcdoo6tsdl 时间: 2016-5-5 16:01
标题: 安装lnmp1.3后mysql无法登陆
用的contos7系统  64位
之前用的是lnmp1.2  使用安装包内的uninstall.sh脚本卸载
这是安装后的日志信息结尾
+------------------------------------------------------------------------+
|       LNMP V1.3 for CentOS Linux Server, Written by Licess       |
+------------------------------------------------------------------------+
|       For more information please visit http://www.lnmp.org       |
+------------------------------------------------------------------------+
| lnmp status manage: lnmp {start|stop|reload|restart|kill|status} |
+------------------------------------------------------------------------+
|  phpMyAdmin: http://IP/phpmyadmin/                                  |
|  phpinfo: http://IP/phpinfo.php                                     |
|  Prober:  http://IP/p.php                                           |
+------------------------------------------------------------------------+
|  Add VirtualHost: lnmp vhost add                                     |
+------------------------------------------------------------------------+
|  Default directory: /home/wwwroot/default                            |
+------------------------------------------------------------------------+
|  MySQL/MariaDB root password: 123123                         |
+------------------------------------------------------------------------+
+-------------------------------------------+
| Manager for LNMP, Written by Licess |
+-------------------------------------------+
|             http://lnmp.org             |
+-------------------------------------------+
nginx (pid 58674 58673 58672 58671 58670) is running...
php-fpm is runing!
MySQL is running but PID file could not be found[失败]

Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address          Foreign Address       State
tcp       0    0 0.0.0.0:80             0.0.0.0:*             LISTEN
tcp       0    0 192.168.122.1:53       0.0.0.0:*             LISTEN
tcp       0    0 0.0.0.0:22             0.0.0.0:*             LISTEN
tcp       0    0 127.0.0.1:631          0.0.0.0:*             LISTEN
tcp6    0    0 :::3306                :::*                   LISTEN
tcp6    0    0 :::22                :::*                   LISTEN
tcp6    0    0 ::1:631                :::*                   LISTEN
[0;32mInstall lnmp V1.3 completed! enjoy it.[0m

提示mysql PID没找到

mysql错误日志奉上
请军哥帮忙看看

[ 本帖最后由 hcdoo6tsdl 于 2016-5-6 09:32 编辑 ]

作者: licess 时间: 2016-5-5 21:10
日志里有个2016-05-05T07:29:59.866426Z 0 [ERROR] Plugin keyring_file reported: 'keyring_file initialization failure. Please check if the keyring_file_data points to readable keyring file or keyring file can be created in the specified location. The keyring_file will stay unusable until correct path to the keyring file gets provided'
的错误，这个在我们的测试中这个应该是不影响的，可以通过修改/etc/my.cnf 文件，在[mysqld]段中加入early-plugin-load = ""解决

再传lnmp安装日志看看

作者: hcdoo6tsdl 时间: 2016-5-6 09:33
标题: 回复 2# 的帖子
军哥 lnmp的安装日志传了帮忙看看

作者: licess 时间: 2016-5-6 10:41
标题: 回复 3# 的帖子
可以按2楼方法修改配置试试看

看mysql端口是开了，ps aux|grep mysql|grep -v grep 看有mysql进程吗？

登陆不上提示什么信息？

另外可以卸载后重新安装mysql 5.7别禁用innodb

欢迎光临 VPS侦探论坛 (https://bbs.lnmp.com/)