首页 文章

怨恨mysql密码结果:ERROR 2002(HY000):'t connect to local MySQL server through socket ' /var/run/mysqld/mysqld.sock'(2)

提问于
浏览
0

我一直收到错误:

ERROR 2002(HY000):无法通过套接字'/var/run/mysqld/mysqld.sock'连接到本地MySQL服务器(2)

尝试通过终端连接到MySQL时 .

我已经完成了两个教程:

官方一:https://help.ubuntu.com/community/MysqlPasswordReset

而不是官方的:https://coderwall.com/p/j9btlg/reset-the-mysql-5-7-root-password-in-ubuntu-16-04-lts

创建文件 /var/run/mysqld/mysqld.sock 实际上在赋予它权限 chown -R mysql /var/run/mysqld chown -R mysql /var/run/mysqld/mysqld.sock 后工作,然后我可以登录到终端中的mysql并更改我的主用户和root用户的密码 .

再次运行 sudo /etc/init.d/mysql startsudo /etc/init.d/mysql restart 后 - 无法使用我的用户名和密码连接到mysql .

service mysql status
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: active (running) since Mon 2018-05-07 12:00:51 IDT; 43s ago
  Process: 11057 ExecStartPost=/usr/share/mysql/mysql-systemd-start post (code=exited, status=0/SUCCESS)
  Process: 11042 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
 Main PID: 11056 (mysqld)
    Tasks: 13 (limit: 4915)
   Memory: 103.3M
      CPU: 464ms
   CGroup: /system.slice/mysql.service
           └─11056 /usr/sbin/mysqld

May 07 12:00:20 Softwatch systemd[1]: Starting MySQL Community Server...
May 07 12:00:51 Softwatch systemd[1]: Started MySQL Community Server.

关注这篇文章:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2)

当再次运行 sudo /etc/init.d/mysql start 结果时,重新启动mysql并不像在帖子的乞讨中提到的那样:

sudo /etc/init.d/mysql start
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
sh: 0: getcwd() failed: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
[....] Starting mysql (via systemctl): mysql.servicejob-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
[ ok job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
.
sudo service mysql start
sh: 0: getcwd() failed: No such file or directory

完全重新安装MySQL是不可接受的 .

其中一位评论者说:

应将客户端设置为与服务器设置一致 . [客户]
port = 3306
socket = /var/run/mysqld/mysqld.sock

的[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306

这很奇怪,因为在我的目录 /var/run/mysqld/ 中, mysqld.sock 文件以某种方式被删除,并且在我的 /etc/mysql/my.cnf 文件中没有任何类似的内容:

#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# 
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
#bind-address = 127.0.0.1

如何正确稳定我的MySQL登录?为什么会这样?

运行:

Distributor ID: Ubuntu
Description:    Ubuntu 17.10
Release:    17.10
Codename:   artful

1 回答

  • -1

    你还在面对这个问题吗?可能不是,但类似的事情发生在我身上,我意识到虽然查询运行正常但它没有影响任何行......我修改了查询以仅匹配'localhost'并且工作正常:

    UPDATE mysql.user SET authentication_string = PASSWORD('YOURNEWPASSWORD'),plugin ='mysql_native_password'WHERE User ='root'AND Host ='localhost';

相关问题