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,
[mysqld]
sql-mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
sql-mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
For more reference: https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
Comments (0)