700字范文,内容丰富有趣,生活中的好帮手!
700字范文 > Ubuntu下解决:Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

Ubuntu下解决:Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

时间:2022-09-24 21:03:04

相关推荐

Ubuntu下解决:Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

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。

参照链接

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。