我的问题开始于我不能再以root用户身份登录mysql安装.我试图在没有打开密码的情况下运行mysql...但每当我执行命令时
# mysqld_safe --skip-grant-tables &
我再也回不到提示了.我试着跟着these instructions to recover the password.
屏幕如下所示:
root@jj-SFF-PC:/usr/bin# mysqld_safe --skip-grant-tables
120816 11:40:53 mysqld_safe Logging to syslog.
120816 11:40:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
而且我没有收到开始键入SQL命令重置密码的提示.
当我按下CTRL键杀死它时,我会得到以下信息:
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
如果我重试该命令并将其保留足够长的时间,我确实会收到以下一系列消息:
root@jj-SFF-PC:/run/mysqld# 120816 13:15:02 mysqld_safe Logging to syslog.
120816 13:15:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120816 13:16:42 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
[1]+ Done mysqld_safe --skip-grant-tables
root@jj-SFF-PC:/run/mysqld#
但如果我try 以root用户身份登录,请执行以下操作:
# mysql -u root
我收到以下错误消息:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
我查过了,/var/run/mysqld/mysqld.sock
号文件不存在.文件夹有,但文件没有.
此外,我不知道这是否有帮助,但我跑了find / -name mysqld
次,结果是:
/var/run/mysqld - folder
/usr/sbin/mysqld - file
/run/mysqld - folder
我不熟悉Linux和MySQL,所以我不知道这是否正常.但我会把这些信息包括进来,以防万一.
I finally decided to uninstall and reinstall mysql.
apt-get remove mysql-server
apt-get remove mysql-client
apt-get remove mysql-common
apt-get remove phpmyadmin
按照上述相同顺序重新安装所有软件包后,在phpmyadmin安装过程中,我遇到了相同的错误:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
所以我再次try 卸载/重新安装.这一次,在我卸载了这些包之后,我还手动将所有mysql文件和目录的各自位置重命名为mysql.bad
.
/var/lib/mysql
/var/lib/mysql/mysql
/var/log/mysql
/usr/lib/perl5/DBD/mysql
/usr/lib/perl5/auto/DBD/mysql
/usr/lib/mysql
/usr/bin/mysql
/usr/share/mysql
/usr/share/dbconfig-common/internal/mysql
/etc/init.d/mysql
/etc/apparmor.d/abstractions/mysql
/etc/mysql
然后我又试着重新安装mysql-server
和mysql-client
.但我注意到它不会提示我输入密码.它不是应该要求管理员密码吗?