MySQL报错'ERROR 2002 (HY000): Can't connect to local MySQL server through'
短信预约 -IT技能 免费直播动态提醒
登陆数据库保存
[root@localhost Percona-Server-5.6.34-rel79.1-Linux.x86_64.ssl101]# bin/mysql -h localhost -P 3306 -uroot -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
查看数据库用户
[root@localhost Percona-Server-5.6.34-rel79.1-Linux.x86_64.ssl101]# bin/mysql -h localhost -P 3306 -uroot -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
查看数据库用户
mysql> select host, user from mysql.user;
+-----------------------+----------------+
| host | user |
+-----------------------+----------------+
| % | ADMGEMALTO |
| % | MGRGEMALTO |
| % | TECHADMGEMALTO |
| localhost | ADMGEMALTO |
| localhost | MGRGEMALTO |
| localhost | TECHADMGEMALTO |
| localhost | root |
| localhost.localdomain | root |
+-----------------------+----------------+
8 rows in set (0.00 sec)
解决方法：
+-----------------------+----------------+
| host | user |
+-----------------------+----------------+
| % | ADMGEMALTO |
| % | MGRGEMALTO |
| % | TECHADMGEMALTO |
| localhost | ADMGEMALTO |
| localhost | MGRGEMALTO |
| localhost | TECHADMGEMALTO |
| localhost | root |
| localhost.localdomain | root |
+-----------------------+----------------+
8 rows in set (0.00 sec)
解决方法：
免责声明：
① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的，并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据，供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。
② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
MySQL报错'ERROR 2002 (HY000): Can't connect to local MySQL server through'
下载Word文档到电脑，方便收藏和打印～
下载Word文档
猜你喜欢
mysql提示Can't connect to MySQL server on localhost (10061)如何解决
今天小编给大家分享一下mysql提示Cant connect to MySQL server on localhost (10061)如何解决的相关知识点，内容详细，逻辑清晰，相信大部分人都还太了解这方面的知识，所以分享这篇文章给大家参考一
2023-07-05
解决 Can’t connect to local mysql server through socket ‘/tmp/mysql.sock’ (2) |#2002
我安装的是lnmp0.7一键安装包，之前一直正常使用。可是今日重启了一下nginx后，奇怪的问题出现了：
Discuz X2出来错误：
[Type] 无法连接到数据库服务器
[2002] Can’t connect to local MyS
2022-05-28
2022-07-06 mysql报错：ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysq
2023-09-18
ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock‘
2023-09-06
Mysql出现问题：ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/data/mysql/my解决方案
回城传送–》《数据库问题解决方案》 ❤️作者主页：小虚竹 ❤️作者简介：大家好,我是小虚竹。Java领域优质创作者?，CSDN博客专家?，华为云享专家?，掘金年度人气作者?，阿里云专家博主?，51CTO专家博主? ❤️技
2023-08-18
启动MySQL报错:ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost&apos
这个错误是新手经常会遇到的，本文主要介绍如何修复ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061) 解决方案: 1、登录到安装Mysql的主机，打开cmd命令行工具，
2014-12-13
解决MySQL启动报错:ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
这个错误是新手经常会遇到的，本文主要介绍如何修复ERROR 2003 (HY000): Can't connect to MySQL server on ‘localhost' (10061)
解决方案:
1、登录到安装Mysql的主机，打
2022-05-14
![[mysql]mysql8修改root密码](https://static.528045.com/imgs/17.jpg?imageMogr2/format/webp/blur/1x0/quality/35)
