军哥求帮忙紧急看下

0000005 发表于 2015-7-21 15:27:36

我是 debian系统安装了一键包后    发现 mysql无法远程管理输入密码也提示禁止登陆
Add php-fpm service at system startup...
update-rc.d: using dependency based boot sequencing
Starting php-fpm ERROR: An another FPM instance seems to already listen on /tmp/php-cgi.sock
ERROR: FPM initialization failed
failed
============================== Check install ==============================
Checking ...
Nginx: OK
MySQL: OK
PHP: OK
PHP-FPM: OK
+------------------------------------------------------------------------+
|       LNMP V1.2 for Debian 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: dgf5shgkifd                      |
+------------------------------------------------------------------------+
+-------------------------------------------+
| Manager for LNMP, Written by Licess |
+-------------------------------------------+
|          http://lnmp.org          |
+-------------------------------------------+
nginx (pid 1230 1229 1228 1227 1226) is running...
php-fpm is runing!
MySQL running (3066).
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 0.0.0.0:22          0.0.0.0:*             LISTEN
tcp    0    0 0.0.0.0:3306          0.0.0.0:*             LISTEN
tcp6    0    0 :::22                :::*                LISTEN
Install lnmp V1.2 completed! enjoy it.
root@CS150721001:~/lnmp1.2-full# reboot

Broadcast message from root@CS150721001 (pts/0) (Tue Jul 21 15:16:24 2015):
The system is going down for reboot NOW!
root@CS150721001:~/lnmp1.2-full#
login as: root
root@ip's password:
Server refused to set all environment variables
Linux CS150721001 2.6.32-5-amd64 #1 SMP Sun Sep 23 10:07:46 UTC 2012 x86_64

Welcome to aliyun Elastic Compute Service!

Last login: Tue Jul 21 14:44:38 2015 from 110.80.24.50
root@CS150721001:~# ls
lnmp1.2-full       lnmp-install.log
lnmp1.2-full.tar.gzreset_mysql_root_password.sh
root@CS150721001:~# mysql -uroot
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
root@CS150721001:~# netstat -an
Active Internet connections (servers and established)
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 0.0.0.0:22          0.0.0.0:*             LISTEN
tcp    0    0 0.0.0.0:3306          0.0.0.0:*             LISTEN
tcp    0    0 ip:22       ip:61551    ESTABLISHED
tcp    0    0 ip:22       ip:61638    ESTABLISHED
tcp6    0    0 :::22                :::*                LISTEN
udp    0    0 0.0.0.0:54968       0.0.0.0:*

licess 发表于 2015-7-21 21:48:32

可以使用密码重装脚本重置一下mysql root密码
http://lnmp.org/faq/lnmp-1-2-tools.html

lnmp默认就是禁止远程连接的，可以论坛搜索“mysql 远程” 查找方法

0000005 发表于 2015-8-4 17:44:57

回复 2# 的帖子

军哥，我又重新安装了 2次，出现了一个同样的问题
数据库输入密码无法登陆，
进入数据库安全模式升级密码提示没有选择数据库

0000005 发表于 2015-8-4 17:46:31

回复 2# 的帖子

No database selected

licess 发表于 2015-8-4 20:10:56

某些特别环境下有设置不是root密码的情况，一般密码就是空

一般使用重置密码脚本就不会有问题
用升级脚本提示没有数据库选择还是？

id886 发表于 2015-8-6 08:32:09

楼主用的是 mysql 5.1 么？

我测试了2个VPS，在选择mysql 5.1 版本时，就会存在密码不正确问题，也无法重置。系统是debian 系统。

其它系统，其它mysql版本未测试。因为一般是小内存VPS只装 debian + mysql5.1

LNMP 1.1不存在这问题。

页: [1]

VPS侦探论坛's Archiver