Ubuntu下解决:Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
解决办法:
sudo rm /var/lib/mysql/ -Rsudo rm /etc/mysql/ -Rsudo apt-get autoremove mysql* --purgesudo apt-get remove apparmor #这一步选Yessudo apt-get install mysql-server mysql-common #重新输入密码
然后重新登陆:
mysql -u root -p
以上是参照:[/sinat_36246371/article/details/59491905]
参照链接
这时可能会遇到:
解决办法:
sudo vim /etc/mysql/mysql.conf.d/f
1 [mysqld]2 #3 # * Basic Settings4 #5 user = mysql6 pid-file = /var/run/mysqld/mysqld.pid7 socket = /var/run/mysqld/mysqld.sock8 port = 33069 basedir = /usr10 datadir = /var/lib/mysql11 tmpdir = /tmp12 lc-messages-dir = /usr/share/mysql13 skip-external-locking14 character-set-server=utf815 collation-server=utf8_general_ci16 skip-grant-tables<-- add here
添加:
skip-grant-tables
作用:就是让你可以不用密码登录进去mysql。
保存:wq,退出。输入:service mysql restart,重新启动mysql。
参照链接