且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

SQLSTATE [HY000] [1045]用户' root' @' localhost'的访问被拒绝(使用密码:否)(SQL:从"rooms"订单中按"order_by" asc选择*)

更新时间:2022-04-16 03:53:23

我也遇到了这个问题,如果您的密码字符串包含#(例如Test123#)的功能",则一切正常,您的DB_USERNAME或DB_PASSWORD5.8或更高版本将#视为注释定界符,因此将您的密码重写为DB_PASSWORD ='Test123#'及其工作方式.它对我有用.

I also faced this issue, every thing is fine your DB_USERNAME or DB_PASSWORD, if you your password string contains # (for eg. Test123#) "feature"of 5.8 or above it treat # as comment delimiter, so rewrite your password as DB_PASSWORD='Test123#' and its works. it work for me.