我在Ubuntu 12.04 LTS (Precise穿山甲)上安装了LAMP，然后在phpMyAdmin上设置根密码。我忘记密码了，现在无法登录。当我试图通过终端更改密码时，我得到:
错误2002 (HY000):无法通过套接字连接到本地MySQL服务器 ' / var /运行/ mysqld / mysqld。袜子”(2)
我该如何解决这个问题?我无法打开LAMP，卸载它或重新安装它。
当前回答
在我的情况下，我的问题是，我试图从我的linux终端访问，而不是从我的docker容器与mysql。
其他回答
我尝试了以下步骤:
以超级用户登录或使用sudo 使用gedit打开/etc/mysql/my.cnf 找到bind-address，并将其值更改为数据库服务器主机的IP地址。对我来说，是localhost或127.0.0.1 保存并关闭文件。 回到终端，执行sudo service mysql start
这对我很有效。
This error can also occur if you try to change the directory where the database is stored, but imput the wrong directory in the configuration file (like a typo in the second drive as D instead of the accurate D_). Instead of telling you the typo directory does not exist, it will tell you that you lack permission to access it (leading you to try to change the permissions for the typo directory, which it will let you do). So if you get this error while changing directories, double check the configuration file and make sure you don't have a typo.
在我的情况下，它是磁盘已满，mysqld不能再启动。
尝试重新启动mysql服务。
> service mysql restart
or
> service mysql stop
> service mysql start
如果它不识别停止命令，那么它肯定是磁盘空间。您应该在mysql分区中分配一些空间或使磁盘更大。
检查磁盘空间
> df -h
在我的情况下，我不能访问mysql，经过3天的研究，我有一个解决方案。这是一个完美的解决方案，因为我已经搜索了/var/run/mysqld/mysqld.我和袜子没有找到文件夹。可以在putty上执行以下命令。
sudo mkdir /var/run/mysqld/
sudo chown -R mysql:mysql /var/log/mysql
sudo mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --socket=/var/run/mysqld/mysqld.sock
sudo /etc/init.d/mysql restart
你会节省宝贵的时间。
在我的情况下，似乎我不能真正杀死mysql进程，当我运行
sudo service mysql stop
ps -ef | grep mysql
mysql进程一直在那里，看起来它阻塞了套接字文件，新的mysql进程不能自己创建它。
这很有帮助
cd /var/run
sudo cp mysqld/ mysqld.bc -rf
sudo chown mysql:mysql mysqld.bc/
sudo service mysql stop
sudo cp mysqld.bc/ mysqld -rf
sudo chown mysql:mysql mysqld -R
sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &
现在我能够登录数据库使用
mysql -u root
然后更新root密码:
UPDATE user SET authentication_string=password('YOURPASSWORDHERE') WHERE user='root';
FLUSH PRIVILEGES;
PS:我在更新根密码时遇到了麻烦，似乎是“auth_socket”插件的问题，所以我必须创建具有完整权限的新用户
insert into user set `Host` = "localhost", `User` = "super", `plugin` = "mysql_native_password", `authentication_string` = NULL, `password_expired` = "N", `password_lifetime` = NULL, `account_locked` = "N", `Select_priv` = "Y",
`Insert_priv` = "Y", `Update_priv` = "Y", `Delete_priv` = "Y", `Create_priv` = "Y", `Drop_priv` = "Y", `Reload_priv` = "Y", `Shutdown_priv` = "Y", `Process_priv` = "Y", `File_priv` = "Y",
`Grant_priv` = "Y", `References_priv` = "Y", `Index_priv` = "Y", `Alter_priv` = "Y", `Show_db_priv` = "Y", `Super_priv` = "Y", `Create_tmp_table_priv` = "Y", `Lock_tables_priv` = "Y",
`Execute_priv` = "Y", `Repl_slave_priv` = "Y", `Repl_client_priv` = "Y", `Create_view_priv` = "Y", `Show_view_priv` = "Y", `Create_routine_priv` = "Y", `Alter_routine_priv` = "Y",
`Create_user_priv` = "Y", `Event_priv` = "Y", `Trigger_priv` = "Y", `Create_tablespace_priv` = "Y";
这将创建一个没有密码的用户“super”，然后你可以连接mysql -u super
