Error Message:
Error: ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
Solution:
Open the my.ini file in the MySQL directory, add a line skip grant tables after [mysqld] of the file, save and close the file (in Linux) /etc/my.cnf）
Similar Posts:
- [Solved] MYSQL Install and Login Error: Access denied for user ‘ODBC’@’localhost’ (using password: NO)
- [Solved] Access denied for user ‘ODBC’@’localhost’ (using password: NO)
- Mysqldump backup problems got error: 1045, error 1045 (28000), got error: 1449
- mysql ERROR 1044 (42000): Access denied for user ‘
- [Solved] MYSQL ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘mys…
- MYSQL Login Error: mysqladmin: connect to server at ‘localhost’ failed
- MySQLAccess denied for user ‘root’@’localhost’ [How to Solve]
- Linux Login MYSQL Error: ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
- ERROR 1044 (42000): Access denied for user ‘root’@’localhost’
- mysql 1449 The user specified as a definer does not exist