当前位置: 首页 >数据库 > Running MYSQL 5.7 By Bash On Ubuntu On Windows:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Running MYSQL 5.7 By Bash On Ubuntu On Windows:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

root@PC-RENGUOQIANG:/usr/sbin# /etc/init.d/mysql start* Starting MySQL database server mysqld [ OK ]root@PC-RENGUOQIANG:/usr/sbin# ps -ef | grep mysqlmysql 171 1 0 11:58 ? 00:00:00 /bin/sh /usr/bin/mysqld_safemysql 641 171 0 11:58 ? 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 --log-syslog=1 --log-syslog-facility=daemon --log-syslog-tag=root 740 7 0 13:47 tty1 00:00:00 grep --color=auto mysq

 

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) - 国内版 Bing
https://cn.bing.com/search?FORM=U227DF&PC=U227&q=ERROR+2002+(HY000)%3A+Can%27t+connect+to+local+MySQL+server+through+socket+%27%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock%27+(2)

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) - 乐于改变 - CSDN博客
https://blog.csdn.net/lmss82/article/details/4414178

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) - LaMw - 博客园
https://www.cnblogs.com/Lam7/p/6090975.html

MYSQL错误解决:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)-云栖社区-阿里云
https://yq.aliyun.com/articles/44934

phpmyadmin - ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) - Stack Overflow
https://stackoverflow.com/questions/11657829/error-2002-hy000-cant-connect-to-local-mysql-server-through-socket-var-run

Can’t connect to local MySQL server through socket_数据库技术_Linux公社-Linux系统门户网站
https://www.linuxidc.com/Linux/2018-05/152246.htm

 

文件相关路径:

MySQL
https://help.ubuntu.com/lts/serverguide/mysql.html

Ubuntu中MySQL5.7设置utf8编码格式步骤 - 为了、梦想 的博客 - CSDN博客
https://blog.csdn.net/qq_32144341/article/details/51318390

ubuntu彻底删除mysql,并重装 - weixin_41918841的博客 - CSDN博客
https://blog.csdn.net/weixin_41918841/article/details/82993537

 

root@PC-RENGUOQIANG:~# cat /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/root@PC-RENGUOQIANG:~# cat /etc/mysql/mysql.conf.d/mysqld.cnf

 

作者:任国强
来源链接:https://www.cnblogs.com/rgqancy/p/11429291.html

版权声明:
1、JavaClub(https://www.javaclub.cn)以学习交流为目的,由作者投稿、网友推荐和小编整理收藏优秀的IT技术及相关内容,包括但不限于文字、图片、音频、视频、软件、程序等,其均来自互联网,本站不享有版权,版权归原作者所有。

2、本站提供的内容仅用于个人学习、研究或欣赏,以及其他非商业性或非盈利性用途,但同时应遵守著作权法及其他相关法律的规定,不得侵犯相关权利人及本网站的合法权利。
3、本网站内容原作者如不愿意在本网站刊登内容,请及时通知本站(javaclubcn@163.com),我们将第一时间核实后及时予以删除。





本文链接:https://www.javaclub.cn/database/118553.html

分享给朋友:

“Running MYSQL 5.7 By Bash On Ubuntu On Windows:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)” 的相关文章

mysql递归查询 2022年06月06日 18:26:30
MySQL 查询结果中增加字段的方法 2022年06月07日 10:05:05
Mysql 查询结果赋值到变量 2022年06月07日 12:35:42
MySQL基本查询 2022年06月15日 12:06:53
mysql null 优化 2022年06月15日 17:15:21