Access denied for user 'root'@'localhost' (using password: YES)

最新推荐文章于 2025-11-18 15:41:21 发布

原创最新推荐文章于 2025-11-18 15:41:21 发布 · 580 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql

数据库专栏收录该内容

1 篇文章

订阅专栏

本文介绍了一种常见的MySQL登录问题及其解决方案。当尝试使用root用户登录MySQL时，出现Access denied错误。通过调整登录命令，去掉密码输入提示，直接完成登录。文章详细描述了这一过程及登录成功的状态。

登录MySQL执行命令

mysql -u root -p

出现了 Access denied for user 'root'@'localhost' (using password: YES)

解决方法，将命令改为

mysql -uroot

成功

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.41 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.