linux登录mysql报错ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)...

心已赠人 2023-02-24 11:12 128阅读 0赞

[精选30+云产品，助力企业轻松上云！>>> ![hot3.png][]][30_ _hot3.png]

# 1. 你可以尝试换种方式登录一下你的mysql #

**首先你要确保你的mysql服务是启动的**

开启mysql:   systemctl start mysqld.service
    关闭mysql:   systemctl stop mysqld.service
    如果你的不需要加d就不加

**复制密码,不要手动输入,避免输入错误**

查看默认密码命令: 
    grep 'temporary password' /var/log/mysqld.log
    直接鼠标选中下面框住的密码,鼠标右键即可复制(注意:不要复制到前面的空格)

![up-2aaa612dad96072fefe9f9f5873a4af9804.png][]

## 方式一: ##

我是用这种方式就会报这个错误:
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

![up-d3f937228b1925fab93f5b3d6182605940a.png][]

## 方式二: ##

使用这种方式登录却成功了
    注意: 密码是隐藏的,复制一下就可以了,我们肉眼看不到。

![up-3313a83ef4aaca78cb93a6aa021d7984bc1.png][]

## 修改密码 ##

登录成功后,输入如下命令
    set password=password("你的密码")
    
    可以设置密码的长度(因为如果密码太短的话不行,输入如下命令即可解决密码太短问题)
    set global validate_password_policy=0;
    set global validate_password_length=1;

[hot3.png]: /images/20230209/30e4cbb093f947e78c1aa54fbe4b5381.png
[30_ _hot3.png]: https://www.oschina.net/action/visit/ad?id=1221
[up-2aaa612dad96072fefe9f9f5873a4af9804.png]: https://oscimg.oschina.net/oscnet/up-2aaa612dad96072fefe9f9f5873a4af9804.png
[up-d3f937228b1925fab93f5b3d6182605940a.png]: https://oscimg.oschina.net/oscnet/up-d3f937228b1925fab93f5b3d6182605940a.png
[up-3313a83ef4aaca78cb93a6aa021d7984bc1.png]: https://oscimg.oschina.net/oscnet/up-3313a83ef4aaca78cb93a6aa021d7984bc1.png

linux登录mysql报错ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)...

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 MySQL for Linux错误 ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: YES

相关 HIVE-ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)

相关 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:YES)

相关解决ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

相关 mysql用户授权报错:1045 Access denied for user 'amp'@'%' (using password: YES)

相关 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

相关 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

相关解决mysql：ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: NO/YES)

相关解决ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

相关远程服务器Linux错误 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES）