Sometimes, due to carelessly forgetting the password or installation errors, the following errors will be reported when running MySQL:
ERROR 1045 (28000): Access denied for user ‘ODBC’@‘localhost’ (using
password: NO)
According to the solution on the Internet:
or modify the configuration file my.ini
skip-grant-tables
To skip password verification
or: edit my.cnf,
But the above is useless. After trying to spit blood, I found that I could not even start MySQL service by modifying the configuration file, but so on….. Isn’t there a landing<
after clicking 
, I found that I can change the password directly here
change the password to my own setting, I set it to 123456, log in again, success
Read More:
- MySQL startup problem (ERROR 1045 (28000): Access denied for user’ODBC’@’localhost’ (using password: NO))
- Error 1045 (28000): access denied for user ‘root’ @’localhost ‘(using password: no)
- ER_ACCESS_DENIED_ERROR: Access denied for user ‘root‘@‘localhost‘ (using password: NO)
- Error 1045 (28000): solution to access denied for user ‘root’ @’localhost ‘(using password: no)
- Idea access denied for user ‘xxx’ @ ‘localhost’ solution
- Solve MySQL error 1698 (28000): access denied for user ‘root’ @’localhost ‘
- Error 1045 (28000) access denied for user ‘root’ @’localhost ‘appears in MySQL under Windows system
- MySQL connection error access denied for user ‘root’ @ ‘localhost‘
- Error code 1045, state 28000, Java sql.SQLException :Access denied for user ‘root’@’localhost’
- ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘mysql’
- Linux-mysql8.0 password reset problem – error 1396 (HY000): Operation alter user failed for ‘root’ @’localhost ‘
- Remote: http basic: access denied, fatal: authentication failed for error resolution: wrong password
- MySQL Access denied
- [MySQL] error 1396 (HY000): Operation create user failed for ‘MySQL’ @’localhost ‘
- 【docker】 denied: requested access to the resource is denied
- HTTP Basic: Access denied
- MySQL password setting error message: error 1054 (42s22): unknown column ‘password’ in ‘field list’
- [solved] sql30082n security processing failed with reason “24” (“user name and / or password invalid”)
- Error in Git operation: http basic: access denied solution
- Git report HTTP Basic: Access denied