When you executes some queries if you may get an error: ER_ACCESS_DENIED_ERROR, errno:1045, sqlMessage:Access denied for user,

If you may get an error as below while executes some queries in MySQL server,

Detail - {"code":"ER_ACCESS_DENIED_ERROR","errno":1045,"sqlMessage":"Access denied for user 'usernmae'@'hostname' (using password: YES)","sqlState":"28000","fatal":true}

In MySQL server can operate different sql modes and apply those modes differently for different clients based on the value sql_mode set.

You have to set the sql_mode in your my.cnf file like below,


For more reference: https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html