mysql 登陆不了
请各位大神和军哥帮忙看看！用lnmp1.2安装过程中,没有发现什么问题。lnmp status
+-------------------------------------------+
| Manager for LNMP, Written by Licess |
+-------------------------------------------+
| http://lnmp.org |
+-------------------------------------------+
nginx (pid 26738 26737 26735) is running...
php-fpm is runing!
鈼[0m mysql.service - LSB: start and stop MySQL
Loaded: loaded (/etc/init.d/mysql)
Active: active (running) since Thu 2016-09-22 12:10:07 CST; 2h 17min ago
CGroup: /system.slice/mysql.service
鈹溾攢26769 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/var --pid-file=/usr/local/mysql/var/VM-201-117...
鈹斺攢26887 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error...
Sep 22 12:10:03 VM-201-117-debian systemd: Starting LSB: start and stop MySQL...
Sep 22 12:10:03 VM-201-117-debian mysql: Starting MySQL
Sep 22 12:10:07 VM-201-117-debian mysql: .....
Sep 22 12:10:07 VM-201-117-debian systemd: Started LSB: start and stop MySQL.
可是，用mysql -u root -p 一直提示：ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
用脚本想要修改root密码，然后提示：ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'
/tmp/mysql.sock会被删除。重启服务器，会重新新成mysql.sock。重置密码的时候还是一样删除文件一样报问题。 Installing MySQL system tables...
ERROR: 1004Can't create file '/tmp/#sql966_1_0.frm' (errno: 9)
160921 17:01:37 Aborting
安装lnmp的时候，mysql数据表就没安装上
ls -lsahd /tmp 看一下，权限不是777的胡 chmod 777 /tmp 一下
再就是看一下ls -lsahd /usr/local/mysql/var 的权限
建议使用1.3进行安装 原帖由 licess 于 2016-9-22 18:45 发表 https://bbs.vpser.net/images/common/back.gif
安装lnmp的时候，mysql数据表就没安装上
ls -lsahd /tmp 看一下，权限不是777的胡 chmod 777 /tmp 一下
再就是看一下ls -lsahd /usr/local/mysql/var 的权限
建议使用1.3进行安装 ...
这个需要重新安装mysql吧？
回复 3# 的帖子
没有单独重装mysql的脚步，你可以自己单独安装试试或卸载后重新安装lnmp
页:
[1]