解决MySQL问题：ERROR 1045 (28000): Access denied for user ‘ODBC‘@‘localhost‘ (using password: NO)

小咪咪 2022-11-05 05:26 93阅读 0赞

# 项目场景： #

项目场景：使用MySQL8.19,通过使用Windows10命令行打开mysql

--------------------

# 问题描述： #

mysql已经在后台运行，输入mysql -version报错  
ERROR 1045 (28000): Access denied for user ‘ODBC’@‘localhost’ (using password: NO)  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY0OTk5Nw_size_16_color_FFFFFF_t_70]

--------------------

# 原因分析： #

通过报错信息，我们可以清楚地看到：(using password: NO)，没有使用密码。我们没有登陆而直接执行MySQL命令

--------------------

# 解决方案： #

先登录，再运行

mysql -uroot -p

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY0OTk5Nw_size_16_color_FFFFFF_t_70 1]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY0OTk5Nw_size_16_color_FFFFFF_t_70]: /images/20221023/542787e25def4a39bb5a3cb078810656.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY0OTk5Nw_size_16_color_FFFFFF_t_70 1]: /images/20221023/ef9fe48124d24aaaaca7f4c7beaeaa45.png

解决MySQL问题：ERROR 1045 (28000): Access denied for user ‘ODBC‘@‘localhost‘ (using password: NO)

发表评论取消回复

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

相关阅读

相关完美解决ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: NO)

相关解决MySQL问题：ERROR 1045 (28000): Access denied for user ‘ODBC‘@‘localhost‘ (using password: NO)

相关 HIVE-ERROR 1045 (28000): Access denied for user 'root'@'%' (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:YES)

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

相关解决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)